Joined: 08 Feb 2014
Online Status: Offline
Posts: 19
Topic: Breaking the join parameter for two sub reports Posted: 10 Feb 2014 at 5:26am
I have a main report with two sub reports. All have
parameters (ie Month/Year). I need these parameters separate for each report
and they are but somehow unknowingly it combined the parameter for the year for
the two sub reports. I need to reflect data from different years.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 10 Feb 2014 at 5:31am
is that it combined it, or that you specified the value in the links to the subreports?
If you are using the parameter from the main report to link to the subreports, then the values will all be the same. if you are using a table.field as the link, I would check that the value in the subreport matches the value in the main report...just to make sure the correcgt value is being passed.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 10 Feb 2014 at 5:43am
perhaps you should add some. How is the subreport supposed to know what you want? How does the subreport filter the data that it is retrieving from the database?
Joined: 08 Feb 2014
Online Status: Offline
Posts: 19
Posted: 10 Feb 2014 at 5:49am
The two
sub reports are basically identical. They each have a set of 3 parameters (Jurisdiction,
Month, Year) I run the reports side by side in group footer on the main report to
evaluate different time frames.
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