I've got an RDL report that is a roster -- it's a grid:
- each row represents a day
- each column represents a task
- each cell contains the name of the person doing that task on that day.
I'm serving the reports off a MS Reporting Server.
I'd like to be able to highlight the cells that contain the name of the person viewing the report. So I really have two questions in one:
- Is it possible to get the name of the person from the environment variables sent with their request to the report server? More generally, how can I see the list of environment variables that are sent?
If I can't get their name automatically, I could supply a report parameter that allows them to enter their name manually.
The second question is then:
- Assuming I've got a name in a string, how do I conditionally format the cells in the report that have that string in them?
Thanks!