Need to display "No Selection" in the Page-By Attributes values

[ArunKKK]

Hi,

I have a requirement, where in, in the attribute "Class" a part of the Page-By section. It has 10 distinct codes, and we want to add "No Selection" as a 11th value in the list. Scenario would be - if user selects "No Selection", then there will not be any "Class" filter selection to be put on to the Report, and if the user selects any Class code value other than "No Selection", then it will be put as Class filter selection on the Report SQL.

Any help or hints would be appreciated.

Thanks a lot in advance.

 

[entaroadun]

Create a consolidation. Create elements for each of your 10 classes, and an 11th element that equals the sum of your 10 classes. Use the consolidation in the report template.