Link to home
Start Free TrialLog in
Avatar of vbnetcoder
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?
ASKER CERTIFIED SOLUTION
Avatar of loudwalker
loudwalker

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You can use those parameters in the stored procedure or query you are referencing the dataset to...
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.
Avatar of vbnetcoder
vbnetcoder

ASKER

ty