Displaying report filter
I'm using a "Simple Slider" type input control where it has 4 values. I want to display the report filter of the dimension that has been chosen, in the report. May i pl know the query for the same?
Neil Mitchell-Goodson replied
The method is pretty much the same; use the POS function in tandem with Reportfiltersummary() to deduce where in the Reportfiltersummary() string the Rank_Defects Less than or Equal to text appears:
=Pos(ReportFilterSummary();"Rank_Defects Less than or Equal to")
Once you know this, you need to add the length of this string to it (which is 34 characters, but add one for the following space, so 35). Finally, put this all into a Substr function and wrap in a Trim function to remove any superfluous spaces:
=Trim(Substr(ReportFilterSummary();Pos(ReportFilterSummary();"Rank_Defects Less than or Equal to")+35;2))