Unselect 'All' when choosing a value in the drop down lista. How?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » Unselect 'All' when choosing a value in the...

Unselect 'All' when choosing a value in the drop down lista. How?

Rate Topic

Display Mode

Topic Options

Author

Message

nicklas.jonsson86

Posted Tuesday, February 12, 2013 6:23 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, February 12, 2013 7:48 AM
Points: 3, Visits: 53

Hi,

I have a problem with a SSRS report where I am using a drop downlist. I have searched on the internet but without any answer on this.
I retrieve the values by using MDX against my SSAS cube.
As always the 'All' option is available and marked as default. I want this option to be unselected when a user choose a value in the drop down list. I have no idea left on how to solve this. Is it even possible to do? VB script ?

Thankful for all kind of input !

Nicklas

Post #1418926

H4K

Posted Thursday, February 14, 2013 3:21 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 4:11 AM
Points: 127, Visits: 507

it can't be achieved, as i had face a similar situation.
The user has to deselect the 'All' when choosing other values.

BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI

Post #1419920

Scott Murray-240410

Posted Friday, February 15, 2013 4:31 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 5:32 AM
Points: 159, Visits: 2,208

As part of the query that populates the parameter, I actually exclude the "ALL" from being returned.. You can do that in the query or in a filter.

Post #1420476

« Prev Topic | Next Topic »

Permissions