February 28, 2017 at 11:42 am
I'm creating a Bar and Line graph is SSRS.
I'm populating values from a dataset called GetData where I'm taking values called "Total Cores, OrderNum, TotalPanelLine, TotalCoresLine"
I also have another dataset called DepartmentNames which has DepartmentID and Department values. I need to setup an expression to hide graph for TotalPanelLine if DepartmentID is less than 25. Is there anyway to do this?
February 28, 2017 at 1:46 pm
Does the GetData dataset have a DepartmentID or some way to relate the two datasets? You could use LOOKUP to grab a value from the other dataset. Then hiding the graph is easy... You just set the Visible property of the graph to (DepartmentID<25)
February 28, 2017 at 1:54 pm
pietlinden - Tuesday, February 28, 2017 1:46 PMDoes the GetData dataset have a DepartmentID or some way to relate the two datasets? You could use LOOKUP to grab a value from the other dataset. Then hiding the graph is easy... You just set the Visible property of the graph to (DepartmentID<25)
No, GetData doesn't have the DepartmentID. I can't relate the two datasets. I didn't know we can do LOOKUP. Let me me check on that.
February 28, 2017 at 2:17 pm
If the two datasets have one or more fields in common, then you can use LOOKUP, otherwise, you're stuck I think.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply