How to read text for label based on id? RRS feed

  • Question

  • Hi


     I have data set with two tables:


     Users: Id, Name

     Points: UserId, MonthId, PointsCount


     I have rdlc with chart control with DataSetName property that indicates Points table.

     So on axis x I have MonthId, on axis y I have PointsCount and in legend I have UserId.


     How can I dynamically read the real user name from table Users based on value from   

     UserId to display it in the legend?



    Tuesday, May 17, 2011 8:27 PM

All replies

  • The two datasets should be related by the UserId when selecting reports datasource - you should need to select the Username field.
    Ali Hamdar ( -
    Tuesday, May 17, 2011 10:34 PM
  • I do not what exactly you mean.

    In report chart control can have only one source that is DataTable.

    How can I relate two datasets when selecting report datasource?

    Can you give example of code?

    Wednesday, May 18, 2011 7:27 AM