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

prompt showing only one value..????

Started by pooja, 26 Apr 2010 10:27:22 AM

Previous topic - Next topic

pooja

we are working on report using stored procedure (including prompt)
while using prompt on report---it is showing only one value. i.e we have more than
100 company name,.....but prompt is giving only one company name.
is there any way to have all the names??

thak you so much in avance

MFGF

Hi,

How has the prompt been coded?  Do you have a query driving the list of company names for the prompt? If so, how is it retrieving data?

MF.
Meep!

pooja

we have define the QS in FM like-

# prompt('Company_Name','char','ABC')#

and works fine. but while working on report studio......prompt gives only one company name i.e 'ABC'

MFGF

OK - so it is a default prompt rather than a prompt you have coded into the report?

Where are the values for Company_Name being derived - from the stored procedure or from a different query subject?

MF.
Meep!

pooja

COMPANY_NAME derived form stored procedure. like we have procedure for comapny which includes comp_nname, comp_add, comp_zip, comp_city and so on

MFGF

Does the stored procedure retrieve all companies?  I'd guess it is limited to retrieving one, which will make it unsuitable for use in a value prompt.

I suspect you will need to resort to adding your own prompt into the report, feeding the list of company names from a separate query driven from either an unfiltered stored procedure or normal SQL.

MF.
Meep!

pooja

I am sorry ...i am not getting 100%........

MFGF

Hi,

How has your stored procedure been written?  Will it retrieve a list of all companies or does it retrieve only one company?

If it does not retrieve a list of all companies, it will not be suitable for driving the list of items for your company prompt.

MF.
Meep!