Batch Printing with parameters

[DaveyCrockett]

Hello fellow developers/sql guru's!

I am somewhat new to SSRS and have been racking my brain for about a month or so without ANY progress!

I am a bit perplexed as to how one could perform a batch print operation for a report that accepts parameters. Let me give you more information though.

I have a report that allows the user to input an ID. That ID is used to look up information based on that Primary Key. Then there is a sub report that uses this parameter to pull more information from a different table.

So, my dilemma is how can I loop through each of these initially passed in ID's, pass each of them into the subreport, then move onto the next.

What I've done with the above report is to make it a subreport that is pulled into another reports list item.

I have changed the WHERE clause to include IN ('val1','val2','val3) etc... but the report is failing on the inner subreport. Traditionally, I would set the parameter value of the subreport to =Parameters!NameOfField.Value, but this fails with this error:

"ERROR: Subreport could not be shown"

I hope this is making sense. If anyone has any other ideas how to do batch printing of a report, I am all ears!

Many thanks and appreciation,


Brian

 

[DaveyCrockett]

This may not be a feasible post, so I may have to rethink how to print a batch.

Thanks,
Brian