Yesterday 1

[cai21rsh]

I am trying to make a report that pulls up only the transactions for the previous day (ie. yesterday). Ideally I would like to set the the report date so that it always computer the new date for "yesterday" so that all users need to do is launch to report.

 

[blom0344]

And what is your question?

Ties Blom

 

[jsudha1984]

I am trying to make a report that pulls up only the transactions for the previous day (ie. yesterday). Ideally I would like to set the the report date so that it always compute the new date for "yesterday" so that all users who access the report can see the report for yesterday with that date.
Ex: If i generate the report for yesterday,in the report after receive it, it shows the yesterday's date either in the subject line of the mail or at bottom of the report page.

 

[jsudha1984]

Is it Possible?

 

[drlex]

Cognos product used?

soi la, soi carré

 

[jsudha1984]

We are using Report Analysis in Cognos 8.

 

[blom0344]

_add_days(current_date,-1) would yield the value for yesterday's date.

as stated in my other reply


Ties Blom

 

[jsudha1984]

Ties,

I confused.. where we have to add this?

 

[sln007]

I assume you have a "Transaction Date" of some kind on your database row.
In the filter for the report add:
[TRANSACTION_DATE] = _add_days(current_date,-1)


SLN