We’ve had some great feedback from our Newsletter announcing the release of v7. A number of users have asked how we created the example in the Newsletter:
So, today we’re going to show you how to achieve some of the formatting that is now available when using SQL tables in v7.
Let’s create a SQL table from Grids & Tables tab. You’ll see the Create connection window:
Click Connect and you will see the databases you have access to….we’ll create our query based on Bicycle Sales and the fctData view.
Our SQL query returns the following data which is great but clearly is not that easy to read.
Let’s format this table. We’ll get rid of any borders currently set on the workbook by going to the format sheet and using Format Cells on the default cell format cell as below:
Back to the table, right-click and refresh table.
Now for the actual formatting of the table. Let’s format entries in the first column cPOS. Right-click on Car and Bike Stores, right-click and select Format Column and let’s set the font to be bold, size 12 with a double border on both top and bottom.
Now the second column cProduct. Again right-click Format Column and set the top border to be double, bottom border thick and the font italic.
We now go to Properties tab and on Appearance tab set Sections as below:
Check the box ‘Use columns as sections’, the column count is 2 in our example and Display style is set as ‘Sections in separate rows’.
We’ll also hide the first row of the workbook showing the table column headings.
The report now looks like the screenshot below which is much easier to read.