Quick Reporter example 01 Simple.

Lets take the scenario of our datastore is an Excel worksheet to hold employee details. In the worksheet we hold the employee details for several companies. The data is similar to that below:-

	Title	Forename	Surname	Department	Salary	Company
1	Mr	Andrew	Cassidy	Technical	12,500	Ess
2	Mrs	Rachael	Roberts	Sales	16,500	Ess
3	Miss	Nadine	Smithe	Accounts	19,100	Ess
4	Mr	Frank	Talkin	Technical	16,000	TLC
5	Dr	Ian	Penkridge	Pharmacy	32,000	TLC

Our connection screen to the Excel document looks like this

if we click the [Get Data] button we can see the data our SQL returns.

When we click the [Accept] button we see our editor with the fields window filled ready for use

These can be drag and dropped onto the editor using the mouse. We can now start constructing our report until it looks something like this

All the objects on the report have been dragged from our fields window. We have only entered values into the free text part of the window and dragged those in to act as the headers ie 'Title', 'Forename', 'Surname' etc. The rest are either Data Fields or Report Fields dragged from the fields window.

Our final report looks something a little like this

We can change the properties for each field back in the editor and reproduce the report this time we have changed some items to bold and/or Italic and also the font size

We can also setup collection pages and conditions against each row on the report. We could make the salary be blue in colour if it was over 30,000 or red if it was negative. There are many conditions that can be set and this will be covered in example 02.

We hope this gives you a brief understanding of how to create a report from and excel worksheet. It shows that the data you retrieve from the datastore depends upon your SQL statement. Please see Example 02 for collection pages, running totals and setting conditions.

Goto Example 02