Jump to content


Photo

Change default number of rows in a Report

report

  • Please log in to reply
No replies to this topic

#1 danwaterloo

danwaterloo

    Newbie

  • Members
  • Pip
  • 7 posts

Posted 19 March 2016 - 11:52 AM

Hi, I'm trying to create a report with more than the default 20 rows. The sql for the report shows a 'limit = 20' on it.
 
I'd like to have 100 rows, so I need to change the value of 20 to 100.
 
Any idea on how to do this?
 
Thanks! Dan
 
select `opportunity`.`id` opportunityid from `opportunity` where (((`opportunity`.`closedate` >= '2016-02-18') and (`opportunity`.`closedate` <= '2016-03-19')) and (`opportunity`.`name` IS NOT NULL)) order by `opportunity`.`name` asc, `opportunity`.`closedate` asc limit 20 offset 0







Also tagged with one or more of these keywords: report

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users