Project and Portfolio Management Practitioners Forum
cancel

Export to Excel not exporting all of the obtained results

Highlighted
Bharath_Kumar
Respected Contributor.

Export to Excel not exporting all of the obtained results

Hi,

 

we are using the OOB export to excel jsp to export the data from Reports, however the export does not extract all records.

 

To detail this. if a report is run and the resultant of this query is at around 1000 records, the Ctrl+A selection from html file will have 1000 records whereas the Excel file created by using the JSP gives less records say 650.

 

Please let us know if this is known issue or anything which you can help us in resolving.

 

thanks

Bharath

2 REPLIES
Oscar_Pereira
Honored Contributor.

Re: Export to Excel not exporting all of the obtained results

 

Could you please confirm if the following workaround helps ?

 

1. Retrieve the report record from the "Reports --> View Reports" menu. Type in the "Report#" on the bottom half of the screen then click on the Search button.
A report record should be returned showing a link to the report, its submission details and its log.
2. Right-click on the Report# hyperlink and select "Save Target As...".
3. Pick a location to save the file. Change the file type from HTML to "All Files". Rename the filename with extension ".xls
4. Click on the Save button.

 

 If the above does not make a difference, please provide the following details:


1-Does it happen only for a specific report?  if you test other report export, do you get the same limit of rows as 650 ?
2-What is the MS Excel version and sp ? make sure you are running a supported version

3-Please provide the steps that you are performing for this report export?  is it just clicking in the Export to Excel button in the Report? or same steps as followed in the workaround...

 


Thanks
Oscar Pereira

Bharath_Kumar
Respected Contributor.

Re: Export to Excel not exporting all of the obtained results

Thanks Oscar for your reply. Please find below the answers to your queries, hope I get a resolution/fix on this issue.

 

1-Does it happen only for a specific report?  if you test other report export, do you get the same limit of rows as 650 ?

Yes, this is happening on only one specific report and with specific filter. The Portlet with same filters specified shows the same number of requests and the export to excel functionality on Portlet is able to list out all requests. However the same is not working with this custom report

 

2-What is the MS Excel version and sp ? make sure you are running a supported version

Its MS-Excel 2007.

 

3-Please provide the steps that you are performing for this report export?  is it just clicking in the Export to Excel button in the Report? or same steps as followed in the workaround...

 

Run the custom Report and once the HTML report is generated. Click on Export to Excel link on report(which in turn uses the OOB JSP file) which exports limited number of requests.