vbnetcoder
asked on
SSRS Parameter question
In SSRS I created a parameter by selecting the parameters folder icon -> right clicking on it ---> selecting add parameter
Now, how would i go about associating newly created paramter with an exsisting dataset?
Now, how would i go about associating newly created paramter with an exsisting dataset?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ty
So, if you are using a stored procedure to build the dataset, you will need to write
<storedProcedureName> <ParameterList> = <@Parameter(the one you created)> e.g.
deleteme_prc @tableName = @tblName (this is one which you created)
or if it is sql query then
Select * from table where orderId = @orderId (this is the parameter which you created).
Note: ParameterName is case-sensitive.