cancel
Showing results for 
Search instead for 
Did you mean: 

Filtered Value in Reports

Former Member
0 Kudos

Hi all,

I have a requirement where in whenever a user filters on any characteristic in the report a dynamic text should appear on a screen which says, "Report filtered by - XXXX".

I tried using info item and dynamic filters but that doesnt serve my purpose , because they are always visible on the screen even if the data is not filtered on any characterictic.

Can anyone please help me with this.

Any ideas or suggestions will be very helpfull.

I promise to assign points for helpfull answers.

Thanks in advance,

Vivek

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

If you are using the web application designer, the "filter" web item could be entered above the query results. The properties of the "filter" could be set to always show by removing the checkmark from "collapsed".

If you are not using a web template, a simple BEX query that has the first object placed in the rows section would sort the results by the characteristic which the user entered via a variable. The column heading could be changed to be anything that you want it to say.

Former Member
0 Kudos

Hi Sharon,

Thanks for the response.

But the requirement is not to have the filter item on the template but to display only those values that are filtered as text.

Any other ideas .

Thanks in advance,

Vivek

Former Member
0 Kudos

"Report filtered by - XXXX". "XXXX" means username that used this report or the characteristic value that user selected??

Former Member
0 Kudos

This meane the characteristic values that the user has selected.

Thanks,

Vivek