asked on

Weird result in SQL Reporting Services report

I have been creating some reports in visual studio 2003 for sql 2000 reporting services. For this report there are 2 groupings. On the 2nd grouping, there are 3 rows for the footer of the group. When I preview the results, there are only 3 groups on the 1st page and it splits to a second page. I can't figure out why. If I remove the 3 footers for the 2nd group, it all goes to 1 page. Here is a visual

-GROUP1_a
-GROUP2_a
DATA
FOOTER1
FOOTER2
FOOTER3
+GROUP1_b
+GROUP1_c

and instead of all this on 1 page it looks like this

Page1:

+GROUP1_a
+GROUP1_b
+GROUP1_c

Page2:

+GROUP1_d
+GROUP1_e
+GROUP1_f

Yurich

previewing in the report manager (visual studio) may not working well with goupings and page breaks. try to deploy your repot and see if it's working fine there. only if it doesn't, you'll have to start worrying.

it might be not your case but as I said, first check it after deploying, then we'll start worrying.

good luck,
yurich

mbosico

ASKER

worry :( Its the same deployed.

Yurich

ok, can you please then show us your structure in a bit different way as it's a bit confusing now, something like:

group1.header1
group1.header2
group2.header1
details
gropu2.footer1
group2.footer2
group1.footer1

and in the same manner what you're getting displayed on what pages.

regs,
yurich

mbosico

ASKER

yeah sorry i'll get that for you 2nite...

mbosico

ASKER

table.header1
table.header2
group1.header1
group2.header1
detail
group2.footer1
group2.footer2
group2.footer3
table.footer

When I look at the report:

+group1
+group1
+group1

On page 1 and

+group1
+group1
+group1

On page2. They need to all be on 1 page.

Yurich

It sounds like you have it because if you expand (or drill down and + is for drilling down as far as I understand) your groups to show sub-groups and details they will take up a page and as VS calculates the pages when it's compiling 'em (building), it's placing the next three records to the next page. And that's done in it's turn because when you print collapsed groups, they will print in full (showing everything) and taking up all the space on the page.

Regards,
Yurich

mbosico

ASKER

If this explanation were true, then every report that went over a page when expanded would exhibit the same behavior??

ASKER CERTIFIED SOLUTION

Yurich

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial