How to create dynamic columns RRS feed

  • Question

  • I have  table with following data UserID, Date, JobDescription, JobTotal

    I want to create a report with the following layout:

    JobDescription | Date1 | Date 2 | Date 3 ...

    Job 1               |   2     |    1      |     3  .....
    Job 2               |   0     |     4     |     1 ....

    My major issue is getting the report to create the dates as column headers ( the table is restricted to a 1 week date range)

    The report is created with the layout above EXCEPT its only one date, the following date is then recreated below that and it repeats for all seven days.
    Wednesday, February 13, 2008 7:08 PM

All replies

  • I think you want a Matrix Control, not a normal table


    But if only a table will work, there are lots of posts on the subject of dynamic report generation.  And you can go to for some project examples

    Wednesday, February 13, 2008 10:23 PM