crystal reports : cannot determine the queries necessary to get data for this report

Question

I've recently come across the following error in one of my crystal reports following an accounting system update.

Group #1: ? - A : This group section cannot be printed because its condition field is nonexistent or invalid. Format the section to choose another condition field.

I've verified every database field being used to ensure it still exists for consistency and checked the formulas for that section. No dice. So to hopefully fix the problem, i remove the section using the Section expert. I run the same database checks. It then complains with the same error for Group #5. So i remove that as well.

now I have a new and unusual error when i attempt to run 'Show Query'.

the error is: "Cannot determine the queries necessary to get data for this report"

I have tried to logon/logoff the database and verify database. No complaints until i try to run, show query. When I attempt to run the report, it also throws the same error.

any ideas? Am I approaching this incorrectly? this is done in crystal reports 10.

note: this report is run with the sql sa user to eliminate any permission issues.

Answer 1

This means that the field that defined the group is no longer in the report.

To fix this, right click the group and select 'Change Group...', then choose the appropriate field.

Answer 2

I figured it out. I ended up rebuilding the entire report and re-inserting the same fields into the report along with rebuilding the groupings. Once I did that and compared the multiple linkings, it turns out some of the table linkings were removed for some reason.

Answer 3

put the page number and try again