Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Subreport data not displaying in main report. Post Reply Post New Topic
Author Message
Prabhatk08
Newbie
Newbie


Joined: 04 Nov 2012
Online Status: Offline
Posts: 1
Quote Prabhatk08 Replybullet Topic: Subreport data not displaying in main report.
    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?
IP IP Logged
shanth
Groupie
Groupie


Joined: 06 Aug 2012
Location: United States
Online Status: Offline
Posts: 75
Quote shanth Replybullet 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
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.014 seconds.