'Export' method not working in subreports after MDAC 2.7

[cgv]

Hi, I have a strange one, I think.

I have a small VB app that uses the RDC to Preview, Print, and Export reports against a SQL server database. The VB is primarily used to connect to different databases on the SQL server - and to update the database locations within the report and then execute it. This all works (or worked) fine.

However, after 'upgrading' some unrelated software (which included MDAC 2.7 - Everyone was using 2.5 I think), I have 1 report which will no longer export properly. The report has subreports, and the content of the subreports is not being exported.

The VB program does indeed loop through the subreports and sets the database location appropriately, but as I said, the export function (eg: CRXReport.Export) is not displaying the info anymore. Preview and Print still work fine.

Anyone have any idea which Report designer component handles exporting, or does anyone know of any issues that might be caused by installing MDAC 2.7?

I am using VB6.0, Crystal 8.5.

Thanks for any thaoughts at all.

 

[cgv]

..it seems I fixed the problem.

Something has changed that caused the conditional suppression to stop working as expected. This report has 3 groups that contain subreports. Each group is conditionally supressed.

When the conditional supression on the groups was removed, the report started exporting the data just fine. As always, print and preview work fine.

-S

 

[krishna]

Hi

what was the conditional statement. Was it a database value?

Regards
Krishna Kumar

 

[cgv]

Krishna,

Yes... it was driven by a database field value, and placed in the expression on the 'Supress (no Drill down)' option. Something to the effect of:

{vw_RptActuals.DataType}<>&quot;PO&quot;

Oddly, I remember *needing* the conditional supression, otherwise I would get a blank line even if the subreport contained no data. This does not appear to be the case suddenly.

Again - this behavior only seemed to involve the export function.

Cheers,

Steve R.