CODEWITHSUNDEEP
reporting-servicesssrs-2008-r2
Keyes Kennard
Keyes Kennard

Reputation: 1

SSRS - Use the result from one textbox to populate a field from a dataset

I am writing a report in SSRS. Can i use the text result from a textbox to pull a Field from one of my datasets? For example:

In Textbox1, i have the formula =First(Fields!Metric1.Value, "Dataset2") which produces the text result: "BikeSales" in Textbox1

I need an expression in Textbox2 that references a Field called BikeSales in DataSet1 based on the result. Something like: =Sum(Fields.("Text from Textbox1").Value, "Dataset1") to pull the Field from Dataset 1.

Is this possible?

Upvotes: 0

Views: 2287

Answers (1)

Harry
Harry

Reputation: 2941

If all you want to do is reference the Textbox1 value.. you can use Reportitems!Textbox1.value

If you want the value from the actual dataset, you can use lookup

Upvotes: 0

Related Questions