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

conditional prompt in sql

Started by Peewee71, 14 Jun 2011 11:10:15 AM

Previous topic - Next topic
Print
Go Down Pages1
User actions

Peewee71

14 Jun 2011 11:10:15 AM
Hi,
I have the following conditional prompt in my sql which works well.

trim(custid) in  (#promptmany('CustomerID','string',sq('Not Selected'))#)

I need to extend it so that if CustomerID is null or not set that it includes all customers.
Whats the best way to do this?
Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite