How to relate parameters between reports?

Question

How to relate parameters between reports?

malavika.ramanathan

SSCrazy

Points: 2790
More actions
April 18, 2010 at 9:30 pm

#139681

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.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

happycat59 One Orange Chip Points: 29387 More actions · Answer 1

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.

malavika.ramanathan SSCrazy Points: 2790 More actions · Answer 2

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?

happycat59 One Orange Chip Points: 29387 More actions · Answer 3

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.