Filtering Report Group By Time RRS feed

  • Question

  • I am trying to filter a report into seperate groups by hour. I have two fields, timestart and timeend, which I would like to use a filter against. I want each group to only display an hour timespan. So 9-10 would be one group, 10-11 another, and so on. I created my first group and attempted to apply a filter condition to it. I keep getting an error stating:

     The properties for the currently selected item are not valid. Please correct all values before continuing.

    This is getting very frustrating.
    Here are the filter fields that I have setup that are not being created because of the error message above.

    Expression: =Hour(Fields!timestart.Value)
    Operator: >=
    Value: =9

    Expression: =Hour(Fields!timeend.Value)
    Operator: <=
    Value: =10

    Any help would be much appreciated. Thank you in advance.

    NOTE TO SELF and anyone else viewing thread....MAKE SURE YOUR GROUP NAME STARTS WITH A LETTER!! Gotta love uniformitive error messages!
    Tuesday, April 8, 2008 6:58 PM