ReportViewer (local mode) with Entity Framework 4.2 objects - gives incorrect report output

Pregunta ReportViewer (local mode) with Entity Framework 4.2 objects - gives incorrect report output

  • lunes, 12 de marzo de 2012 13:29
     
     

    Is there an issue with MS Reporting, EF4.2 entity objects (created from views in SQL database)?

    The reports just don't handle the data correctly and repeat the same rows multiple times, and

    also seem not to handle grouping totals correctly.

    The report definition is simple with detail rows and subtotals, no column groups,

    as the SQL view already gives me the data in the crosstab format required.

    :excerpt.....

    Dim rds As New ReportDataSource("ClockingMatrix", LabourContext.vw_WkEmpClockMatrix.OrderBy(Function(o) o.WeekNo).ThenBy(Function(o) o.Clk_Emp_ID).ToList())

    There are 6 weekno values in my data, but the report repeats the first weekno for all 6 groups.

    Any help would be appreciated!!!!!


    Mike