SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How to use 1 rdl report parameter in another rdl - Not about parameter action item


How to use 1 rdl report parameter in another rdl - Not about parameter action item

Author
Message
Karthiart
Karthiart
Valued Member
Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)

Group: General Forum Members
Points: 54 Visits: 186
Hi Friends,

I have a doubt in SSRS.

For ex: I have 4 categories in Healthcare. Say, Kidney, ENT, Bone, Heart. All these 4 categories are stored in 4 tables.

I will run the business rules for Kidney for each month. So i will have some set of outputs for each month. Say, January - 40 records output
February - 20 records as output.
March - 15 records as output.

Altogether 40+20+15= 75 records are there in Kidney table. Like wise for rest of the 3 categories.

I have 2 report rdls.

1. Report A (Its a Summary information with count details)
2. Report B (line level information for the Report A's summary information)

Now,
Report A:

I will select Jan month and Kidney from the respective drop down in SSRS report interface.

Since table name is dynamic, i used dynamic sql to get data for Report A.

From the output, i will click one column (say doctor name), that will call Report B.

Report B will produce results for this particular doctor. Here i have to get the data for that particular month (Parameter name: Month) and the particular Kidney table (Parameter Name: Category) which i selected in Report A.

Here is what, am facing the problem, i cant able to get the parameters declared in Report A(month and category parameters) to be utilized in Report B. Its showing error as Parameter expects value.

I tried these below things:

1. Hide
2. Created shared dataset and used that in Report B. But am getting the parameter expects value error (even i hide or make it internal in Report B).

Please help me here to overcome from this problem.

Regards,
Karthik.

Regards,
Karthik.
SQL Developer.
pietlinden
pietlinden
SSCarpal Tunnel
SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)

Group: General Forum Members
Points: 4870 Visits: 13170
Sounds like you're doing what i used to do - summarizing unnormalized healthcare/oncology data. If you can either normalize your underlying tables or create a stored procedure or view to do it, and use that in your report, your life will be a LOT easier.

I was in a situation like this, and once I bit the bullet and did some programming voodoo to crank out normalized views, the rest was easy. Performance was still terrible, but a "slow" query is faster than a person almost any day...

Can you post your data structure? This just reeks of a really bad underlying design. The whole "4 tables" thing worries me. Once I fixed the mess I was in, I had all the symptom data in one table, and a related "categorization" table, and my summarizing problems went away completely. So your predicament seems eerily familiar...
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search