Impromptu's "in" and "starts with" components combined 2

[elockhart]

Hello Everyone,

Has anyone combined Impromptu's "in" and "starts with" components along with a File Picklist in a filter? I want the report user to be able to select, from a File Picklist, one or multiple letters of the alphabet (using Ctrl + mouse click) and have the report filtered on those seleted letter(s).

Thanks in advance,
Eric

 

[griffindm]

elockhart,

I don't believe this is possible, as Impromptu will treat the combination of operators in a way that eliminates the multiple choice option for the 'IN' clause. Why would you want to have the user select multiple values where the column is equal to a single letter anyway?

Regards,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
Magic with Data
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[drlex]

Eric,
Maybe I misunderstand your request, but couldn't you use LEFT (or SUBSTRING) in conjunction with the IN?
i.e. If your test field is PRODUCT and your File Picklist is the letters A through to Z, wouldn't the filter LEFT(PRODUCT,1) IN (?PROMPT?) work for you?

soi la, soi carré

 

[elockhart]

Dave and DrLex,

Thank you both for responding. This is my first time to use this Q/A forum.... still learning how to navigate!

It does seem that you can not directly combine "in" and "starts with". First thing this morning I am going to try DrLex's suggestion, I think it should work, I should have thought of it, but thought I was missing something.... I'll let you know!

To answer Dave's question "Why would you want to have the user select multiple values where the column is equal to a single letter anyway?".... it's an added feature to allow the user(s) to work either from one alpha group or multiple, say just from a "C" grouping or a combined "C, F, M" grouping if desired.

Once again "Thank You" both for the quick responses,
Eric