cancel
Showing results for 
Search instead for 
Did you mean: 

Help needed with missing data problem in CRVS2010

donbenson
Explorer
0 Kudos
66

We recently upgraded the reporting engine in our product to use Crystal Reports for Visual Studio 2010 (previously engine was CR9). Our quote report, which has numerous subreports and lots of conditional formatting, started losing data when a quote took more than a single page to be printed. We knew the SQL results included the data, but the report was not printing those lines at all or sometimes printing a partial line. In addition, the running total on the report would exclude the lines that were being missed on the next page. In one example submitted by a customer, 3 lines were skipped between pages.

I think I have identified two potential issues that document the possibility of data not being included in the report.

The first potential issue is an issue with the "suppress blank section" option being checked. This issue is supposedly fixed with ADAPT01483793, being released someday with service pack 2 for CRVS2010.

The second potential issue is using shared variables. This issue is supposedly fixed with ADAPT01484308, also targeted for SP2.

Our quote report does not explicitly use shared variables with any of the subreports, but it does have several subreports, each in its own section that has the "supress blank section" option checked. We have other reports that use this feature, as well, and they are not exhibiting the problem.

One different thing about the quote report is that it has a section with multiple suppression options selected. The section has a conditional suppression formula, which controls whether the section is included at all within the report. The section also has the suppress blank section option selected. There are multiple fields within the report that are each conditionally suppressed. In theory, the section's suppress formula could evaluate to true, yet all of the fields within the section are suppressed (due to null values), and then the "suppress blank section" option would kick in.

The missing data only seems to happen when the section is not being suppressed, and at least one of the fields is being included in the report. If I clear the "suppress blank section" check box, and change the section formula to also include the rules applied to the fields in the section, the missing data problem seems to be resolved.

Is this related to ADAPT01483793? Will it be fixed in service pack 2?

If more details are needed, I would be happy to provide a sample report with stored data.

View Entire Topic
0 Kudos

Moved to .NET SDK forum

Do you see the same behaviour if you run/Preview the report in .NET IDE?

Don

donbenson
Explorer
0 Kudos

Yes. The missing data problem occurs when I open the report in the VS2010 IDE. At runtime, the problem with missing data happens in preview and when printing directly to the printer. Exporting to CSV is fine, as well exporting "data only" to Excel. Exporting to Word, RTF, PDF, or Excel (with formatting) is missing data.

The running total on the report is incorrect as well. It does not include the lines that were skipped.

This particular report prints the quote lines in group header sections. The section that I think is contributing to the problem is a GH2 section. The group tree in the previewer shows all the lines. But when you click on any of the lines that are missing (there are three of them in my test case), the preview just goes to the first page with nothing selected.

In CR9, the problem does not occur (using the same data source). We also tried CR2008 (12.2.0.290), and it does not exhibit the problem.

Edited by: Don Benson on Oct 24, 2011 10:05 AM

0 Kudos

Hi Don,

Have a look at the Record Selection formula in CR Designer ( stand alone ) and when exported to RPT format opening that report in the Designer also.

There's been a few issues with => logic in the record selection formula. It could be you are running into this problem. Look for NOT inserted into your selection formula.

Oh and SP2 is coming out shortly so it may resolve the issue. But if you want you could purchase a support, or if you have a support contract then create a case in SMP and get a rep to work with you to debug the issue.

If you have not try the Trial Version of CR 2011, put it on a VM-ware image or Test PC so you don't corrupt anything for production and have a look at and test it in that designer also. If you purchase a case and it is a bug then you'll get a credit back for the case.

Don

Edited by: Don Williams on Oct 26, 2011 7:40 AM

donbenson
Explorer
0 Kudos

Thanks for the info, Don.

This report does not have any record, group, or saved data selection formulas.

We are eagerly awaiting SP2. The MouseMove error is driving our customers batty. I am fairly confident the report will work with this fix since CR2008 works, and it already has the fixes that will be in SP2.

In the meantime, we have worked around the problem by unchecking the suppress blank section and adding logic to the suppress formula for the section that mirrors the logic suppressing the individual objects within the section.

Using the suppress blank section on sections that only contain a subreport does not seem to cause any issues in SP1.

0 Kudos

Hi Don,

Just to clarify also, the Mouse Movement error has also been fixed by installing the latest Video card drivers on their PC's.

It's an issue in the GDIPLUS.dll which belongs to Microsoft. There have been a few escalations I've done that our Developers have mark the Escalation as "Not CR issue".

You may want to get your users to install the latest drivers. A few posts in in here and in the Report Design Forum have noted that fixed issues or that type of problem.

Don