Skip to Content
0
Former Member
Mar 08, 2007 at 12:17 PM

Made Dynamic Prompts OK, but Static Prompts Still Appear. Why?

15 Views

<p>Hello All,</p><p>I have a stored procedure that I am using as the basis for a report. This stored procedure has some parameters so the user can customize the report.</p><p>When making the report, Designer gives me some default static Parameter Fields to match the parameters of the stored procedure. When I run the report in preview mode in Designer or in InfoView after publishing, the report correctly presents a page with simple text input fields (one for each parameter) to the user.</p><p>I can successfully convert these Parameter Fields from static to dynamic. However, something odd is happening now. When I try to run the report, whether in preview mode in Designer or in InfoView after publishing, the report will still present the page with simple text input fields to the user. If the user just clicks OK at the bottom of the parameter page, THEN the report presents a page with the appropriate dynamic prompts to the user.</p><p>How can I get the report to skip the page with the simple text input fields and only present the page with the dynamic prompts?</p><p>If anyone can give me an answer to this ASAP, I&#39;ll personally see to it that you have a bright sunny day tomorrow.</p><p>Not that I think this should matter, but were on CR XI.</p>