tag:blogger.com,1999:blog-2132893136140848212.post3879620672139157451..comments2015-07-30T10:07:04.197-06:00Comments on Martin Giffy D'Souza on Oracle APEX: APEX Reports: No Limit DownloadsMartin D'Souzahttps://plus.google.com/105428851028995295355noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-2132893136140848212.post-6592519258899610532013-05-11T08:05:00.057-06:002013-05-11T08:05:00.057-06:00Just wrap the query in another select statement an...Just wrap the query in another select statement and apply the rownum predicate there (demoed in my previous comment. Hope this helps.Martin D'Souzahttp://www.blogger.com/profile/06992954599899886499noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-50115072720329437752013-04-24T03:46:39.762-06:002013-04-24T03:46:39.762-06:00Hi Martin - did you come up with a solution to wor...Hi Martin - did you come up with a solution to work around the order by issue you mentioned above?<br /><br />Thanks,<br /><br />MikeMikenoreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-18020332360941070752013-01-09T09:38:35.309-07:002013-01-09T09:38:35.309-07:00Brilliant! Just what I needed, and now users can d...Brilliant! Just what I needed, and now users can download CSV reports with all rows without me having to mess with any print report attributes or configuring a print server. THANKS!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-31368313885865146572011-01-04T22:08:48.316-07:002011-01-04T22:08:48.316-07:00A friend of mine pointed out that I have a flaw in...A friend of mine pointed out that I have a flaw in my logic since the rownum will be processed before the order by and therefor the dataset won&#39;t be correct. This test case highlights this issue:<br /><i><br />create table data as<br />select level as column1<br />from dual<br />connect by level &lt;= 10<br />order by dbms_random.value;<br /><br />select column1<br />from data<br />where rownum &lt;= 5<br />order by 1;<br /><br />select *<br />from (<br />select column1<br />from data<br />order by 1)<br />where rownum &lt;= 5;<br /></i>Martin Giffy D'Souzahttp://www.blogger.com/profile/06992954599899886499noreply@blogger.com