Group SSRS report multiple lines in one page

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (6)

Answers (2)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Group SSRS report multiple lines in one page

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

Thanks so much for your help!
Verified answer

Bhagyashree Dave 114 on at

Like (0)

Report

RE: Group SSRS report multiple lines in one page

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
Community Member Microsoft Employee on at

Like (0)

Report

RE: Group SSRS report multiple lines in one page

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.
Verified answer

Bhagyashree Dave 114 on at

Like (0)

Report

RE: Group SSRS report multiple lines in one page

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
Community Member Microsoft Employee on at

Like (0)

Report

RE: Group SSRS report multiple lines in one page

hi Bhagyashree,

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

Like (0)

Report

RE: Group SSRS report multiple lines in one page

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