Timescale graph report using two dates RRS feed

  • Question


    I am attempting to create a graph report that counts the number of clients enrolled in a program (by the day, week, or month depending on the parameters that the user selects). The issue is that the data is tracked with a program_entry_date and program_discharge_date so there is no one date field that the graph can be grouped by.


    I thought of create a tmp table and cursor that would populate a record for each day a client was enrolled however this would prove to be a considerable resource drain, especially when the report is run for a year.


    Any suggestions,





    Matthew Fiore


    Youth Alternatives, Inc.

    Wednesday, April 16, 2008 12:21 PM