How to add a Linked Report?

Question

I developed an RDL file with SSRS 2008 R2 and now I am trying to create a Linked Report based off of it.  However, when I run this report I keep getting the error:

The 'FacilityID' parameter is missing a value

And this is how I configured the parameters for this report.  What did I do wrong here?  FacilityID is the parameter that I am trying to set to default and hide for this linked report.

---

Ryan D

Answer 1

How do you have the linked report configured?  It seems like the report that you are linking from may be passing a null to this parameter.

Mark

Answer 2

The screenshot above are my linked report parameters.  What other configuration items do u want to see?

---

Ryan D

Answer 3

Hi ironryan77,

Have you done any changes on the default report? Please check the basic report with the right FacilityID configured.

Lola

TechNet Community Support

---

Please remember to mark the replies as answers if they help.

Answer 4

I was thinking of your parameter configuration from the parent report where the report action is set up.  How is that configured?

Answer 5

Mark, these are the report parameters for the parent report:

Lola, the basic report does work.  And this FacilityID works also if I design a separate report with just this FacilityID.  But instead I want a linked report so that I do not have to modify both the parent and linked report for each change in the parent report.  Make sense?

---

Ryan D

Answer 6

Sorry for not being clear about this - the page you are showing is not the spot to look at. 

Instead, go to the Textbox properties in the report where you are initiating the report action.  Assuming you have chosen "Go to report" rather than "Go to url," you will see the drill thru report selected in the dropdown for "Specify a Report."  Below that you will see, "use these parameters to run this report:"  My guess is that you will find that you have specified the FacilityID in the parameter column and left the value as blank.  With these settings, you will be passing a blank value to the parameter in the Drill Thru report.  Instead, simply delete this parameter from the Action settings.  Then the default value in your Drill Thru report will be used instead of being overwritten with a blank value.

Mark

Answer 7

Thanks Mark, but this is a Linked Report, not a subreport.  So I don't have a Textbox property initiating this action.  Instead, I want to default one of the report parameters in the parent report so that this subreport will be a unique view of this parent report.  Make sense?

---

Ryan D

Answer 8

Hey Ryan,

In my environment, I created this Linked Report all the time, but have not encounter the problem you are having here. Few options you could try are:

1) in your linked report, simply check the Prompt User box for the FacilityID and when you run it, see what come up.

2) delete the parent report and redeploy them. and re-create the link. You just never know, some xml code might got mixed up.

good luck.

---

Think out of the box

Answer 9

Thanks but I tried both of these and they did not work in this case.  I tried multiple times checking the Prompt User box, but this did not fix it.  And I just deleted the parent report, redeployed it and recreated teh linked report, but this didn't fix it either.

Can one of the Microsoft persons solve this?  Or else can I upload my RDL file or email it to somebody to look at?

Thanks!

---

Ryan D