Problem with groups in CR9

[Former Member]

Hi. We have a VC++ 6.0 application that uses Crystal Reports 8.5 with RDC and ReportCreationAPI. We're trying to update it to Crystal Reports 9.

Some of our reports use groups and formulas calculating the Sum of some field in a group.

The dynamic data of the report is passed with formulas (for small fields) and CDO (based on ttx files, for detail fields)

When the datasource used for grouping in a report has no records it works good in CR8.5, it just leaves all this fields and sums blank. With Crystal Reports 9 it thows exceptions "This group section cannot be printed because its condition field is nonexistent or invalid. Format the section to choose another condition field" or "this field name is not known" (if there are sum formulas on this fields).

Any solution?

Thanks

[former_member11696 · Accepted solution]

Hello,

Try setting location in the Report Designer first. Then once you get that working then do the same steps in code.

Lots of changes between 8.5 and 9 so you may need to verify all your reports first in the Designer. Or at least find the common routine to do so in code.

Thank you

Don

[Former Member]

Thanks for the answer, althought I don't understand it at all. In report designer we have the location to the ttx file. We don't use any direct connection to database. The data is passed to the report using a CDO object filled with data inside de code, with the AddRows and SetDatasource functions.

With Crystal Reports 8.5 if I execute the SetDatasource method without adding any rows to the datasource then it behaves in some way (leaving in blank the fields associated with this datasource (even if they are part of a group) and Sum formulas base on this fields.

With Crystal Reports 9 it behaves in a different way, throwing this exceptions. I could detect the case in which the datasource will not have any row and try to insert at least a blank record to avoid this exceptions, but the result is still different that with Crystal Reports 8.5 (numeric fields with "0" instead of "", problems with formulas that make calculations or divisions with that numbers...)

[former_member11696]

Hello,

Lots of changes to the database connection and parameter API's between 8.5 an 9. Have a look at the samples by clicking on the Businessobjects tab and samples above.

Thanks again

Don