Skip to Content
0
Former Member
Feb 14, 2007 at 06:56 AM

How to have spreadsheet like columns in report (like an Excel grid)

77 Views

<p>I am trying to make a report in landscape format with around 15 columns across the sheet. The data is sales numbers per months plus total, budget and deviation (calculated).</p><p>The data should be in an <strong><u>Excel-like grid</u></strong>. The individual cell would obviously be fairly small so it fits across one page.</p><p>I have been playing with this for some time. Aligning so many objects seems to be a lot of work. The tools in CR are not very proficient for such type of layout.</p><p>You are lost if you want to insert a column. I did not find a way to move all fields across all sections to the right to make room. It gets all screwed up.</p><p>The grid, I tried it with borders around the fields and with horizontal / vertical lines to create the grid.</p><p> Any good tip for a better way of doing that?</p><p> Thanks in advance!</p><p>Stefan Koellmann</p>