Forum Discussion

mseppanen's avatar
mseppanen
New Member
7 years ago
Solved

Dynamic Slicer Content

I have a Slicer for a report that contains Employees in a Department, my Employees are defined in a table in my ERP system (SQL DB).

 

We gain and lose employees, and they move between departments on a fairly regular basis.

 

Is it possible to tie the Content of the Slicer for Department to the Employee Table in my SQL Table?

 

Or am I doomed to do busy work and update the Slicers manually every time an Employee has a change?

 

Example:

Panel Saws: Susan, Billy, Martin

Shipping: George, Mark, John

 

Mark moves to Panel Saws, and we hire Chris for Shipping.

 

Panel Saws: Susan, Billy, Martin, Mark

Shipping: George, John, Chris

 

Ideally the Report Slicer would be updated and the Report would show only the employees in the respective departments, without having to redefine the Contents each time.