| |
ActiveReports for .NET Support
Started by CHolland at 12-09-2009 2:24 PM. Topic has 8 replies.
  
|
|
Sort Posts:
|
|
|
|
 12-09-2009, 2:24 PM
|
CHolland
Joined on 12-10-2009
Posts 4
|
Different Data display in PDF vs Excel
|
|
|
|
|
|
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?
|
|
|
|
|
Report
|
|
|
|
|
12-10-2009, 4:49 AM
|
Amit Pal
Joined on 12-11-2008
Posts 855
|
Re: Different Data display in PDF vs Excel
|
|
|
|
|
|
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
|
|
|
|
|
Report
|
|
|
|
|
12-10-2009, 12:11 PM
|
CHolland
Joined on 12-10-2009
Posts 4
|
Re: Different Data display in PDF vs Excel
|
|
|
|
|
|
|
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.
|
|
|
|
|
Report
|
|
|
|
|
12-10-2009, 1:42 PM
|
PrantikS
Joined on 12-11-2008
Posts 1,550
|
Re: Different Data display in PDF vs Excel
|
|
|
|
|
|
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
|
|
|
|
|
Report
|
|
|
|
|
12-14-2009, 12:05 PM
|
PrantikS
Joined on 12-11-2008
Posts 1,550
|
Re: Different Data display in PDF vs Excel
|
|
|
|
|
|
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
|
|
|
|
|
Report
|
|
|
|
|
12-14-2009, 12:13 PM
|
CHolland
Joined on 12-10-2009
Posts 4
|
|
|
|
|
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.
|
|
|
|
|
Report
|
|
|
|
|
12-15-2009, 12:28 PM
|
PrantikS
Joined on 12-11-2008
Posts 1,550
|
Re: Different Data display in PDF vs Excel
|
|
|
|
|
|
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
|
|
|
|
|
Report
|
|
|
|
|
12-16-2009, 2:02 PM
|
CHolland
Joined on 12-10-2009
Posts 4
|
Re: Different Data display in PDF vs Excel
|
|
|
|
|
|
|
This seems to be a partial solution to my problem. The line shows up but off center. Still its a start. \
Thank you
|
|
|
|
|
Report
|
|
|
|
|
12-17-2009, 4:55 AM
|
AashishB
Joined on 12-11-2008
Posts 818
|
Re: Different Data display in PDF vs Excel
|
|
|
|
|
|
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
|
|
|
|
|
Report
|
|
|
|
|
GrapeCity » Product Support » ActiveReports f... » Different Data display in PDF vs Excel
|
|
|
|
|