all groups > sql server reporting services > september 2005 >
You're in the

sql server reporting services

group:

Parameter value default


Parameter value default schmidtkaren
9/30/2005 12:32:04 PM
sql server reporting services:
I created a report that calls a stored procedure that requires 2 parameters.
when I run the report and enter values for the 2 parameters: Year and ID. I
can enter various IDs (2202,1420) but the report is always using the same
value (3207) with no regard to what I've entered. Under the "Report
Parameters" I have not set any default value. (Also, the stored procedure
does not have that value hardcoded either).

In visual studio is did a "Find" on the value 3207 and an occurance was
found. Is there anywhere else besides the "Report Parameter" dialog that I
could have entered a default value of 3207?
--
Systems Analyst
RE: Parameter value default F. Dwarf
9/30/2005 2:16:04 PM
Hi!
Be sure that you are sending the proper data type. Perhaps you defined the
parameter as String, but you meant to recieve an Integer.
Or maybe you set a value in the query string (take a look to the Data tab in
the report Designer)
I hope this helps.

Re: Parameter value default Jennifer
10/4/2005 7:24:11 AM
Hi there

In your dataset box there is a parameter's tab. Have you not perhaps
entered a value in the expression instead of calling the parameter?

Otherwise, have a look in the rdl xml where the value was found,
perhaps the tag name might give you an idea.

Jennifer
AddThis Social Bookmark Button