Date calculation in Header

[jackie1948]

How can I get a date calculation (if period = Promptperiod and yr = promptyr then enddate else NULL) in the header. fields period,yr and enddate are in a table that is linked to my balance table.
any help will be appriciated

 

[griffindm]

Just create the calculation in the Report | Query | Data menu screen, then drag the column into the header.

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[jackie1948]

I can get the date field in the header but it is the wrong date. I am working on a trial balance for account. I have a calculation on the detail line of each account. ex. if the trial balance is for period 4 then I retreive the first 4 periods data. But my problem is that the date that is showing in the header is the first account first entry date. I am wanting to have the actual date for the 4th period to display in the header. ex. yr 2003 period 4 is Oct. 31, 2002. I have a table that is set up with a field called enddate that shows the actual date (Oct. 31, 2002) and (physcial) yr and period.

 

[drlex]

Hope I'm not missing something, but can you not insert the 'enddate' field into the header ?(select header, choose 'insert' from the menu bar, then 'insert data', click and drag an area in the header, select 'enddate' from the query list and then click on 'mark for insertion')

soi la, soi carre