How to conditionally highlight fields in an RDL report of Microsoft Reporting Services reports?

I have an RDL report which is a registry - this is a grid:

  • each row represents a day
  • each column represents a task
  • each cell contains the name of the person performing this task on that day.

I serve reports from the MS report server.

I would like to highlight cells containing the name of the person viewing the report. So I really have two questions in one:

  • Is it possible to get the name of a person from environment variables sent with their request to the report server? More generally, how can I see a list of passed environment variables?

If I cannot get my name automatically, I can specify a report parameter that allows them to enter their name manually.

Second question:

  • , , , ?
+3
2

rdlc . . IIf Field! Name Parameter!

:

=IIf(Fields!name=Parameters!viewername, "Black", "Red");

PS > , Color /.

"globals", "UserID", , . , , Color :

=IIf(Fields!name=User!UserID, "Black", "Red");

( ), - Like.

+6

VS, COLOR, :

=IIf(Fields!name=Parameters!viewername, "Black", "Red")
+1

Source: https://habr.com/ru/post/1721835/


All Articles