Thursday, November 1, 2012

How to display user name in grid report?

Create a Metric with formula Trim(?[User Login]) and add it to the report grid.

2 comments:

  1. You just need to add an aggregate function to make it work in a metric.

    max(Trim(?[User Login]))

    ReplyDelete
  2. Adding the aggregation worked for me, though I cannot think of a good use for metric.

    ReplyDelete