Jump to content


Change default number of rows in a Report


  • Please log in to reply
No replies to this topic

#1 danwaterloo



  • 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