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)