My finance manager showed me that the info for the checks is slightly too high. So I went in to the SSRS and moved the text box down. This actually caused the data to print higher up on the check. I tried to go higher and it was even higher! Ideas on why this may be?
First off, is a different printer being used? It might be a margins issue. (probably not)
If SSRS fileds arent at the same level and same height, or overlap each other, they can sometimes force other fields to be pushed around.
This might help.
1 Like
I think this is pretty common with the checks - moving things yields unexpected positions when printed.
This link might help…
One thing I learned with SSRS… one does not hide a field… you put in a formula to populate the value or make it blank “”… Shifts everything around. #CommonSSRSProblems
1 Like
So I have been working on this and found some interesting info out. When I print from the Report on the server, it prints correctly. If I print it from the local computer of my Accounting team, any of them, it prints out out of alignment. Anyone seen this before? I am lost on this one.
If you mean the Report Designer then yes, the print outs from that will not always match what the user will get. There is a “Print Layout” helps but I still don’t trust it to be 100% what will actually print, I use it to get close and always verify via a real print in Epicor.
Yes, that is what I was meaning. I use that setting and every time its accurate, until now. Interestingly, no matter how I adjust the print, it always prints wrong. Crazy! Hate it for sure!
That’s like when I loose my keys; They are always in the last place I look! 
1 Like
I moved the check part of it down to the very bottom at 10.5. Now the top portion that has the invoice number, desc, amount, discount, and Net Amount lines are being carried over to the next page. Even if there is only like 2 or three of them. The first one is the top half of the layout. The next three are the first three pages. I’m lost. I’ve never seen the top half ever not use up all the space given it and instead put it on the next page.
I’m pretty sure the Check Report cheats by placing the Check Info in the Footer section, and sizing it to the check height. That way the section is always aligned with the bottom of the page.
The “body” section of the report does not need to be a specific height. The Foooter will always align with the bottom of the page.
In fact the body section should be as small as possible. It should be set to “Can Grow” and even if that section grew such that more lines are needed than fit on the first page, they would appear on a second page.
But now that I think about it, since the checks are pre printed, you want each check (the actual info that goes on the check and the invoice list) to only ever be one page.
So, I need to keep it “As Small as Possible” because Check Report doesn’t care how far down it goes. If that is the case, then that may be why some of the things are being put over into the next page. However, when I do that, the info never lines up correctly with the check we are printing on. The dollars and cents part.
Here’s the original ChkPrint, with the Footer background set to cyan, and the Body background set to yellow - Just so you can see
The Footer.Height is set to 10.45562cm
The Body.Height is 1.3208cm
There is a Header (even though no fields) whose height is 1.27cm
We have the same problem. We still print some checks from 8 and they are fine, all the checks from 10 on the same printer are misaligned.
When placing the fields in the “check area”, measure up from the bottom of the page of the pre-printed check sheet.
If the line for the dollars and cents needs to be 2" from the bottom of the sheet. And the field hieght is 0.17", the Footer.Height is 5", and there is a 0.16" bottom margin (Report Properties).
The field should be placed at (5+.16) - (2+.17)
the (5 + .16) is how far the top of the footer is from the bottom of the printed page
The (2 + .17) is how far up the from the bottom of the page the top of the field should be
EDIT
many of the fields in the “check area” are actually inside a rectangle, so their position is actually relative to to the top of the rectangle. So account for that.
Is that under Properties–>Location/Size?
Yes. Select the object in the design window (you may have to right click and use the “Select…” submenu to select objects behind others.) Then scroll down to the bottom of the properties pane and you’ll see a Height (for the section sizes) or a Location (with two fields X and Y) for objects like textboxes and rectangles.
All it seems to do is the white space area larger or smaller, but not much else.
Referring to the screen shot below,
- The white is the header (with no fields and will always take up the top 1.27cm of the page
- The yellow is the Body and always starts right below the header.
- The position of fields in the body is relative to the top of the body section - Which is always 1.27cm from the top.
- The body section will grow to fill the space between the header and footer. The red arrow shows the area that will grow.
- Should the body need to be bigger than the page size minus the head and footer heights, additional page(s) would be added. But none of them would ever have a body section bigger than the page height minus the headear and footer.
- The cyan is the footer and will always take up the bottom 10.45562cm of the page.
And how do I get the footer to print closer to the bottom? That number I can not find to change. The only numbers I see are the ones that change the text box sizes.
The footer should automatically align with the bottom of the page.
Hover around where the red arrow is shown below and right click. Then choose Select … then Footer.
In the properties window, set the background color to cyan. This is just to help you see where it is being placed on the rendered report. We’ll remove it later.
Run the report and see where the cyan shows.
I’ve got to run now, but will be back later tonight.
1 Like