Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dynamic Prompts

Status
Not open for further replies.

KeertanaCR

Programmer
Oct 11, 2006
68
US
Hi,

I have a dynamic Prompt DYP in my report which is pointing to a stored procedure STP, Stored procedure has input parameters SDate and EDate.

So, when refreshing the report, It is asking for the dates twice, first time to get the values for dynamic prompt DYP and second time for the actual report. I guess, asking dates Sdate and EDate to get the DYP values makes sense, but prompting for dates twice is kind of sounds wierd. Is there a way, it can only prompt for the dates only once.

I am using crystal XI and Sql Server 2000

Thank you
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top