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 of date prompt and 2 days before the selected date

Started by chr.93, 27 Feb 2020 04:06:35 AM

Previous topic - Next topic

chr.93

Hello everyone
I have the following requirement in a report. The user selects a specific date and the report runs for this dates and 2 days before it. I have modified the filter to achieve that.
However when i also want to display the value of this prompt in the report page.
With ParameterDisplauValue I only get of course the date that the user selects and I want to display the dates of the 3 days.
How can I achieve that? the _add_days doesn't work here as Cognos doesn't let me insert (_add_days(ParameterDisplayValue('pDate'),2) in a report expression under the title.

BigChris

It might be worth trying a layout calculation, with something like

_add_days(?pDate?,-2)

If that doesn't work (but I think it should), you could add it as a calculation in a query, then add it as a singleton to the header.

chr.93

Quote from: BigChris on 27 Feb 2020 04:25:31 AM
It might be worth trying a layout calculation, with something like

_add_days(?pDate?,-2)

If that doesn't work (but I think it should), you could add it as a calculation in a query, then add it as a singleton to the header.

The layout calculation didn't work but the singleton worked just fine! Thank you  :D