Print Page | Close Window

Subreport linked but empty

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16859
Printed Date: 26 May 2024 at 11:02pm


Topic: Subreport linked but empty
Posted By: trentz
Subject: Subreport linked but empty
Date 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!


Replies:
Posted By: hilfy
Date 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


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

Posted By: trentz
Date 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!


Print Page | Close Window