Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

SSRS Report Suddenly Extend to Next Page

Posted on by 555

Dear Experts,

I add Parent Group to table in SSRS Report but it extends to the next page if I'm saving to pdf or printing even the data only 1 row

It must be in one page but the footer show at the second page

The report structure look like this 

pastedimage1610295619998v2.png

Information about size : 

Report : Width = 8.5in,  Height = 11in

Header : Height = 5.23056in

Body : Width = 9.08292in, Height = 2.2in

Footer : Height = 3.4in

Tablix : Width = 7.8675in, Height = 0.17in

If you have any recommendation, please kindly give me some advice

Thank you in advance

Regards,

Bintang

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SSRS Report Suddenly Extend to Next Page

    Thank you Gunjan, this helps my report to print in one page too!

  • Bintang Profile Picture
    Bintang 555 on at
    RE: SSRS Report Suddenly Extend to Next Page

    Thank you Gunjan for your help

  • Verified answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,417 on at
    RE: SSRS Report Suddenly Extend to Next Page

    Hi Tahta Bintang Pratama,

    Please try reducing the body width to 8.5in. That should help print the report in a single page.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans