COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Impromptu => Topic started by: terry_stjean on 14 Sep 2007 10:51:42 AM

Title: Update Main query field based on sub report data
Post by: terry_stjean on 14 Sep 2007 10:51:42 AM
I have an Impromptu report where I display one order per page.
The main query is order header information and there is a subreport displaying order details.
I have to add a field to the order header part of the report (Main query) to display a message if any of the orders lines (subreport) have a shipped quantity of zero.

Suggestions on how to do this?

Terry