Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Prompts using multiple values
- Thread starter netcert
- Start date
- Thread starter
- #3
netcert,
First think, each value must be separated by coma and no spaces needed between comma and next value because Impromptu considere it within the value (123,456).
Second, you must use listprompt if you want to enter multiple values. Read FAQ faq401-2137. After this, I think you will more understand how use prompt witn Impromptu.
Gilles.
First think, each value must be separated by coma and no spaces needed between comma and next value because Impromptu considere it within the value (123,456).
Second, you must use listprompt if you want to enter multiple values. Read FAQ faq401-2137. After this, I think you will more understand how use prompt witn Impromptu.
Gilles.
- Thread starter
- #5
Here is my filter:
Processing Date between 2003-01-01 and 2003-12-31 and Customer Number in (?Prompt?)
When i run this report i type in the prompt: 0426002,0027307
I get no results when i type in both numbers. When i type in either of them alone i get results. I used a "Type in" prompt.
Processing Date between 2003-01-01 and 2003-12-31 and Customer Number in (?Prompt?)
When i run this report i type in the prompt: 0426002,0027307
I get no results when i type in both numbers. When i type in either of them alone i get results. I used a "Type in" prompt.
- Thread starter
- #7
sorry all if it seems as if i'm not applying what you are saying.
When I create my prompt i have the following choices on the Prompt definition window under the Type drop down:
Type In
File Picklist
Report Picklist
Catalog Picklist
Which one of these should I be selecting? Also, are these the standards options or is my administrator limiting me to certain ones?
When I create my prompt i have the following choices on the Prompt definition window under the Type drop down:
Type In
File Picklist
Report Picklist
Catalog Picklist
Which one of these should I be selecting? Also, are these the standards options or is my administrator limiting me to certain ones?
Those are the options. Depending on how many customer numbers you have (which appears to be in the hundreds of thousands), a catalog picklist probably won't work, there are limitations to the number of rows it can show in the picklist. I've had similar needs and the workaround I used was to ask the user how many they "generally" would want to search on at a time and if it's 3 or 4 for instance I'd simply create 4 separate prompts and use an "or" statement in the filter. It's not a perfect solution, but it's the best one I found the last time I needed to do this.
Hi,
Effectively, the picklist has a limitations, by default is 100, but you can modified it in Impromptu.in file. This limitation it's only in showing picklist.
With my experience, the great solution to your poblem is to develop a macro within the user can type his data. The data can be type in a edit field or in list box, etc. it's your choice. Once data is type, you are formating the data in picklist format (data,data,data). It's very efficient. With this solution, you can find more then picklist limitation.
I propose to you to use picklist for catalog and choose the data on what the filter must be do.
I hope so this information will be help you.
Gilles.
Effectively, the picklist has a limitations, by default is 100, but you can modified it in Impromptu.in file. This limitation it's only in showing picklist.
With my experience, the great solution to your poblem is to develop a macro within the user can type his data. The data can be type in a edit field or in list box, etc. it's your choice. Once data is type, you are formating the data in picklist format (data,data,data). It's very efficient. With this solution, you can find more then picklist limitation.
I propose to you to use picklist for catalog and choose the data on what the filter must be do.
I hope so this information will be help you.
Gilles.
Hi
I had similar problems with prompts in impromptu. So after a couple of frustrating months, I jumped headlong into powerprompts. Instead of using dynamos, I used javascript to create the necessary select list options. Now, after a lot of hard work, I have been able create some great prompts.
I hope you also are thinking of that option, especiallly if you intent to publish your reports.
I had similar problems with prompts in impromptu. So after a couple of frustrating months, I jumped headlong into powerprompts. Instead of using dynamos, I used javascript to create the necessary select list options. Now, after a lot of hard work, I have been able create some great prompts.
I hope you also are thinking of that option, especiallly if you intent to publish your reports.
- Thread starter
- #11
I'm a beginner Cognos user so I don't know what powerprompts or dynamos are. My background is in MS Access but I have picked up Cognos fairly quickly. Still, I cannot seem to get across what I'm looking to do.
Instead of using a simple prompt where you type in one customer number (12345) I want to be able to enter multiple customer #'s at the same time. This will allow to to only have to run my imr's once rather than 5-6 times.
Instead of using a simple prompt where you type in one customer number (12345) I want to be able to enter multiple customer #'s at the same time. This will allow to to only have to run my imr's once rather than 5-6 times.
So you want a type-in prompt where the user can enter customer numbers, like this:
12345, 79832, 88247, 99343
And get a report that includes those four customers.
Without using Macros, Powerprompts, or stored procedures, Cognos (including Series 7) does not provide this functionality. ReportNet may include this functionality.
Pain is stress leaving the body
DoubleD
12345, 79832, 88247, 99343
And get a report that includes those four customers.
Without using Macros, Powerprompts, or stored procedures, Cognos (including Series 7) does not provide this functionality. ReportNet may include this functionality.
Pain is stress leaving the body
DoubleD
- Thread starter
- #13
Hold on now. I'm a little late getting to this thread, but whats stopping you from creating multiple type-in prompts and using them together with an IN clause, as in:
and customer IN (?prompt1?,?prompt2?,?prompt3?,?prompt4?) ...
Even leaving any unwanted prompts as empty values won't affect the results. Admittedly, you have to specify a predetermined number of type-in prompts to allow, but it's little hassle to make more than you might need.
Let me know if this fits the bill.
Regards,
Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"![[pc2]](/data/assets/smilies/pc2.gif "[pc2] [pc2]")
Want good answers? Read FAQ401-2487 first!
and customer IN (?prompt1?,?prompt2?,?prompt3?,?prompt4?) ...
Even leaving any unwanted prompts as empty values won't affect the results. Admittedly, you have to specify a predetermined number of type-in prompts to allow, but it's little hassle to make more than you might need.
Let me know if this fits the bill.
Regards,
Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!
Griffindm,
Although that is a valid option, I hesitated to post it because it is so limited. It's not scalable, and what happens when there are records that have a blank in Customer Number. All those records will come back unless the person puts something in every prompt.
Pain is stress leaving the body
DoubleD
Although that is a valid option, I hesitated to post it because it is so limited. It's not scalable, and what happens when there are records that have a blank in Customer Number. All those records will come back unless the person puts something in every prompt.
Pain is stress leaving the body
DoubleD
Coincidence, I'm attending a Cognos training session and they provided us a copy of their SupportLink magazine that comes out quarterly. In the Jan-Mar issue, I was thumbing thru and they have a helpful hint that helps with this.
The article is entitled Multiple Type-in Prompt Report in Impromptu.
It says that by default it isn't possible, but describes how to go thru creating 5 calculation data definitions to achieve it. I tried accessing the article online but apparently you have to be a direct client with a login, etc. I would be willing to type it all out (although it would take a while) but am hoping someone has the ability (and with their permission) to get the instructions and provide them without having to key it all out.
The link to the site is
Good luck,
Scott
The article is entitled Multiple Type-in Prompt Report in Impromptu.
It says that by default it isn't possible, but describes how to go thru creating 5 calculation data definitions to achieve it. I tried accessing the article online but apparently you have to be a direct client with a login, etc. I would be willing to type it all out (although it would take a while) but am hoping someone has the ability (and with their permission) to get the instructions and provide them without having to key it all out.
The link to the site is
Good luck,
Scott
- Status
Similar threads
- Locked
- Question