Report Builder Multi-value parameter textbox expression

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » Report Builder Multi-value parameter textbox...

Report Builder Multi-value parameter textbox expression

Rate Topic

Display Mode

Topic Options

Author

Message

agnetha_11

Posted Tuesday, December 04, 2012 9:00 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, June 14, 2013 3:14 PM
Points: 13, Visits: 73

Hi,

I have a distinct list of state-county parameter and a text box that displays this value if selected.

How do I create an expression that is (Select all) is selected then display 'All' rather than every state-county name being displayed.

=IIf(IsNothing(Parameters!pStateCounty.Value), "All", Parameters!pStateCounty.Value)

this expression is not working since a multivalue parameter cannot be set to null and I get an (error)

Thank you.

Post #1392559

Ray M

Posted Wednesday, December 05, 2012 9:29 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Today @ 12:42 PM
Points: 1,468, Visits: 941

The only thing I think you can do is compare the number of selected items to the total number of items.

iif(Parameters!pStateCounty.Count = Count(Fields!StateCounty.Value, "MyStateCountyDataSetName"),"All", Join(Parameters!pStateCounty.Label, ",")

Edit Spelling Cool

Post #1393080

agnetha_11

Posted Wednesday, December 05, 2012 8:47 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, June 14, 2013 3:14 PM
Points: 13, Visits: 73

Thank you for your response. I used your expression with 'countdistinct' and it worked great.

Post #1393308

« Prev Topic | Next Topic »

Permissions