O'Reilly logo

MySQL Management and Administration with Navicat by Gokhan Ozar

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Designing the report

While it is possible for us to design our report's layout by clicking-and-dragging the fields listed from the right-hand side onto the canvas and aligning them as desired, this is how a report is normally designed without wizards. This can get quite complex, so I will show you an easier way, which will help finish this report in no time.

Go to the File menu and select New.... A new dialog box titled New Items will pop up and will present us with four buttons as icons labeled Report Wizard, Report, Label Templates, and Cross Tab Wizard respectively. I promised the easier way, so we want the Report Wizard for this. It should be highlighted by default, but make sure it's selected. Then click on OK, as shown in the following screenshot: ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required