Groups | Blog | Home
all groups > sql server reporting services > december 2004 >

sql server reporting services : Breakup a group



PaulQld
12/2/2004 9:01:08 PM
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
PaulQld
12/2/2004 10:25:04 PM
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]
AddThis Social Bookmark Button