I seem to have done something wrong with a report that I have in MS SQL 2005, using SSRS.
The master report is a matrix report that groups unfilled purchase orders by year and month on one axis, and by the purchaser on the other axis. It then does a count in each data 'segment'. There are no parameters.
All is well and good so far, and it produces the right results.
The drilldown report is a link of each segment that goes to a child report that shows the detail of all the purchase orders that occur in that time segment by that user. When the data is entered manually into this subreport it works fine.
The problem is that I can't set up the parameters from the master report to be passed through to the child report correctly. Initially the child report was based on Date and Purchaser, but I've since re-written it to be based on PurchaseOrderNumber using the multivalue variable @POList
What code should I use to pass the multiple values through to the child report?
Your help would be gratefully accepted.
asked Jun 03 '10 at 04:02 AM in Default
You simply pass the multivalue variable to the child report. Then depends what you need to do with the variable. If you need to pass the ID to a query, function or stored procedure, then you need to pass it as string of comma delimitted values.
This you can achieve this by using the
answered Jun 03 '10 at 04:47 AM
Please check how many values you have in your multi-parameter. You may have too many values. I think by default the maximum value count would be 20, if I remember correctly.
answered Sep 01 '11 at 01:25 AM