If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Display/Show Filter contents on report

Started by awhitman33, 28 Jul 2010 11:49:43 AM

Previous topic - Next topic

awhitman33

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!


tupac_rd


awhitman33

Thanks - i was afraid that was the only solution.  Some of our reports have 6-10 filters!

faris1421

Yep. In impromptu it will be displayed automatically.. In 8 version I fear hardcoding is the only way to do it..

DustPanMan

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
Best,

D

anandhisomasundaram

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.

MFGF

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.
Meep!

mermedia

Man, that friggin sucks that you have to hard code it now. Sometimes I miss Impromptu. :(