1 2 Previous Next 16 Replies Latest reply on Mar 14, 2013 11:08 PM by Naveen Arumugam

    issue showing selected filter value (All) in report title

    Donna Coles

      I have a report with a "Company" filter and users can either see the data for all companies (filter option (All)) or Company 1 or Company 2.  Based on the selection of the filter I want to expose the value of that selection in the prominent report title eg "Company 1 Report" if Company 1 is selected.  I have managed to do this using a calculated field as when (All) is selected I want the title to show 'Group Report' rather than 'All Report'. 

       

      I'm trying to apply logic in my calculated field along the lines of IF <filter field> = "All" THEN"Group" ELSE <filter field>, but I can't get the word "Group" to display.

       

      What is the value stored behind the 'display' value of (All) that I need to compare against?  I've tried "All", "(All)", "", null.

       

      Many thanks in advance

        1 2 Previous Next