ITsolutionWizard
asked on
MS SQL SSRS select statement
I got the screenshot from my SSRS builder for MS SQL Server.
Inside of the textbox. Can I run sql statement like the following?
all I need is to get the value from =Fields!newleadfirstname.V alue and try to run another select statement.
= select lead.firstname from leads where lead.firstname=Fields!newl eadfirstna me.Value
Inside of the textbox. Can I run sql statement like the following?
all I need is to get the value from =Fields!newleadfirstname.V
= select lead.firstname from leads where lead.firstname=Fields!newl
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Okay, here you go for the detailed steps..
1. Create a New Datasource(if not available)
2. Create a New Dataset and use the query to select a single value..
3. Create a New Parameter -> Click on Default Values -> Choose "Get values from the query" and provide your Dataset name and column name to be used.
4. We can then use the Parameter in the expressions like "=Parameters!param1.Value"
1. Create a New Datasource(if not available)
2. Create a New Dataset and use the query to select a single value..
3. Create a New Parameter -> Click on Default Values -> Choose "Get values from the query" and provide your Dataset name and column name to be used.
4. We can then use the Parameter in the expressions like "=Parameters!param1.Value"
ASKER