Need to display "All" with other elements of a attribute in Page-By

[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 "All" as a 11th value in the list. Scenario would be - if user selectes "All", then there will not be any "Class" filter selection to be put on to the Report, and if the user selctes any Class code value other than "All", then it will be put as Class filter selection on the Report SQL.

One way of doing this is with Custom Group - but that's not the efficient process. Still, in any direction - any help or hints would be appreciated.

Thanks a lot in advance.

 

[nlim]

if your report is not too big, I'd recommend turning on a subtotal. This automatically adds a "total" to the page by that includes all the page-by values.

 

[ArunKKK]

Dear Nlim,

Thanks for the prompt response ! I tried turning on "Total" - I can't see "Total" or "All" added as another code value in the "Page-By" attribute selection. Whis is what we wanted....

Please note that as explained in the problem above, users would want to select "Total" / "All" or other Class Codes values from the page-by attribute pull-down menu.

Please let me know.

 

[nlim]

you need to turn on subtotals.

 

[ArunKKK]

Thanks a lot, nlim. Appreciate your kind help in this matter. Would you mind giving some tips on thread395-783680. - which is "Custom Page Footer for MSTR Report based on the Report File Name".