locked
SSRS Reports Header Expression RRS feed

  • Question

  • How to show only "%" in Third column in SSRS Matrix Table,
    how to write Expression in SSRS.

    ch.kishore

    Friday, October 6, 2017 1:12 PM

Answers

  • Hi Guys,
    Don't worry, I Got The Answer use Below Expression Working Fine.
    =IIf(Fields!Date.Value.ToLowerInvariant().Contains("%"),"%",Fields!Date.Value)


    ch.kishore

    • Marked as answer by kishore.ch Sunday, March 18, 2018 1:15 AM
    Sunday, March 18, 2018 1:15 AM

All replies

  • Hi Kishore.ch,

    What specific result would you like to get? You mentioned to show only "%" in the column, currently, there are "300.00" and "33.33" in the column. If you want to get results like the screenshot, you can write expression like 

    (Fields!Aug-17Count.Value-Fields!Jul-17Count.Value)/Fields!Jul-17Count.Value

    You could also change the data displaying format by Text Properties >> Number 

    Please give more details if I misunderstand the issue.

    Best Regards,

    Henry 

    Monday, October 9, 2017 1:53 AM
  • There seems to an issue using IIF directly

    Write expression of Jul-17-Aug-17 as below:

    =IIF(IsNothing(Fields!Jul-17 Count.Value) OR Fields!Jul-17 Count.Value=0.00,"NA",FORMAT((Fields!Aug-17 Count.Value-Fields!Jul-17 Count.Value)/IIF(Isnothing(Fields!Jul-17 Count.Value) OR Fields!Jul-17 Count.Value=0.00,1,Fields!Jul-17 Count.Value),"P2"))

    Hope that helps.

    Regards,

    Eshwar.


    Please don't forget to Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful. It will helpful to other users.


    • Edited by Eswararao C Monday, October 9, 2017 6:28 AM
    Monday, October 9, 2017 6:06 AM
  • Hi,

    If you would like to make the column name "Jul-17-Aug-17(%)" become "%" only, since you are using the matrix, the "Jul-17-Aug-17(%)" is not actually the column header, but the field from the dataset. So, it is not possible to make it using the expression, instead, it is required to modify the original dataset, make "Jul-17-Aug-17(%)" into "%" in the dataset. 

    For example, I have a matrix like 

    timex is a field. 

    If I want to make "May 2017" become "2017", it is required to modify the data in the dataset. 

    Best Regards,

    Henry 

    • Proposed as answer by Henry Jiang Tuesday, October 10, 2017 1:04 AM
    Monday, October 9, 2017 6:38 AM
  • Hi Henry Thanks For Your Reply But I am Not understanding Your steps,
    IF You possible please share step by step ,It's Very urgent.

    Thanks In Advance

    ch.kishore

    Sunday, March 18, 2018 12:56 AM
  • Hi Eshwar ,Thanks For Your Reply But I am using Matrix Report that is not working,
    If any posibility's to show Only (%) column,Please share

    Thanks In Advance

    ch.kishore

    Sunday, March 18, 2018 12:59 AM
  • Hi Guys,
    Don't worry, I Got The Answer use Below Expression Working Fine.
    =IIf(Fields!Date.Value.ToLowerInvariant().Contains("%"),"%",Fields!Date.Value)


    ch.kishore

    • Marked as answer by kishore.ch Sunday, March 18, 2018 1:15 AM
    Sunday, March 18, 2018 1:15 AM