all groups > sql server reporting services > july 2007 >
You're in the

sql server reporting services

group:

Select All and OLAP



Select All and OLAP RSDev
7/31/2007 9:28:42 PM
sql server reporting services: I am using Reporting Services (2005 sp2) to display data from an Analysis
Services (2005 sp2) cube. I am using parameters and have a few questions in
regards to the Select All option that is available in the multi-select
parameters that I have.

1) Is it possible to remove the Select All from the list?

2) If it is not possible to remove Select All, is there a way to
programtically determine if the Select All option was selected in a cell on
the report using an expression?


The reason for this is because the selected parameters need to be diplayed
in the report header for the report. If the Select All option is selected,
the client would like to see the word "All" in the report hearder, not every
single item in the list printed out in the report header. I would like to
remove the Select All option and simply add in the [All] member from the
dimension, that way if All is selected then the word All will be displayed
in the report header, but to do this I have to have a way to remove the
Select All option.


Any thoughts on this?


Thank you

Re: Select All and OLAP RSDev
8/2/2007 12:17:16 AM
No comments from anyone? Cmon!


[quoted text, click to view]

Re: Select All and OLAP Al
8/2/2007 12:59:13 PM
I'm not sure if it is possible to remove the "Select All" from the list
(Microsoft just recently readded that feature) but if you have an "All"
member in your dimension you can do the following:
1) Drag a text box onto the header.
2) Make the value of the text box be "=Parameters!YourParameter.Label(0)".
This will pick up the first item in the array and show the label for it
which hopefully will be your "All" member unless you have sorted the list
differently.

HTH,

Al




[quoted text, click to view]

AddThis Social Bookmark Button