Today I had to modify the Purchase Order report style to reduce the number of blank pages being generated. We have very long comments that get added into the PO, sometimes the comments are so long that 2 pages or more are needed. In the past, the first page would have the header, and then be blank, while the second page would have all the comments on it. I tried over and over to change the KeepTogether flag on every rectangle, tablix, and field I could find. No matter what I did I could never get the page break to work correctly.
In the end I opened the RDL file in a text editor and did a find/replace for:
< KeepTogether > true < /KeepTogether >
I just changed these all to false and my report now prints correctly! I wish I knew which place I needed to change the property, but the brute force method worked this time. I wonder what else I changed in the report by setting them all to false.
Has anyone else had this kind of issue? Did you resolve it by modifying the RDL XML data? Just curious.
Thanks!
Nate
Yes, I have resorted to searching through and even modifying the XML data for various reasons. Probably only once did I actually modify it. Donât even recollect what it was for at this point. It is not much fun at all for these big, buggy, reports.
AR Invoices, those are the ones that make me pull my hair out with all the notes and comments sometimes. About every 3 months one will suddenly print only page 1 of 3 pages or something.
Currently struggling with the QuotForm, where all that I tried to do was âhideâ the Quantity Break fields and it went to throwing errors like âThat field is not in the datasetâ bogus errors. Does that whenever the line details and comments end up at the bottom of the page just right to kick the next one to the following page, it really doesnât like it and I can never reproduce it with the System version of QuotForm.
I see the rectangle. I tried shrinking the width and I tried deleting it. Neither seemed to alter the rendered output. Note that in report designer the width looks perfect. It is only in rendered mode that I see the ship to box get stretched. Actually, look back at the original picture. The area with ShipVia and Terms, also get stretched out to the edge of the page. Those are the only elements I see going past the page size. Are there any other likely settings I can try?
Thanks!
Thatâs because itâs the controls on the right side that you actually made larger, so for example, first select that top-right Expr box and change its size and/or placement if you need so that itâs out of the way and not on the far-right. Then go down the line, modifying the controls that are in the area you want clear. Then youâll be able to drag the right-side of the page over to the left again - no controls will be impeding it then.
Hope that helps. If not, I could take a little video that explains what you did much clearer. POForm especially is a super fun report - lots of tiny hidden reference boxes everywhere. Itâs probably one of those you need to fix to get the page break right, btw. Youâve totally got this!
Thatâs an odd one. Initially Iâd drag the right side of the page layout to open it up just to see the right edges of everything. Maybe check for the Can Grow settings. Sometimes I have to âTab throughâ each object just to make sure to end up on the actual containing object kind of thing. IDK, did you resolve this? Could probably take a look at it if it is an RDL that you can share.
Thanks for the good advice Michael and Erin! I havenât been back at this report yet. Thankfully this little expanded box is easy to overlook, and thus, easy to back-burner. I will try out your ideas and let you know if I am still struggling. Thanks!!
POForm.rdl (324.3 KB)
I tabbed back and forth to try to find any control with can grow still on. I didnât find any controls that looked to be a problem. I messed with the page margins. I even shrank some controls inside the tablix, so that I could shrink the right side of the tablix back, but nothing seems to help.
I attached a copy of the report. I donât think there is anything company related in there, as the data comes from the database. Curious if you see anything that stands out as an issue!
Thanks!
Nate
I loaded your RDL and noticed that the tablix looks even narrower than what prints (as shown in post #3). I clicked in the box (#1) and #2 shows the tablix width.
Also, there are two very tiny rows as the first two in that tablix. They seem so have a few textboxes in them. Did you mess with the properties of either those two rows, and/or the textboxes in them?
Yes, I shrank some controls in the tablix, so that I could shrink the right side of it. There are all kinds of tiny rows, hidden text boxes, and rectangles. I didnât make this report, I just modified it. I donât know why they are all in there. I assume Epicor built the base report with a bunch of extra spacer textboxes. At this point, I have messed with many of the textboxes, rows, groups, and other controls.
I solved this by cutting the shipto rectangle and inserting a new rectangle in that tablix cell, then pasting the shipto rectangle back in. This let me manually change the size of the rectangle container which seems to have done the trick! I also did the same thing for the ShipVia rectangle.
