O'Reilly logo

IBM Cognos 10 Report Studio Cookbook - Second Edition by Abhishek Sanghani, Ahmed Lashin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Making prompts optional

The previous recipe showed you how to generate a prompt through a macro. In this recipe, we will see how to make them optional using other arguments of the function.

We will generate two simple list reports, both based on a native SQL. These lists will show product details for a selected product line. However, the product line prompt will be made optional using two different approaches.

Getting ready

Create a report with two simple list objects based on native SQL. For that, create the query subjects in the same way as we did in the previous recipe. Use the following query in the SQL objects:

SELECT DISTINCT "SLS_PRODUCT_LINE_LOOKUP"."PRODUCT_LINE_EN""PRODUCT_LINE" , "SLS_PRODUCT_LOOKUP"."PRODUCT_NAME""PRODUCT_NAME" , "SLS_PRODUCT_COLOR_LOOKUP"."PRODUCT_COLOR_EN""PRODUCT_COLOR" ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required