Poco/ObjectDataSource and table questions

2 posts, 0 answers
  1. Andrew
    Andrew avatar
    26 posts
    Member since:
    Sep 2011

    Posted 05 Oct 2011 Link to this post

    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.

    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?
  2. Andrew
    Andrew avatar
    26 posts
    Member since:
    Sep 2011

    Posted 06 Oct 2011 Link to this post

    Nevermind, I got it to work finally.
  3. DevCraft banner
Back to Top