none
loop through a datatable in the Code section of a Microsoft Designer Report RRS feed

  • Question

  • I'm trying to loop through a database table in a microsoft report. I created the report in VS 2008. I'm trying to use the Code section of the report. How do I access a table that has already been poplulated in the report? I don't know VB which make it challenging but then I don't know how to access the reports tables. The table I'm trying to loop through is not the primary table being reported on but what I need to do is lookup information from subordinate tables and the return calculated values back through the use of expressions like '=code.calcuate4ordervaribles(Fields!x, Fields!y)'

    Thank you,
    Aditya
    Tuesday, March 31, 2009 7:15 PM