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

Filter Information in Header

Started by KEKeogh, 06 Feb 2009 04:27:02 PM

Previous topic - Next topic

KEKeogh

I remember in Cognos Impromptu you used to be able to show the filter text in a header.

Can we do something similar in Cognos 8.3 Report Studio?

What I would like to do is this:

I have the following filter:
[DSR] between _first_of_month(_add_months(current_date,-1)) and _add_days(_first_of_month(current_date),-1)

This returns the data for the previous month.  Now I want the header to state those dates returned. 

Like if I ran the report today February 6, 2009, the data for all of January 2009 will show up.   
And the header I would like to somehow state the dates January 1, 2009 through January 31, 2009.

That way once the report has run any person receiving it knows what dates were filtered for, since dates do not show in the actual report.

Anyone know of a way to accomplish this?

Thanks
Kathie

Gopinath

Create 2 data items in your query

Data item1 with following expression:
_first_of_month(_add_months(current_date,-1))

Data item2 with:
_add_days(_first_of_month(current_date),-1)


Drag and drop a text item in the report header and hard code "[DSR] between " and "and" as text. Now drag and drop the data items in between them.

Hope this helps.

KEKeogh

That solution works for now.

But I was hoping to have something so that if someone changes the filter the two query data items in the header automatically update.