Creating that Spreadsheet Feel

One of the few things that still suprises me to this day, is that in this day and age of scientific advance, free access to limitless information and people and things flying around at radical speeds, that some people abhore change.  If I had a chunk of cash for every time I've worked on putting in a 'new system' that they want it look exactly like the 'old system' then I'd be enjoying my very own Bugatti Veyron (http://en.wikipedia.org/wiki/Bugatti_Veyron) about now.

If you have a static number of columns you can simply lay down lines around the group headings, footers and detail sections.  However, if you are using one of those pesky crosstabs the object lays lines down around the populated data area but what if you want the grid filling the entire page?

Fear not - there is a work around for this as well.  It is achieved by firstly setting your grid size on File/Options to something sensible like 0.1cm and snap to grid.

 

Now create a section at the level where your crosstab will be positioned and draw the grid using the 'Line' objects. In the 'Section Expert' check the underlay next section.

 

Create a second section at the same level as the grid and put a crosstab here and align it to the grid.  With the gridsize being set at the start lining things up should be a doddle.

 

Finally giving you a result similar to below - which you can shape and change with much more flexibility than the built in crosstab options.

Done right you can achieve results like below

You could always export to MS Excel or similar from Crystal Reports - heh, good luck with that!

Examples from Crystal Reports v9.2