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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to change parameters order

Status
Not open for further replies.

Malchik

Programmer
Dec 8, 2001
148
CA
Hi,

I wonder if it is possible to change the parameter order from the Report to reflect any changes made in the stored proc.

I have a report based on a stored proc using 3 parameters
for example sp_MySp A, B, C I created the report. But now I added an extra parameters to the stored proc. This parameter has to the the first. So it bacame
sp_MySp X, A, B, C. I refresh the report, but Crystal Report see the new parameters as the last one (sp_MySp A, B, C, X). So when I call the report from my ASP.net page, I got an error because of the parameters order.

thanks for any help you can provide.

Mal'chik [bigglasses]
 
ups! I am so sorry, I figured that the parameters order from the report do not matter, since i explicitly name the parameters from the ASP.net page. I had a bug in my code, i forgot to create a new instance of ParameterDiscreteValue for each param

duh!

Mal'chik [bigglasses]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top