PO Form Customization - Help Needed

We customized the PO Form to have a lot less white space. The issue we are currently having is that we cannot get the Po Line information to stay together. This is what happens when printing currently:

The red circled section at the bottom should move down to keep with the rest of its group. Otherwise, this is the exact behavior we are looking for. We have played with the keep-together setting for both group 1, group 2, and the tablix. We have also gone into the Advanced mode in Microsoft Report Builder to try and get this resolved. No dice thus far.

Does anyone have any recommendations on how to accomplish this?

1 Like

Did you set all of the lowest level lines in Advanced Mode to Keep With Above and everything above to Keep With Below?

So far we have only used the Keep with Group settings within the circled group:

We have also set them all the be the same, either all with after or all with before. What do you mean lowest level?

Whichever group is the lowest that you want to keep together. So you want Details up to Group 2 together?

I want everything in group 2 kept together, that includes the one static under details.

Do you not have any Detail lines in the Body? Based on the screenshot, it does not look like you do. They would generally be indented static lines under the Details.

This is pretty much the base PO Form for Epicor. None of the groupings have been touched. I do not believe there are any in this case.

Static Detail lines have the 3 horizontal lines next to them.
image

I would delete the Details group and set every static line to Keep With Above.

No dice. Still comes out the same.

Try setting the next Static row under what you want to keep together to Keep with Above.

image

Still not grouping correctly. It’s almost like its completely ignores the group with commands for group 2.

Yes, it is not the greatest functionality. The only thing I could think of to make this work is to reduce all the data to one row with a lot of rectangles with hidden formulas.

2 Likes

Thats what I was thinking too. Thanks a ton for helping with troubleshooting. I appreciate it!

Anytime

I had an issue with PO form and page breaks. I brute forced it and got pretty close. Check out this post:
Keeping Purchase Order Together on Fewer Pages - Kinetic 202X - Epicor User Help Forum (epiusers.help)
I had to manually find/replace the KeepTogether tag in the RDL. Then I just replaced all the keep together = true with false.

I just hate these report builder reports. I wonder if Kinetic will make this any easier?

Solution time:

We created a new row in the group we wanted to be kept together. Within that row, we placed a new table and created the same amount of rows that the group we wanted to keep together had. We then copy pasted each rectangle from the group into the corresponding rows of the new table. After that, we made sure to copy over all the visibility settings and removed any formatting statements that caused errors when re-uploading. We now get the result we were after.

Attached are the SSRS and RDD we are now using. Note only the PO form and Poform po rel part were changed.

Thank you all for the help!

POForm.rdl (343.5 KB)
POForm_PORelPart.rdl (175.8 KB)

RDDPOForm_EA.xml (481.5 KB)

2 Likes