If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Conditions in Report Expression

Started by Aregone, 30 Nov 2009 03:38:30 AM

Previous topic - Next topic

Aregone

Can we create 2 conditions in report expression of a single
data item..Eg: I added  2 new dataitems each one should
show revenue for Q1 and Q2..Pls advice

blom0344

Can you be more specific? A dataitem is part of the designed query. A report expression is a pure Cognos affair added by the webserver.
Creating buckets of quarterly data is best attained by using CASE expressions.

Aregone

Hi,
    I am creating a report as revenue for Q1,Q2,Q3 and Q4. I have added a value prompt wherein the user would select which Quarter data he wants to view.Other colums may be Prodline,prodtype etc etc... Now Question is Apart from the 4 options in the value prompt there is one more option as 'ALL' where in it would show data for all Quarters...Its multiselect as well so user can select 2quarters and others should be rendered....based on any combination of selection the user does he would get the report show revenue for desired Quarters.....