Groups | Blog | Home
all groups > sql server reporting services > march 2006 >

sql server reporting services : Line break after group


Dutch
3/10/2006 3:04:26 PM
I need to insert a line break in a detail row after certains groups of data.
example:

Week Day Detail
1 Mon 1
1 Tue 1
1 Wed 2
1 Thu 2
1 Fri 1
2 Mon 1
2 Tue 1
2 Wed 2
2 Thu 2
2 Fri 1

I need it to have a line break after week 1, 2, etc. Also, the detail column
has aggregates, runningvalues etc. There can't be a runningvalue on the line
break. I want the data to look like this:

Week Day Detail
1 Mon 1
1 Tue 1
1 Wed 2
1 Thu 2
1 Fri 1

2 Mon 1
2 Tue 1
2 Wed 2
2 Thu 2
Limey
3/10/2006 10:37:26 PM
I would create a group on Week with no group header but a single blank row
group footer. This should be your innermost group. Outer groups will
calculate the aggregates properly. You'll need to scope any running values
to outer groups.

[quoted text, click to view]
AddThis Social Bookmark Button