• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 718
  • Last Modified:

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,
0
Raul77
Asked:
Raul77
  • 3
  • 2
  • 2
2 Solutions
 
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
 
JayConverseCommented:
Just right-click on the subreport to edit it, then set database location again.
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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
 
mlmccCommented:
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

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now