Print Page | Close Window

Subreport data not displaying in main report.

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17918
Printed Date: 28 Apr 2024 at 4:30pm


Topic: Subreport data not displaying in main report.
Posted By: Prabhatk08
Subject: Subreport data not displaying in main report.
Date Posted: 04 Nov 2012 at 11:47pm

When i run main report then sub report data is not getting displayed (in Preview tab).

When i click on sub report (in Preview tab) then a sub report preview tab opens and data is displayed properly.
 

Reason for not displaying sub report data in the main report:

1.       As per my analysis no database field is used in the main report so when we run the report, report is not connecting to database ( because no database field is used in the main report) hence sub report data also is not getting displayed.

2.       When we click on sub report then it connects to database and data is displayed properly.

3.       When I pulled “SYSDATE”(coming from Business View as "Select SYSDATE from dual") field in the main report just to test then sub report data is also displayed properly (in main report preview tab) but If it is saved and closed and reopen again then it gives some crw32.exe error.

 
Could anyone tell what could be the reason for subreport not displaying data?


Replies:
Posted By: shanth
Date Posted: 05 Nov 2012 at 4:28am
I dont think your point 1 is the reason, probably something with Business views
Try to create shared variables and pass them to main report
or try to pass parameters from main report to sub-reports using sub-links, if you have any

Posted By: hilfy
Date Posted: 05 Nov 2012 at 4:37am

Actually, point 1 is exactly the problem - Crystal won't display data for a subreport if the main report doesn't have any data.  So, setting the main report to select Sysdate easily resolves the problem.

 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window