prompt showing only one value..????

[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.

[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.

[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.

[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.