Does anyone know how to show/display within a report what filters are being applied? I know how to display parameterized filters, but not static ones. Any help would be great!
Harcode as text using text item
Thanks - i was afraid that was the only solution. Some of our reports have 6-10 filters!
Yep. In impromptu it will be displayed automatically.. In 8 version I fear hardcoding is the only way to do it..
awhitman,
I have not tried this, but what you should try is creating a report with a static filter in Query Studio (which does display the filter). Then save the report and open it in Report Studio (from the more... menu). Then check the Report Specs or even just the filter display option that is on the page to see if it is being dynamically populated in any way. If so, you could replicated what every it is doing to display your other static filters. If not, you may be stuck hard-coding.
Best regards,
Dustin
Try to pull generated prompt in your report header or body and select your existing reports static prompt and it displays whatever i selected for static choices.
Hope this helps you.
Quote from: DustPanMan on 11 Aug 2010 08:23:50 AM
awhitman,
I have not tried this, but what you should try is creating a report with a static filter in Query Studio (which does display the filter). Then save the report and open it in Report Studio (from the more... menu). Then check the Report Specs or even just the filter display option that is on the page to see if it is being dynamically populated in any way. If so, you could replicated what every it is doing to display your other static filters. If not, you may be stuck hard-coding.
Best regards,
Dustin
The filter definitions shown in Query Studio are just text, sadly.
MF.
Man, that friggin sucks that you have to hard code it now. Sometimes I miss Impromptu. :(