Stored Procedure Prompts

[elead]

I have created a simple report based on a MSSQL stored procedure. When I feed it the two parameters it needs via the web site it prompts for the dbLogin then the two parameters from a crystal interface?
I am connecting to the db Via System DSN And feeding the the paramters like this

http://mypage.asp?promtp0=&dtStart

&prompt1=dtEnd

Is there something I need to set in crystal to avouid the prompts??

Thanks

 

[LV]

If you are using the Web Component Server(calling reports through the URL), then your URL should look like this:

http://myReport.rpt?prompt0=value1&prompt1=value2

Also, it looks like your parameters are dates; dates should be passed in "Crystal" format, which is Date(yyyy, mm, dd), i.e.

http://myReport.rpt?prompt0=Date(2002,01,01)&prompt1=Date(2002,12,31)

Crystal will prompt for parameters if they aren't set or set incorrectly.