Cognos 8.3 Report Studio

I have a report made up of five columns. One column is called "ATA". Sometimes there is no data in the row, because non is available from the database. I want to get data from another (existing) query to fill in the gap. In other words populate the entire column. Can you explain how to do that?
dka07Asked:
Who is Participating?
 
RWrigleyConnect With a Mentor Commented:
Typically, you would code that dataitem something like:
IF ([Package].[querysubject].[ata] > -1)
THEN ([Package].[querysubject].[ata])
ELSE ([Package].[querysubject].[OtherDataItem])
0
 
dka07Connect With a Mentor Author Commented:
Hi,
really sorry about not responding sooner.. But been really busy with other projects. Basically yes, this helped. Think there was a couple of quotes missing, plus I didn't add my join correctly, so still not working, but I'm sure it will when I get time to test again. Thanks.
0
 
dka07Author Commented:
Basically all good. Thanks.
0
All Courses

From novice to tech pro — start learning today.