locked
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.

     

     

     

    Regards


    kicaj
    Wednesday, May 25, 2011 4:56 PM