Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: No data on subreports Post Reply Post New Topic
Author Message
dlabrec
Newbie
Newbie


Joined: 03 Jun 2008
Location: United States
Online Status: Offline
Posts: 20
Quote dlabrec Replybullet Topic: No data on subreports
     Posted: 23 Apr 2010 at 10:12am
I have created a report which contains a main report and several subreports. When I run this report in CR Developer, the report appears to run correctly, the subreports return data.

I've uploaded this report to CR server, and when I run report from server, the main report runs but the subreports don't return any data.

Is there a setting in Central Management Console I need to enable to the subreports to run?

This is my first time using subreports.

Thanks,
David
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 23 Apr 2010 at 10:15am

Do the subreports connect to the same database as the main report?  If not, you'll have to modify the report's properties in the CMC - go to something like Database Configuration.  On the top left there will be a list of all of the db connections used in the report.  Click on each and set the user ID and password.  Then save and try running it again.

 
-Dell
IP IP Logged
dlabrec
Newbie
Newbie


Joined: 03 Jun 2008
Location: United States
Online Status: Offline
Posts: 20
Quote dlabrec Replybullet Posted: 23 Apr 2010 at 11:15am
Thanks for the reply. Yes, the subreports are all on the same database as the main report.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 26 Apr 2010 at 3:32am
Have you checked your links and the selection criteria in the subreports to make sure they're correct?
 
-Dell
IP IP Logged
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