Im building a report, i make the GROUP BY in the SSRS (not in the DataSET), means that the group created in the SSRS,
now, how can i pass the values of the group to the Drill Down?
p.s - PseudoCOde: the DataSet (build in sql server 2008):
Alter....
Select
...Concat(x) MyX
,DocumentID
,Name
,Age
Group BY DocumentID
In the SSRS my group is MyX, MyX - has the values of 'X' that grouped by DocumentID. now i want to pass the values of MyX to the DrillDown. how can i do it? thanks