Display Filter Prompt Value on Report Header

building reports
1

I am very rusty on this but I vaguely remember there is a formula to display the filter prompt value on the report header. Can someone please help?

Thank you

2

UserResponse is the function that you want to use.

3

Yes, I now remember the UserResponse. But what about just the filter value hardcoded in the query panel?

image

4

Hmm, I’m not sure. If it isn’t a prompt, it may not return anything.
I suppose in this case, you could try using min(Action Time) and see if that is adequate. It could potentially be more recent that 11/11/2024 but it may work.

5

try ReportFilterSummary or QuerySummary

6

If you include the object you’re filtering on in the report you can just use the ReportFilter() function.

7

Thanks guys. However, if I use ReportFilter() like this:
="Action Time >= " + ReportFilter([Action Time])
I got “overflow” error.

And if I use ReportFilterSummary(), I got “computation” error.

Do you know why?

8

Unless I am mistaken, if the filter are applied at query level rather than in the report then ReportFilter will not show them.

QuerySummary will show all the query filters (and other information)

You could try trimming it with something like:

=LeftTrim(Trim(Substr(QuerySummary();Pos(QuerySummary();“Action Time Greater”);Length(QuerySummary()));“)”))

9

Should be RightTrim but meh

=Replace(RightTrim(Trim(Substr(QuerySummary();Pos(QuerySummary();“Action Time Greater”);Length(QuerySummary()));“)”));“Greater than or Equal to”;“>=”)

will return Action Time >= 01/11/2024

10

if one chooses the option “prompt” when clicking on the button right to where appears now a datetime value, the default prompt text is displayed, e.g. “enter value(s) for…”
that text can be edited, and it can be used as argument in the mentioned “UserResponse” function