Cognos 8.3 Report Studio

dka07
dka07 used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Typically, you would code that dataitem something like:
IF ([Package].[querysubject].[ata] > -1)
THEN ([Package].[querysubject].[ata])
ELSE ([Package].[querysubject].[OtherDataItem])
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.

Author

Commented:
Basically all good. Thanks.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial