Online Documentation for All SQLManager.net Products
|
Report Designer |
  
|
The Report Designer allows you to create and edit reports.
To call this window select the Tools | Report Designer menu item.
This module is provided by FastReport (http://www.fast-report.com) and has its own help system. Press F1 to call the FastReport help.
Please find below the instruction on how to create a simple report in the Report Designer.
| 1. |
Open the Report Designer. |
| 2. |
In the designer select the Edit | Add Dialog Form menu item. |
| 3. |
Pick the Database component (lower on the left toolbar) and drop it on the form. |
| 4. |
Within the Object Inspector enter the HostName and the DatabaseName properties manually, e.g. 'localhost' and 'mysql'. |
| 5. |
Set the LoginPrompt property to True. |
| 6. |
Set the Connected property to True. |
| 7. |
Enter your login and password (e.g 'root' and empty password). |
| 8. |
Set the LoginPrompt property to False. |
| 9. |
Pick the Query component on the left toolbar and drop it on the form. |
| 10. |
Select the name of your Database component in the drop-down list of the Query1.Database property. |
| 11. |
Set the Query1.SQL property value, e.g. 'SELECT * FROM user'. |
| 12. |
Set Query1.Active to True. |
| 13. |
Go to the Page1 in the Designer. |
| 14. |
Using the Insert DB Fields button on the top toolbar insert your fields. |
| 15. |
Save the report on your local drive, e.g. C:\mysql_user.frf |
| 16. |
Click the Preview button on the toolbar. This mode allows you to view and print the result report. |
| 17. |
That's all! You can always edit your report by opening the designer and selecting the File | Open menu item. |
