Report spacing

Epicor ERP 10
2

I can’t answer exactly what does determine it. But I can give you some guidlines that I use to minimize these issues

  1. All text boxes that are meant to be on the “same line” , should have the same height, and have their tops aligned. Also make sure they have the same margins.
  2. I never put a text box such that it’s top overlaps with textboxes in the “line” above it.
  3. When the report is to be exported for Excel, the columns are based on the left and right edges of the fields and the spaces between them. Try to make the lfet and right edges of text boxes line up with those of above them. And eliminate space between them.
  4. A textbox that exactly spans the width of two boxes above it, will generally create a merged cell. For example:
  • Row 1 has two fields: Txt1.Left=0, Txt1.Width=1, Txt12Left=1, Txt2.Width=1
  • Row 2 has one filed: Txt3.Left=0, Txt3.Width=2
    This would make two columns with Txt3 spaning both.
  • If Row Txt1.Width=0.5, then the output would have three columns. The first being 0.5" wide, the second being 0.5", and the third 1". Txt1 would appear in cell A1, cell B1 would be blank, and Txt2 in cell C1. Cell A2 ould contain Txt3, and span cols A…C.
2 Likes