• It sounds like your describing that you have totals already in your data as well as the non-aggragated data itself. Are you having to display those sub-totals as well? I'd suggest that, if so, you do your grouping and sub-totaling in SSRS, not in your dataset. Then you would have to issue of double counted data.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk