ASP passing parameters problem.

[grovemedia]

We have reports built with strored procedures on our intranet. All of them work fine unless the report needs a parameter. If i run the report that needs a parameter locally on my pc it runs fine. When it is published to the intranet it doesn't work, and i can't figure out why. If someone could point me in a direction, it would be greatly appreciated. Thanks

 

[skittle123]

Faced this problem recently, from what I coudl find in an ASP .net app crysatl cannot prompt for parameters.
You have to set the paramters at run tim before seeing the report . Try to bind your report after getting values from the user using a regular asp page with text boxes etc. when they click ok, you can then show the report using tehse values.

Thanks!!

 

[grovemedia]

We have a asp page set up with a text box. The user then types in what parameter they want and submit and that asp page passes the parameter to the report and opens the report. I have the exact same pages running locally on my pc and it works.