SSRS Report

  • 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)

  • pietlinden - Tuesday, February 28, 2017 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)

    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.

  • If the two datasets have one or more fields in common, then you can use LOOKUP, otherwise, you're stuck I think.

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply