|
|
|
|
SQL Reporting Services - Answers to your questions
| |
|
Author |
Thread:
"Group by" user-defined string |
|
Gawan
|
"Group by" user-defined string
Posted:
Thursday, April 16, 2009 5:47 PM (GST)
|
|
Hello,
my wish is a little bit hard to explain. I hope someone understands what I want :)
<br>
I have a Dataset called "Values" with 10 columns named col1, col2, col3, ...
The dataset is displayed as it is in a reporting service table.
Now I'd like to group the table by one of these columns ... but variable, the user should be able to choose.
So I create a new dataset called "GroupParameter" and write a select-statement like this:
______________________
select 'col1' as name
union
select 'col2' as name
______________________
In the next step I'd like to group my table by this parameter "GroupParameter" but whatever I do - THIS SEEMS TO BE IMPOSSILE !
Usually I'd have to write as a grouping parameter "=Fields!Values.Name"
but because I'd like to use the Parameter I tried the following combinations:
"=CObj(Parameters!GroupParameter.Value)"
"=(Parameters!GroupParameter.Value).ToString
but it does not work ...
PLEASE help me !
Best regards
Gawan
|
|
|
|
|
|
|
|
|