| Author |
Message |
tin337
Newbie
Joined: 04 Nov 2011
Online Status: Offline
Posts: 11
|
   Topic: Subreport not showing data
Posted: 05 Mar 2012 at 9:44am |
Hi -- I'm in need of some help with a report that someone else created and is not here anymore.
This report have a main report and a sub-report. The subreport's parameters are linked to the main report's values. The main report seems to work fine, but the data set for the subreport is not displaying.
I trying running the subreport by it's self and still no data showing, when I go into the design view of the subreport and click on browse data, it does return the correct data set.
I'm not an advance user of CR and have never use subreports before, so any insights and help is greatly appreciated.
I'm currently using CR 2008
thx...
|
 IP Logged |
|
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 05 Mar 2012 at 11:51am |
check the sub report links
check the sub report select statement
|
|
IP Logged |
|
tin337
Newbie
Joined: 04 Nov 2011
Online Status: Offline
Posts: 11
|
Posted: 05 Mar 2012 at 12:16pm |
|
All the report links look correct to me, they are referencing all the correct data points, and there is no select statement in the subreport, it's a strait data pull from a DB table that contains only 25 lines.
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 05 Mar 2012 at 12:21pm |
1. where is the subreport located in the main report? If it is in a group section what is the grouped on architecture?
2. What are you linking on?
|
|
IP Logged |
|
tin337
Newbie
Joined: 04 Nov 2011
Online Status: Offline
Posts: 11
|
Posted: 05 Mar 2012 at 12:39pm |
It's linking on a year field and an ID field.
The subreport is located in a group #3 of the group section.
again, it seems to be pulling the data because when I'm in the desgin view and browse data, I see the data, it just won't display the data in preview mode.
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 06 Mar 2012 at 6:15am |
I would start by altering or removing the links one at a time and then the select statement parts (in the subreport) one at a time. Refresh after each change to see if any of these make data appear at all. Just becasue they look right does not mean thay are acting as intended and singluar chanegs make for a decent way to check for an issue.
Note that placing the subreport in Group 3 will pass the year field value and the ID field value for the first or last record of that group (first if in the Gheader, last if in the Gfooter). If you drag those fields in the main reports gh or gf you can verify this is the value per group that you want to pass/link on in each run of the subreport
Only other culprit I can think of off hand would be section expert suppression formulas.
|
|
IP Logged |
|
tin337
Newbie
Joined: 04 Nov 2011
Online Status: Offline
Posts: 11
|
Posted: 06 Mar 2012 at 11:26am |
Yep, that was the first thing I tried. Broke down the report to simple pieces to see if it was a linkage issue or an issue with the subreport, but with no luck, was unable to find anything.
But thank you for your time in trying to help, if you can think of anything else, it would be much appreciated.
Thanks…
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 06 Mar 2012 at 11:34am |
|
what is the select statement in the subreport?
|
|
IP Logged |
|
tin337
Newbie
Joined: 04 Nov 2011
Online Status: Offline
Posts: 11
|
Posted: 06 Mar 2012 at 12:01pm |
|
There is no select statement, it's data pull directly from the database table.
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 07 Mar 2012 at 4:02am |
|
usually a link will create a parameter in the sub report ({?pm-xxxxx}) and use that in the select statement.
|
|
IP Logged |
|
|
|
