July 17, 2008 at 6:37 am
Any assistance/pointers gratefully received!
I've got a matrix with 2 row groups, the second of which is Hidden by default. Thus clicking the first row group opens the second and vv.
The column Totals are linked to another report via parameters generated by the values from the row groups on the selected row.
Eg
RG1 RG2 Total
01 Hidden 300
02 Hidden 200
and with RG2 expanded we see
RG1 RG2 Total
01 1.1 100
1.2 50
1.3 150
02 2.1 45
etc etc
RG1 is a single value parameter P1
RG2 is a multi value parameter P2
In the second example, the drill to the second report works a treat since 02 and 2.1 are seen as the data source values being passed in P1 and P2.
However in the first example, the values that are hidden in the row group are not being built into P2 except for the first value. The data still exists in the data source - it's only the rowgroup that is hidden and that isn't being referenced in the expression to determine the parameter values (Navigation/Parameters).
I've seen numerous referrals on the web to multi value params not being built properly, together with references to Join, Scope, Split in various combinations, but nothing I've tried gets beyond a single value appearing in P2. BTW I have a textbox on the drilled to report showing the multivalue P2 as =Join(P2,",") - that's how I know it's only ever showing 1 value, besides the drilled report not displaying what's expected!
I've also tried determining whether the rowgroup is hidden or not and setting parameters based on the Hidden property but can't seem to reference that in an expression.
Anyone any clues? Surely I can't be alone wanting to use drillable matrixes with hidden toggleable rowgroups?
Many thanks in anticipation..
Andy
August 11, 2008 at 12:23 pm
I am also experiencing a similar problem. Any solutions to this problem would be much appreciated.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply