Avatar of mbosico
mbosico
 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
Microsoft SQL Server

Avatar of undefined
Last Comment
Yurich

8/22/2022 - Mon
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
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
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
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
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

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question