BuyLog In
Ticket T578576
Visible to All Users

How to bind dashboards, reports, and analysis objects to external SQL Database Connections

created 7 years ago

Hello DevExpress Support,

we want to implement a XAF XPO solution for creating and viewing dashboards, reports and analysis views in win and web from external sql databases, not from existing business objects as sources. All available/usable sql database source paramaters should be stored in its own xpo.

When creating a new dashboard, report or analysis the user should select a sql connection from a list of available sql database connections.
When viewing dashboards, reports or analysis results in web or win, the In-XAF-viewers have to configure the sql database connection at runtime before they display the results. So it should be possible when changing a sql database source connection in xpo, all depentent dashboards, reports etc. don't need to be seperatly reconfigured, because they request their connections from xpo "SQLDataSource" for example.

What I just investigated:
- DashboardDesigner/Connection Wizard in Win supports Sql Connections via IConnectionStorageService, DashboardViewer in Win requests but Web doesn't request the ConfigureDataConnection event.
- ReportsDataV2 seems not to support SqlDataConnections because the Wizard shows only those business classes that have the DefaultClassOptionsAttribute, I think ReportsV2 should be linked to XtraReports in module.cs, the ReportsDesigner/Wizard is configurable like DashboardDesigner/Connection Wizard, so the common list of available SQL Connections can be replaced by own connections. The ASPxDocumentViewer and ASPxWebDocumentViewer seem not to fire the ConfigureDataConnection events, like Dashboards do.
- Analysis seems only to use business classes by default, so there is no possibility for changing to sql database connections.

Could you please tell me, if this set of requirements is implementable with XAF ?

Thanks a lot,

Comments (1)
DevExpress Support Team 7 years ago

    Hello, Maik.

    We need additional time to research your requirements. Please bear with us. We will respond once we have any results.

    Sign in to comment on this post

    Answers approved by DevExpress Support

    created 7 years ago (modified 7 years ago)

    Hello, Maik.

    The Dashboard and Reports controls have different ways for providing predefined data connections. Please review the following documentation topics

    Dashboards
    eXpressApp Framework > Task-Based Help > How to: Access the WinForms Dashboard Designer
    eXpressApp Framework > Task-Based Help > How to: Access the Dashboard Control
    WinForms Designer > Register Default Data Connections
    ASP.NET Dashboard Control > Register Default Data Connections
    How to define a custom IConnectionStorageService in DashboardDesigner Wizard to filter out unnecessary connections from an app.config file

    Reports
    WinForms End-User Designer - How to customize the data source wizard connection string storage
    Task-Based Help>How to: Add a Custom Column to the Reports ListWeb Reporting>Report Designer>API and Customization>Registering Default Data ConnectionsReportsV2 - How to activate the "Add Report Data Source…" option to add new custom non-XAF data sources in the runtime WinForms report designer

    The Pivot Chart Module supports work only with business objects, not direct sql database connections. But it is built using the XtraPivotGrid, ASPxPivotGrid and XtraCharts controls that support different datasources. You can implement your own analysis module by following the Using a Custom Control that is not Integrated by Default topic.

      Sign in to comment on this post

      Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

      Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.