Multiple formats for the same cell?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2008 Development » Multiple formats for the same cell?

Multiple formats for the same cell?

Rate Topic

Display Mode

Topic Options

Author

Message

mmiller 85218

Posted Thursday, February 07, 2013 1:59 PM

Grasshopper

Group: General Forum Members
Last Login: Thursday, February 07, 2013 3:23 PM
Points: 17, Visits: 17

I am wondering if this is even possible....

I have a parameter that lets the user select various options, all starting with either 'Count' or 'Amount'

This then feeds into a matrix with Program as the row and Date as the column with the paramter metric they selected in the table.

I want to format the cell to either currency if they select an 'amount' parameter or numerical if they select 'Count'

Is this possible and if so, how would I go about doing it?

Post #1417346

mmiller 85218

Posted Thursday, February 07, 2013 3:23 PM

Grasshopper

Group: General Forum Members
Last Login: Thursday, February 07, 2013 3:23 PM
Points: 17, Visits: 17

I figured it out, and it was much easier than I thought :)

=iif(left(Parameters!Search.Value,6) = "Amount","'$'#,0","#,0")

Post #1417373

« Prev Topic | Next Topic »

Permissions