Date Manipulation RRS feed

  • Question

  • I have graph that will show the number events that happened in the past 3 years by Day, week, month, quarter, or year.  I have a min Date field and max data field.  The min date is populated from a database value.  I would like the Max Field to be populated based upon the choice of how they want the date to be (Day, week, month, etc...).  I want that date to be reverted to the previous week start because right now, since the month or week or whatever isn't done, I get this huge drop.  I was wondering if there was any way to make is that if the user selects "Quarter", that the maxDate Field would revert the start of this quarter automatically, so the drop is eleminated.  Is there a way to do this in reporting services?
    Thanks in advance,

    Monday, July 16, 2007 2:19 PM