Group SSRS report multiple lines in one page

(0) Share

Report

Posted on by Community Member

hi all,

I just realized I was posting this to wrong forum. Re-posting to D365 Finance instead of Dynamics AX.

I am new to SSRS report. Working on a Sales invoice report and encounter a problem where my Totals section will split into 2 pages if there isn't enough space to print all of them in one page.

I have tried to set the "Hidden" property using "=iif(Globals!PageNumber=Globals!TotalPages,false,true)", meaning to print those lines on the last page only, but compilation failed saying the global variables TotalPages and PageNumber can only be used in page header or footer.

Here's the SSRS layout. It is part of the Report Body.

Here's the desired output:

How to avoid those 5 lines to print on separate pages. Sometimes it prints Sub total & Shipping in one page, and the rest on the following page.

thank you for reading this.

Fen

I have the same question (0)

All responses (6)

Answers (2)

Sort by

Bhagyashree Dave 133 on at

Like (0)

Report
Copy link

Link copied!

If you're using a table in the design, you could try tick marking "Keep together on one page if possible" in page break options in tablix properties.

Regards,

Bhagyashree Dave

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

hi Bhagyashree,

Thank you for your suggestion! Do you mean I should try adding a table and put all those lines in a table?

Was this reply helpful? Yes No
Verified answer

Bhagyashree Dave 133 on at

Like (0)

Report
Copy link

Link copied!

Yes sure, you should try that.

Just remember to remove the default group from the row of the table if you don't have repeating(multiple) data. By repeating data I meant line wise data.

I think you should add these data in the existing table otherwise it will work the same. But again I'm not sure about it, just try both ways, try adding a new table and then try adding these data in the existing table. While you're adding it to existing table, add these data outside the group, I guess this will work fine.

Regards,

Bhagyashree Dave

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

hi Bhagyashree,

What do you mean by removing default group? Please explain more, sorry I am really new to SSRS.

I added a table, but it is repeating the content multiple times.

Was this reply helpful? Yes No
Verified answer

Bhagyashree Dave 133 on at

Like (0)

Report
Copy link

Link copied!

Hi,

By removing default group I meant, when you create a new table, It has a row group by default named "Details". So you must remove it before you add your data to that table.

But instead, I would suggest you to use existing table if you have it in the report. And add your data by adding row to that table (outside the group).

Remember that you should delete this group only if you want to display header (one-time) data in the table. If you're displaying lines' data then you should keep it. But in this scenario, I guess you are trying to display header data.

Regards,

Bhagyashree Dave

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

hi Bhagyashree, your suggestion works really well! I mangaed to print all the totals in one page.

Thanks so much for your help!

Was this reply helpful? Yes No