Skip to Content
0
Former Member
Sep 14, 2007 at 12:36 PM

Asking only once for a parameter...

30 Views

Post Author: Nightcrawler

CA Forum: Data Connectivity and SQL

Hi,

I have a report which need to select a list of items for a dynamic lookup for the report. I have created two stored procedure in SQL which work in QA. When I link them to a report I get asked for the date range twice. This is because the two stored procedures ask for the date range for them to select data. The parameter names are the same in each stored procedure. Basically I want the screen to ask me for the date range then give me a popup list based on the items. Then pass this to the second stored procedure to run for the report ??

How is best to do this ?

Thanks

Ed