none
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?

     

    Regards


    kicaj
    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 (alihamdar.com - www.ids.com.lb)
    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?


    kicaj
    Wednesday, May 18, 2011 7:27 AM