March 14, 2017 at 10:05 am
I am trying to add a filter to my report dataset. I want the filter based on the value I choose from another dataset. Here are the particulars of the filter.
Expression:[Location_MisLocID] This is a field in the dataset, dsReportBody.
Operator:=
Value: =First(Fields!MisLocID.Value, "dsLocationList") dsLocationList is base on a stored procedure. It's just a list of locations.
Any thoughts?
March 14, 2017 at 11:03 pm
NineIron - Tuesday, March 14, 2017 10:05 AMI am trying to add a filter to my report dataset. I want the filter based on the value I choose from another dataset. Here are the particulars of the filter.
Expression:[Location_MisLocID] This is a field in the dataset, dsReportBody.
Operator:=
Value: =First(Fields!MisLocID.Value, "dsLocationList") dsLocationList is base on a stored procedure. It's just a list of locations.Any thoughts?
If you create a report parameter, then you can set up that parameter so that it gets its values from another dataset. Create the dataset first, and then if you right-click on the Parameter Properties, and go to Available Values, you can specify the dataset that provides the values for the filter/parameter. If the LocationID is a number representing a String value, you can set the Value to the ID field and then the Label field to the text you want displayed. Is that what you meant?
March 15, 2017 at 5:49 am
Got it. Thanx.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply