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