Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Displaying report filter

Hi,

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?

Former Member
Former Member 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))

HTH

NMG

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question