Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to relate parameters between reports? Expand / Collapse
Author
Message
Posted Sunday, April 18, 2010 9:30 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 15, 2011 12:09 AM
Points: 140, Visits: 748
hi all,

I have a report which calls a subreport based on the user - id.
in the calling report, on clicking the user name, the sub report for that user-id is taken.
But the subreport is not shown as the parameter value is not passed to it.

I have created a data set for uid in the subreport same as in that of calling report. still it is wrong.

Could you please help? its urgent.
Post #905668
Posted Sunday, April 18, 2010 9:43 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:21 PM
Points: 2,842, Visits: 2,423
When you set up the navigation for the user name field on the report, you need to click on "Parameters" and associate the user name parameter of the sub-report you are calling with the value of the field on the report that is calling the sub-report.


Post #905671
Posted Sunday, April 18, 2010 10:18 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 15, 2011 12:09 AM
Points: 140, Visits: 748
Thanks! I could solve it. I had to write a condition for no data in subreport.

Now i have to go one more step deeper.
The report i am making is related to a resume manager kind of thing.
The first sheet gives an overview of the report.
the sub report i have made now gives the count of the openings for a particular requirement and the no. of candidates who have posted their resume.

Now the second level of nesting is to be done which gives the stage and staus of the interview process.

Can i call another subreport within my subreport? Or is there any better option?
Post #905684
Posted Wednesday, April 21, 2010 6:21 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:21 PM
Points: 2,842, Visits: 2,423
There is no reason not to add another sub-report and navigate to it from the 1st sub-report. If this is how the work flow seems to work best, I would go for it.


Post #907662
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse