Please ignore this, figured it out in the end. Just needed a grouping value uin
my sql and voila table grouped ok as desired.
[quoted text, click to view] "PaulQld" wrote:
> Thanks in advance and Im new to RS.
>
> I have a simple dataset of date records which can span 1 or more weeks up to
> a month, I want to break the list up every time a Wed is encountered as this
> is the end of a reporting week and some totals need to be printed at bottom
> of the list.
>
> I have been fiddling with a table, but dont seem to be quite able to nut it
> out, has anyone else done this or similar at all, comments appreciated.
> Thanks, Paul
>
> DataSet...
>
> Tue 2/11 $77 $99 $765
> wed 3/11 $50 $450 $999
> <Need a break here and total of each column)
> Thu 4/11 $23 $888 $987
> Fri 5/11 $98 $999 $999
> Sat 6/11 $33 $ 99 $999
> Sun 7/11 $999 $ 99 $999
> Mon 8/11 $999 $ 99 $999
> Tue 9/11 $999 $ 99 $999
> Wed 10/11 $999 $ 99 $999
> <Break here and total>
> Thu
> etc etc etc