Online Documentation for SQL Manager for SQL server
Adding database and query components
To start working with report you need to define data source.
In order to add the Database component:
- proceed to the Data tab of Report tree;
-
pick the
ADO Database component on the toolbar (on the left);
- click within the working area - the corresponding ADODatabase1 icon appears in the area;
- use the Edit item of the component context menu item;
-
in the appeared window define database connection parameters using the connection string or the standard windows dialog window that can be opened by pressing the
ellipsis button. SQL Native Client should be specified as data provider;
- make sure that the Connected property value in the Object Inspector is set to True.
In order to add the Table component:
- proceed to the Data tab of Report tree;
-
pick the
ADOTable component on the toolbar (on the left);
- click within the working area - the corresponding ADOTable1 icon appears in the area;
-
Define the following options in the Object Inspector: Database (select any defined
ADODatabase) and TableName (select a table from the connected database). Once TableName is specified, all columns from this table are displayed in the Data Tree.
In order to add the Query component:
- proceed to the Data tab of Report tree;
-
pick the
ADO Query component on the toolbar (on the left);
- click within the working area - the corresponding ADOQuery1 icon appears in the area;
-
use the Object Inspector to define the following properties: Database (select any defined
ADODatabase) and SQL (press the
ellipsis button to open Query Data where you can define query text).