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