5 Replies Latest reply on Aug 21, 2013 1:16 PM by Hari_639

Interactive Report - Download to CSV

Sridhars74 Aug 13, 2013 5:26 AM

When i download the outputfrom the Interactive report to a csv file, i am not getting all the rows shown in the report output to the csv file.

For Example: The Results from the Interactive Query is 70000 and the number of lines exported to the csv is only around 12000 rows ans sometimes 18000.

I tried opening the output in Excel 2010 as well in the notepad but only get the partial rows (12K or 18K)

At a whole not getting the full output, is there any setting blocking the output.

BTW I am using APEX 4.2 version.

1. Re: Interactive Report - Download to CSV

Hari_639 Aug 13, 2013 9:51 AM (in response to Sridhars74)

Hello Sridhar,

Please check "Maximum Row Count" value in "Report Attributes". Also please note that, if you apply some filter and try to "Download", then only rows which satisfy filter condition will be downloaded.

Regards,
Hari
Like Show 0 Likes(0)

Actions
2. Re: Interactive Report - Download to CSV

Sridhars74 Aug 13, 2013 11:21 AM (in response to Hari_639)

Hari,
Thanks for your Response.
The Maximum Row count is set to 100K and there are no filters applied.
The Rowcount shows 70K after the report is displayed in the page, but when i download i get only less records.
This happens only when the output rows are high, for lesser rows it works good.
Regards
Sridhar
Like Show 0 Likes(0)

Actions
3. Re: Interactive Report - Download to CSV

Robert Hantink Aug 13, 2013 11:51 AM (in response to Sridhars74)

An earlier version of microsoft Excel could have a row limit of . So try to confirm if it is not your Excel that causes the problems...
Like Show 0 Likes(0)

Actions
4. Re: Interactive Report - Download to CSV

Sridhars74 Aug 13, 2013 12:36 PM (in response to Robert Hantink)

Having the latest version of Excel and also getting only 12k records
Like Show 0 Likes(0)

Actions
5. Re: Interactive Report - Download to CSV

Hari_639 Aug 21, 2013 1:16 PM (in response to Sridhars74)

When you select "Display All" rows in IR, then are you getting all rows in browser?

I remember there is a restriction of size per each row, that it should not cross 32K per row. Check if any of your row is crossing this limit.

Regards,
Hari
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.