WizardSettings.EnableSqlDataSource Property

Allows you to hide the Database option and related pages in the Data Source Wizard.

Namespace: DevExpress.XtraReports.Web.ReportDesigner.DataContracts

Assembly: DevExpress.Data.v23.2.dll

NuGet Package: DevExpress.Data

Declaration

C#

[DataMember(Name = "enableSqlDataSource")]
public bool EnableSqlDataSource { get; set; }

VB.NET

<DataMember(Name:="enableSqlDataSource")>
Public Property EnableSqlDataSource As Boolean

Property Value

Type	Description
Boolean	true to enable the Database option; otherwise, false.

Property Paths

You can access this nested property as listed below:

Object Type	Path to EnableSqlDataSource
ReportDesignerSettingsBase	.WizardSettings .EnableSqlDataSource

Remarks

The following image shows how the EnableSqlDataSource option affects the Select data source type wizard page:

The following code disables the EnableSqlDataSource option:

ASP.NET Core - Bind to Report

var designerRender = Html.DevExpress().ReportDesigner("reportDesigner")
            .Height("100%")
            .WizardSettings(s => s.EnableSqlDataSource = false)
            .Bind("TestReport");
@designerRender.RenderHtml()

ASP.NET Core - Bind to Report Model

public IActionResult Designer(
    [FromServices] IReportDesignerClientSideModelGenerator clientSideModelGenerator,
    [FromQuery] string reportName) {
    Models.ReportDesignerCustomModel model = new Models.ReportDesignerCustomModel();
    model.ReportDesignerModel = CreateDefaultReportDesignerModel(clientSideModelGenerator, reportName, null);
    model.ReportDesignerModel.WizardSettings.EnableSqlDataSource = false;
    return View(model);
}

ASP.NET MVC

@model ReportDesignerModel

@Html.DevExpress().ReportDesigner(settings => {
    settings.Name = "ReportDesigner1";
    settings.SettingsWizard.EnableSqlDataSource = false;
    // Add the created data source to the list of default data sources.
    foreach(var dataSourceItem in Model.DataSources)
        settings.DataSources.Add(dataSourceItem.Key, dataSourceItem.Value);
}).BindToUrl("TestReport").GetHtml()