Crystal Reports : Set Database location - Crash

Using CR: 9.2.2

there is a report that am i trying to verify against the database, when i go Database > Verify Database it works fine, however the designer of the report wants to me to also verify the sub-reports and claims that the above method only verifies the main report against DB.

so he asked me to go Database -> set database location to have the "Sub Reports" also verified against DB. when i do that, the whole CR crashes ??? any idea what is causing this?

Thank you,
Raul77Asked:
Who is Participating?
 
JayConverseConnect With a Mentor Commented:
Just right-click on the subreport to edit it, then set database location again.
0
 
JayConverseCommented:
Crystal will do that, it happens in 7.x, 8.x, and even 11.x.  Do the subreports separately.
0
 
Raul77Author Commented:
Thanks for the reply, can you please let me know how to do the sub-reports??? not an expert when it comes to CR :)
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
Raul77Author Commented:
Where can i see the sub-report to right click on it though? on my report explorer all i see is the actual report, but when the designer sent me screenshot when he goes to Database > set DB location, he sees the sub-reports, any other way to access the sub-reports?

Thanks for your help.
0
 
JayConverseCommented:
I don't know what to say, you either find them on the report canvas, or select them from the report explorer.
0
 
mlmccConnect With a Mentor Commented:
Verify is supposed to check the subreports also, there shouldn't be a reason to check the subreports separately.

The subreport will look like any other object or field on the report.
When you mouse over it you should see Subreport:Subreport Name

mlmcc
0
 
mlmccCommented:
FYI, you can close this through the ACCEPT MULTIPLE SOLUTIONS link in a comment

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.