devexpress-examples / reporting-winforms-designer-connection-save-safe Goto Github PK

View Code? Open in Web Editor NEW

Customize the WinForms End-User Report Designer and allow users to save only the connection name for the newly created reports.

License: Other

C# 48.04% Visual Basic .NET 51.96%

reporting-winforms-designer-connection-save-safe's Introduction

Reporting for WinForms - How to Enable the Report Designer to Save Only Connection Name with Reports and Exclude Connection Parameters

This example shows how to customize the list of available connections in the WinForms end-user report designer to allow users to save only the connection name for newly created reports.

This example implements the IConnectionStorageService to create a storage for connection strings available for the newly created reports.

A user can select a connection from a custom predefined list. Newly created report stores only the connection name and exclude sensitive information (data source name, username, password). For this, the connection.StoreConnectionNameOnly option is enabled in the IConnectionStorageService.SaveConnection method.

In the code, you can use the `IConnectionStorageService.IncludeApplicationConnections' option to specify whether the Data Source Wizard should include the connections that are contained in the application configuration file.

Use the XRDesignMdiController.DataSourceWizardSettings.SqlWizardSettings.DisableNewConnections option to specify whether the users are allowed to create new connections.

Create a service that implements the IConnectionProviderService interface. The service allows users to open a saved report with a connection specified by name and restore the connection to view, print, and export the report.