none
overriding format in a tablix column

    Question

  • Hi.  I run 2012 enterprise and have a tablix with 6 different numeric columns.  I'd like to override the numeric format on some of these depending on the row label.  I dont see a way to make this decision a function.   Is there a way?
    • Edited by DB042189 Thursday, January 16, 2014 3:56 PM spelling
    Thursday, January 16, 2014 3:56 PM

Answers

  • Then you can use an expression for setting format

    like below

    =IIF(Fields!RowGroup.Value = "<first value>","<format1 string>","<format2string>")

    if you want exact expression post us the field names and also formats you want output to come


    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    • Marked as answer by DB042189 Thursday, January 16, 2014 8:00 PM
    Thursday, January 16, 2014 4:24 PM
  • great but i dont see anywhere to enter that expression.  I click text box properties and see no fx option in the number panel.  Maybe you want me to choose expression above text box props...i'll try that.

    I see number>custom>expression so i think that answers one of my questions.

    • Edited by DB042189 Thursday, January 16, 2014 5:14 PM found part of the answer
    • Marked as answer by DB042189 Thursday, January 16, 2014 8:00 PM
    Thursday, January 16, 2014 4:33 PM
  • I added a column called DisplayText to my proc that is a c0,n0 or p.  i added it as a bogus row group and went with this expression on all...

    =Fields!DisplayFormat.Value




    • Edited by DB042189 Thursday, January 16, 2014 5:35 PM follow up
    • Marked as answer by DB042189 Thursday, January 16, 2014 8:00 PM
    Thursday, January 16, 2014 4:58 PM

All replies

  • Are row labels coming from a field value? ie is there a row group applied or are they static

    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs


    • Edited by Visakh16MVP Thursday, January 16, 2014 4:09 PM
    Thursday, January 16, 2014 4:05 PM
  • yes, field values which are used as row groups.
    Thursday, January 16, 2014 4:14 PM
  • Then you can use an expression for setting format

    like below

    =IIF(Fields!RowGroup.Value = "<first value>","<format1 string>","<format2string>")

    if you want exact expression post us the field names and also formats you want output to come


    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    • Marked as answer by DB042189 Thursday, January 16, 2014 8:00 PM
    Thursday, January 16, 2014 4:24 PM
  • great but i dont see anywhere to enter that expression.  I click text box properties and see no fx option in the number panel.  Maybe you want me to choose expression above text box props...i'll try that.

    I see number>custom>expression so i think that answers one of my questions.

    • Edited by DB042189 Thursday, January 16, 2014 5:14 PM found part of the answer
    • Marked as answer by DB042189 Thursday, January 16, 2014 8:00 PM
    Thursday, January 16, 2014 4:33 PM
  • I added a column called DisplayText to my proc that is a c0,n0 or p.  i added it as a bogus row group and went with this expression on all...

    =Fields!DisplayFormat.Value




    • Edited by DB042189 Thursday, January 16, 2014 5:35 PM follow up
    • Marked as answer by DB042189 Thursday, January 16, 2014 8:00 PM
    Thursday, January 16, 2014 4:58 PM