Skip to Content
0
Former Member
Mar 23, 2010 at 07:58 PM

Problem with subreport

27 Views

Hello,

I have a report that runs fine in Crystal Report but produces an error in our .net application. (We use MySQL with ODBC connector.)

The report prints data for a period, between two dates selected by the user at print time. If there is no data for the period, the empty report prints without error but if there are any, I get the following error:

u201CCannot determine the queries necessary for this report. Failed to retrieve data from the database.u201D

I managed to narrow down the cause: my report has a group A and a sub-group B. There is a sub-report in the group B footer. The field links of my sub-report comprise u201Cparameter-likeu201D links to both groups (as it should) and the two date parameters. If I remove the 2 links related to the groups, it prints without error, but, of course, I do not have the accurate data.

I use Crystal Report 2008. (12.2.0.290)