RDLC: Formatting text in TextBox – label based on id RRS feed

  • Question

  • Hi


     My rdlc report has two DataSets:


      Users: Id, Name

      Points: UserId, MonthId, PointsCount


    I have table (tablix) that display data from source Points.

    I would like to add formatting in column UserId in this tablix.

    Instead of displaying UserId I want display Name of the user.

    I found that there is property Format in TextBox (from column UserId).

    I can use expression like this: =First(Fields!Name.Value, "Users") so I see that I can refer to DataSet Users from this tablix.


    Is there a way to create expression that will select Name from DataSet Users based on UserId passed as the parameter?


    Report DataSets: Users and Points are tables in standard DataSet.





    Wednesday, May 25, 2011 4:56 PM