Open a table or SQL query result. For table, switch to Data page.
Let's print the dataset adding totals: sum of PAYMENT_SUM column and count of all records.
Solution 1: Exporting Data
You can export data to some common formats like HTML, Excel, PDF. For these formats, Database Tour supports adding totals. Please see the detailed example for exporting data to HTML. After exporting, open the created file in your browser and print it.
Solution 2: Using Report Builder
This solution is available in Database Tour Pro only.
- Click Report Builder button.
- Mark with check Totals band in Report Tree window to make it visible.
- Place Expression object on this band under the PAYMENT_SUM column. In Object Inspector window, locate Expression property, and invoke the Expression Editor by clicking button '...'. In the editor, type dataset_sum(1, 0, 'PAYMENT_SUM') formula. Then click OK.
- Place another Expression object somewhere on the Totals band. In Object Inspector window, locate Expression property, and invoke the Expression Editor by clicking button '...'. In the editor, type dataset_row_count(1, 0) formula. Then click OK.
- Add other expressions if you need.
- Click Preview.
- In Preview window, click Print, select needed options and click OK.
See also
