Create a report from a Stored Procedure

[LonC25]

I hope someone can help me with this. I am sure its probally easy but I am a newbie.

I have a stored prodcedure that prompts me to enter a specific Order Number, and then shows me the results I need to see. However its in "table form". My boss needs it in report form.

I can create a report from a view, but that doesn't prompt me for the Order Number. I am in a catch 22. Can someone tell me how to generate a report from the results of a Stored Procedure, or how to get a View to prompt you.

Thanks

 

[LarryDeLaruelle]

LonC25:

By 'stored procedure' do you mean a query with a parameter prompt?

If so, base the report on the query. When you run the report, you will get the parameter prompt.

Larry De Laruelle
ldelaruelle@familychildrenscenter.org