Reports hide data lines in footer or header

[Former Member]

Hi there,

not sure this is the right section. But I'll try anyhow.

We recently moved our reports from VS2005 to VS2010. The reports worked fine with the old redist package at our clients systems.

Since we migrated to the new development environment and the new redist 13 on the clients systems it seems as if page footers are swalloing up data.

Specificly a invoice document with several positions. if the number of invoice positions is to large to fit on one page, it prints to the bottom of the page, then the footer (which contains a blob field for footer pictures) and continues on the next page. the problem is that between the last row on the first page and the first row of the second page "lines" are missing. No changes have been made to the section expert settings what so ever since the migration.

Pointers into the direction of what might be the problem would be much appreciated. Thanks a lot in advance.

Markus

[former_member183750 · Accepted solution]

Make sure you are using SP1:

[original link is broken]

If SP1 does not help, a link to a screenshot will be good to have to see the issue.

Ludek

Follow us on Twitter http://twitter.com/SAPCRNetSup

Got Enhancement ideas? Try the [SAP Idea Place|https://ideas.sap.com/community/products_and_solutions/crystalreports]

[Former Member · Accepted solution]

Thanks for your help.

Our installed version is 13.0.1.220

I put here two links, one to a PDF of the report with data. You can see on the bottom of the page a few numbered lines. On the following page one line is missing.

http://www.vepos.net/transfer/Sample/Rechnung_RE000756pro.pdf

Here is the original report file as RPT

http://www.vepos.net/transfer/Sample/SalesInvoice_DE.rpt

After a bit more testing the problem seems to be the report header. When the report header is surpressed, all lines are printed.

Thanks for your help!

Edited by: MarkusK. on Jun 7, 2011 10:55 AM

[former_member183750 · Accepted solution]

The rpt has no saved data so there is not much I can do with it to test. If you want, I can contact you via email and you can let me have the report there.

- Ludek

[former_member183750 · Accepted solution]

This issue has been reproduced. (or at least one that looks like it. no telling unless we have a report to test with...) A fix has been added to SP2 for CRVS2010. ETA for CRVS2010 SP 2 is now September 2011.

This issue is only present if shared variables are used in the report.

- Ludek

[Former Member · Accepted solution]

Thank you very much for your answer.

Our reports get the data through a c# dataset. I have to admit that I am not sure on how to provide you with the rpt file including some test data. I saved the report as an RPT-File. Hope that helps.

http://www.vepos.net/transfer/Sample/VK-Rechnung_RE000775pro.rpt

About the shared variable issue, I checked the report. there are no shard variables defined in the report or any of its subreports.

I hope we can somehow pinpoint the source of the issue as waiting till september is not really an option for us or our clients.

Again, thank you very much for your help.

Edited by: MarkusK. on Jun 16, 2011 10:58 AM

[former_member183750 · Accepted solution]

To get me a saved data report, simply export the report to .rpt file format (page to the end of the report to make sure all data is in the report before exporting).

However, somehow, you'll need to convince me that the data is actually in the dataset. One way to test that is to write out the dataset to an XML and point the report at the xml. Does the data show up now? For details of this technique, see the blog [Troubleshooting Issues with VS .NET Datasets and Crystal Reports|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/13270] [original link is broken] [original link is broken] [original link is broken];.

If the report shows the data when you point it at the xml and not when you feed the equal dataset to it, then it will be good to let me have the xml and the "saved data" report.

- Ludek

[Former Member · Accepted solution]

Thanks for the advice. The link to the saved datareport is in the above post.

I will try to provide you with the requested XML file in addition.

Just for your information in the meantime. The missing lines in the above sample are within a single text box. In the sample file you will find the texbox in the Detail Section2 (Datails i)

I will post again as soon as I got the XML output of the dataset.

[former_member183750 · Accepted solution]

Before you send me the XML, use the blog Troubleshooting Issues with VS .NET Datasets and Crystal Reports and test this your self...

- Ludek

[Former Member · Accepted solution]

Thank you, we did test this ourslef extensively. Please not that the exact report with the exact code did work for years with CR for VS2005. the problem occured only since we migrated to CR13 for VS2010.

Linking the Report to the XML file did not get me any error messages or the map field dialogue. I am fairly convinced that this is not an issue of date field missmatch of any kind.

The problem is that for different data I put into the report, whatever is at the page break gets lost. A line out of a single text field as well as a whole Row conisting of several fileds of a single datarow or even a sum that is "generated" in the report.

I know that you need me to convice you that the problem is not caused by ourselfs. I'd do the same with our clients. Please take a look at attached XML File and the report sample I posted above.

here the link to the XML File

http://www.vepos.net/transfer/Sample/test.xml

Thank you for your time.

Markus

[former_member183750 · Accepted solution]

I see the issue comparing the rpt as it looks in CR 2008 and CRVS2010 - with saved data report which as 2 pages.

Unfortunatelly, when I point the report at the XML, I get 11 pages and I have no idea what to look for here...

E.g.; I need an XML file that will have the same data as in the saved data report so that I come out with a 2 page report and then I can compare apples to apples. Comparing a 2 page report to an 11 page report is not working for me.

- Ludek

[Former Member · Accepted solution]

Thanks for your help. The problem is that after the Data is set to the report a lot of sub reports, groupings and other fields and formats are set by the c# code. It is almost impossible to provide you with a report that works without the c# code running over it to look exactly like the one saved in the report viewer with the data.

after some more testing to find a work around we figured that as soon as we use the "page N of M" field or totalPageCount field anywhere in the report, the lines start to disappear in the report. if we don't use it, it works just fine.

-Update- After we removed the totalPageCount it works for displaying in the viewer, saving it to different file formats without the viewer. Only if you print it directly without the going through the viewer it still hides lines. 3-4 lines. I am still absolutely puzzled what actually causes this.

Edited by: MarkusK. on Jun 28, 2011 1:05 PM

-Update- We opened a single Support case with Crystal Report Support. Let's see what happens

Edited by: MarkusK. on Jun 29, 2011 3:48 PM