show 2 objects in result promp

[Namh]

Hi

I'm wondering if it's possible to show two objects from 2 different coloms in the result set of a multi-promt.

I use a search multi prompt, where the user can search for a "account number". is it possible to get then in the result field data from an 2nd colum?

I tried it atm this way.
I have a filter in the Query for my search field which looks like this:

[db].

.[AccountNumber] + ' / ' + [db].

.[AccountType]

this works fine and shows me teh right data. but when I take an result value and run a report, I will never get an result, because the value combination (account / type) does not exist in my account number colum.

Is there a way to show more then one colum in a result field?

thanks,

Namh

 

[Draoued]

when you create the Prompt Search , you can use the Display and/or the use value.
This gives you the posibility to have 2 fields in your prompt query , one for the display and one to be used for the filter itself.

 

[griffindm]

If you need to show a prompt with the results of two columns you can either use a report picklist and concatenate the columns in the picklist report, or create a SQL view and use the view in a catalog picklist. Remember that the matching results for the filter will have to have both values concatenated as well.

Dave G.


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

http://www.decisionsupportgroup.com