Show Rows that are filtered

[vharcourt]

I created a query to produce a list of ID numbers. I used this query as a source for another query on a different List. This works without issue. The problem I am having is that it is possible for the filters on Query will remove an ID Number. I would like to still display all the ID numbers generated by the first Query even if the filters on the other query would remove it because it didn't find a row.

I apologize if I didn't explain well enough. I am using an Informix db.

[bdbits]

You need an outer join from the ID list to the other query. You can join queries within Report Studio, but it will invoke local processing on the Cognos server. If you have millions of rows, this might be a performance problem.

[vharcourt]

Thank you for your response. After messing with it all night and all day today I figured it out. It took several joins and unions to get the results that I wanted. This is the first major report in cognos so it was a big victory and will be able to apply that to additional reports

Thank you.