none
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,

     

    Thanks,

     

    -Matt-

    Matthew Fiore

    Programmer

    Youth Alternatives, Inc.

    Wednesday, April 16, 2008 12:21 PM