I'm evaluating reports and I'm stuck. I need to generate a report over multiple days gathering data from csv files. My plan is to read in all the data and parse it into classes. From there I create a reportbook and add a report per day. On the report I would like to show something like the attached image.
http://www.telerik.com/ClientsFiles/304709_example-report.png
Here are the two data models I was planning to use.
When I create the report I call a setup method that takes a model with all the count data for the date. When the report calls the NeedDataSource event I parse the data into time slices and fill an IntervalApproachModel with all the counts during that time slice. I set the data source to a list of IntervalApproachModels.
I was trying to use a crosstab but I can't seem to get it to appear like the image. Is this the correct way to achieve my goal? How can I set up the crosstab to display correctly?
http://www.telerik.com/ClientsFiles/304709_example-report.png
Here are the two data models I was planning to use.
public class IntervalApproachModel{ public IntervalApproachModel() { Northbound = new ApproachCountModel(); Eastbound = new ApproachCountModel(); Southbound = new ApproachCountModel(); Westbound = new ApproachCountModel(); Unassigned = new ApproachCountModel(); } public DateTime Time { get; set; } public ApproachCountModel Northbound { get; set; } public ApproachCountModel Eastbound { get; set; } public ApproachCountModel Southbound { get; set; } public ApproachCountModel Westbound { get; set; } public ApproachCountModel Unassigned { get; set; }} public class ApproachCountModel { public ApproachTypes ApproachType { get; set; } public int Left { get; set; } public int Right { get; set; } public int UTurn { get; set; } public int Through { get; set; } public int Peds { get; set; } public int Total { get { return Left + Right + UTurn + Through + Peds; } } }When I create the report I call a setup method that takes a model with all the count data for the date. When the report calls the NeedDataSource event I parse the data into time slices and fill an IntervalApproachModel with all the counts during that time slice. I set the data source to a list of IntervalApproachModels.
I was trying to use a crosstab but I can't seem to get it to appear like the image. Is this the correct way to achieve my goal? How can I set up the crosstab to display correctly?