Skip to Content
0
Former Member
Jan 16, 2012 at 05:39 PM

How to remove gaps with columns or something similar

55 Views

I have tried to search for my problem, but I can't figure it out.

Our ERP program at work uses crystal reports and we're a small company so we don't have a dedicated person to do this. I have managed to extensively modify the forms and add custom fields but one problem eludes me.

On some forms, the report prints the part number, description, quantity, and price along a row. If there are multiple quantities, the report displays another row with just the quantity and price. It does not display the part number and description again. However, if the description is so long that it goes down to the next line, it puts a space in between the current line and all of the subsequent quantities and prices. The photo below will make this much easier to understand.

link: [http://i.imgur.com/6k2lX.jpg]

I want to remove that space. I realize it is spacing down because it puts the second quantity on the next line, and the description is pushing that line down. I figure that some kind of column would fix this, however, simply using the section expert and selecting format with multiple columns, and creating a column in the right place doesn't work at all. It removes the quantities and prices completely.

Any recommendations would be very helpful

Thank you