Data Connectivity
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Data Connectivity
Message Icon Topic: Subreport linked but empty Post Reply Post New Topic
Author Message
trentz
Newbie
Newbie
Avatar

Joined: 19 Jun 2012
Location: Australia
Online Status: Offline
Posts: 16
Quote trentz Replybullet Topic: Subreport linked but empty
    Posted: 26 Jun 2012 at 1:31pm
I have created a subreport, linked it, and it worked fine. Then when changing some formatting, it no longer worked. I'm not sure what has affected it, but have checked the link, and everything seems fine, except a data-less subreport! Can anyone suggest anything that might stop my frustrated brain from bleeding?!
A world of unexamined lives is a waste of a world!
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 28 Jun 2012 at 4:28am
I do something like the following when I'm debugging subreports:
 
1.  If you're using the report header section of the subreport, create a new one, otherwise use the one that's there.
 
2.  Put the parameters that are created for the links in this header so that you can see the values that are being passed to the subreport.
 
3.  Create a new details section and put a few fields from your data in it.
 
4.  If you've modified the selection criteria to contain more than just the links from the main report, delete everything but the links.
 
5. Run the subreport only - providing valid values for the linking prompts.
 
6.  If you deleted anything in step 4, add the addition criteria back in, one statement at a time, refreshing the subreport for each statement to see if that's what's causing your problem.
 
If you see data from the new sections but not from what was originally in the subreport, then you've got suppression formulas set up that are suppressing the original sections of the subreport.
 
-Dell
IP IP Logged
trentz
Newbie
Newbie
Avatar

Joined: 19 Jun 2012
Location: Australia
Online Status: Offline
Posts: 16
Quote trentz Replybullet Posted: 01 Jul 2012 at 1:09pm
Hi Dell
 
With a bit of perseverence, I've managed to find out where I went wrong; somehow I'd added another dependency field from the main report to the sub report.
 
Thanks.
A world of unexamined lives is a waste of a world!
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.031 seconds.