Different Data display in PDF vs Excel

12-09-2009, 2:24 PM

I have an active report application that publishes a financial sheet of employees tax payments.  Recently we came across an error where one user from our data set is not showing up in the Excel Active Report output. His row data is being used and summarized but his specific information is not. Oddly in the PDF version all of the data displays correctly.

Ex in Excel:

SSN               Name   Gross   

###-##-#### Ted       $2,000
###-##-#### Sam      $3,000

Total:                          $9,000

Ex in PDF:

SSN               Name   Gross   

###-##-#### Bob      $4,000
###-##-#### Ted       $2,000
###-##-#### Sam      $3,000

Total:                          $9,000

 

Are there any reasons why Excel would not show a particular person?  Any characters or exceptions it does not like?

Re: Different Data display in PDF vs Excel

12-10-2009, 4:49 AM
Hello,

As far as data is concerned, PDF and Excel export should show the same data.
Which version of ActiveReports for .Net are you using?
Can you please provide us the RDF file of the report. Here is a How to article on how to Save a report as an RDF file:
http://www.datadynamics.com/Help/ActiveReports6/arHOWSaveandLoadReportFiles.html
Amit Pal
GrapeCity- DataDynamics

Re: Different Data display in PDF vs Excel

12-10-2009, 12:11 PM

Hi,

 

The version is 1.0.03705.

 

Unfortunately I cannot provide you a copy of the form.  It is insurance information with names and SSNs.  I can say this report has been running for years and this error seems confined to this one individuals data.  He has a large summary of over $100,000.  That seems to be the only data discrepency I can find for him compared to other people in the report.

Re: Different Data display in PDF vs Excel

12-10-2009, 1:42 PM
Hello,

It would be a little bit difficult for us to understand the reason why the export in PDF export displays properly but the excel export does not without the data to simulate the same. Can you identify any differences between the data that is being displayed and that is not? Moreover, from the build number it seems that you are using ActiveReports 1.0 for COM.

Regards,
Prantik

Re: Different Data display in PDF vs Excel

12-14-2009, 12:05 PM
Also,

Can you send the RPX of the report as well? You would need to go to Report->Save Layout at the top of the VS IDE for this.

Regards,
Prantik

Re: Different Data display in PDF vs Excel

12-14-2009, 12:13 PM

Here is the RPX file.

 

Was my txt file with the data received?  I fear your moderator may have been overly exuberant in my delete request and gotten rid of it.

Re: Different Data display in PDF vs Excel

12-15-2009, 12:28 PM
Hello,

Have you set the UseCellMerging property of the excel export to true? I was able to reproduce some text cutting off from the data you sent by setting this. Please understand that it would be difficult for us to understand the cause of the same until and unless we have the report document(RDF).If you wish, you can upload the file to our FTP site. Moreover, please understand that the Excel Export filter is not 100% what you see is what you get.You may take recourse to the spreadbuilder API and check for results.

Regards,
Prantik

Re: Different Data display in PDF vs Excel

12-16-2009, 2:02 PM

This seems to be a partial solution to my problem.  The line shows up but off center.  Still its a start. \

 

Thank you

Re: Different Data display in PDF vs Excel

12-17-2009, 4:55 AM
CHolland,

I would suggest you to set the MinColumnWidth of the xlsExport equal to the width column(TextBox in the GroupHeader) which has the minimum Width. I tried setting the same to 1.375 in your RPX and got better result.

Regards,
Aashish