Set Page Name in Excel export of SSRS based on Column Value < or >

Question

I am exporting a report from SSRS to Excel. I have grouped the data into two (2) pages in SSRS based on whether the value of a single column is less than zero (0) or not. I want to name one sheet in Excel "Less than zero" and the other "Between zero and 180".

I am using the following expression in the PageName area of the Properties window for my table:

=IIF(Fields!DAYS_TIL_SOL.value<0,"Less_Than_Zero","Between_Zero_And_180")

That expression names the first sheet correctly, but the second sheet remains the same with "(2)" added.

excel tabs

I tried reversing the expression, =IIF(Fields!DAYS_TIL_SOL.value >=0,"Less_Than_Zero","Between_Zero_And_180"), but that resulted in the same naming phenomenon with "Between_Zero_And_180 (2)" instead.

How do I make the page names unique based on the groups I have set? Thanks!

JAG · Accepted Answer · 2024-08-06 18:32:26Z

1

Used same expression in the Group PageName. Selected the group which brought up the properties window for the Tablix Member.

answered Aug 6, 2024 at 18:32

JAG

215 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Set Page Name in Excel export of SSRS based on Column Value < or >

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related