SQL Server Report Template - Insert Map

Step 01> Open the report template and Click the Image button in Insert tab on the toolbar.

Step 02> Place the image where you would like the map to be on the export. This will open the ‘Image Properties’ window.

Step 03> Enter the image name and set the Image Source to ‘External’

Step 04> Enter the Expression form by Clicking on the fx button next to the ‘Use this Image’ drop-down list box. Set expression for: value as:

="http://localhost/Dekho/MapServlet?sessionid="&Parameters!sessionid.Value

Step 05> Click on the ‘Size’ tab on ‘Image Properties’ window and select ‘Fit to size’.

Step 06> Click on the ‘Visibility’ tab on ‘Image Properties’ window and select ‘Show’.

Step 07> Click on the ‘Action’ tab on ‘Image Properties’ window. Leave the setting as shown in the screenshot below:

Step 08> Click on the ‘Border’ tab on ‘Image Properties’ window and select values as per your requirements.

Step 09> Click OK on ‘Image Properties’ window. This will close the window. Save the report and upload to the SQL Server report server.

Test the Report

Step 10> Load Dekho Map Client, navigate to the map to which report was added. Generate the report using ‘Generate Report’ button and view the report. Map will be exported to the report as shown in the screenshot below:


SQL Server Report Template - Insert Table