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
