Hi
I want to set up a ReportStudio report where i can dynamically sort on choosen a field (via a prompt).
The Report is base on a dimensional datasource.
i already managed to set up the order by (with the MDX order function), but if i try to dynamically set this up it does not work.
for example 1:
order([Staff Name]; roleValue('_memberCaption', [Staff Name]); basc) -> this works
example 2:
order([Staff Place]; roleValue('_memberCaption', [Staff Place]); basc) -> this works to
But
for example:
Case ?Order_by?
When 1 then order([Staff Name]; roleValue('_memberCaption', [Staff Name]); basc)
When 2 then order([Staff Place]; roleValue('_memberCaption', [Staff Place]); basc)
END
-> this does not work
Anybody any ideas?
Thanks
Problem solved!
I use somthing like this:
order([Staff Name]; #prompt('Sort_by','token')#;#prompt('Sort_order';''token')#)