Derek in Richmond wrote:
> I have used Reporting Services for several months now - but have
recently ran
> into a problem that I'm having a hard time overcoming.
>
> I have a report that has 3 groups - District, City/County, and
Project
> Number. A Project will be in a city/county, which itself is in a
District.
> So District is group #1, city/county is group #2, and Project #3. I
then
> have detail rows under the Project grouping (related to the project).
>
> The layout I need is like this:
>
> District Group Header Alpha
> City/County Group Header Alpha
> Project Alpha
> DetailField#1 DetailField#2 DetailField#3
DetailField#4
> Project Beta
> DetailField#1 DetailField#2 DetailField#3
DetailField#4
> City/County Group Header Beta
> Project Alpha
> DetailField#1 DetailField#2 DetailField#3
DetailField#4
> Project Beta
> DetailField#1 DetailField#2 DetailField#3
DetailField#4
> District Group Header Beta
> City/County Group Header Alpha
> Project Alpha
> DetailField#1 DetailField#2 DetailField#3
DetailField#4
>
> and so on...
>
> To acheive the desired effect, I set the table column widths
according to
> the needs of the DETAILS section of the report. I then merge the
header rows
> (because the group header field is relatively long). For the
District
> header, I merge cells starting with the leftmost side of the report.
For the
> City/County (because I want it indented), I merge starting with cell
#2 (from
> the left), and for the UPC, I start merging with cell #3.
>
> What this has caused, however, is for a blank page to be printed
between
> each header. So I have the District name on a page, then a blank
page, then
> the city/county name, then a blank page, then the UPC, and then
finally the
> details.
>
> I have made sure that "Keep Together" = False on the table, and none
of the
> groups have "Page Break at Start" or "Page Break at End" checked.
Further,
> when I remove the merged cells (i.e. I split them back up), the
report runs
> fine -- but without my group headers.
>
> Any thoughts?
>
> Thanks