ISA Consulting has joined Facebook, become a fan and keep up with the latest from ISA:

http://www.facebook.com/pages/ISA-Consulting/334682629513

How to hide & unhide columns, rows or totals

To create a bar chart that compares products for 2005, 2006 and 2007 it requires that you hide 2004, the Time summary and the More & Hidden columns.

Right-click and hide 2004:

Hide More & Hidden and Time Column:

Bringing back 2004 data, Click on the Properties icon:

Click on link to Time link:

Click on down arrow by Hidden items and select Unhide 2004:

Click on Subtotals link:

Put a check mark next to Overall total and click on Save:

The report with no hidden columns:

Setting Page Breaks

Creating sections in a report allows you to then create page breaks off of those sections.

To create a section:

1.      Highlight the column you would like to use as the section.

2.      Click on the Section icon.

To create the Page Breaks:

1. Highlight the sectioned report item

2. Change Layout \ Set Page Breaks

To see the page breaks:

1. Run Report

2. View as PDF

Note: The PDF file will show a page break after all the products for each retailer listed.

In this example there is a section on Retailer and Product Line.  Use Page down to see how the report pages break after each product for a retailer.