Ticket S170931

Visible to All Users

Data Binding - Provide the server-side data processing mode (Server Mode)

DevExpress Support Team

created 12 years ago

saif Mohammed 11 years ago

Hi Guys, Any estimated time frame for the Server Mode data processing feature?

DevExpress Support Team 11 years ago

I am afraid at present I cannot provide you with any estimated time frame, because we have not established the release date for this feature. You will receive a notification when it is implemented.

saif Mohammed 11 years ago

Hi,
Are you planning to introduce this feature in the new version (14.1) or not?

Reinhold Erlacher 11 years ago

I'm interessted too! ^-^

Mike_Grace 11 years ago

And me. Dashboard Loading performance is very slow.

Anderson Luiz Mendes Matos 11 years ago

Either implement server mode or give us a better way to do it, like with the PivotGrid, where we can handle sums, groups and more to write our own SQL commands.

Simon Smith 11 years ago

I definitely need this! In fact, having just got round to looking at the Dashboard (been meaning to for some time), I am disappointed that it's not really suitable for large amounts of data, I am a heavy user of XPO and the XPServerCollectionSource for that reason. Let's be honest, any data analysis that's worth doing is going to involve a sizeable amount of data. I hope this feature is on the cards…

Mark Couvaras 11 years ago

Simon Smith is certainly right and would also like to see this feature

Jonatas Hudler 11 years ago

+1 Simon

Reinhold Erlacher 11 years ago

+1 Reinhold

Xavier AYRAL 11 years ago

I need this to. Is there a scheduled date for the release ?
My customers want a date.

DevExpress Support Team 11 years ago

This feature will be introduced in version 14.1, which should be released at the end of May.

Simon Smith 11 years ago

Good news! I look forward to the next release…

Answers approved by DevExpress Support

DevExpress Support Team

created 11 years ago (modified 10 years ago)

We have implemented the functionality described in this ticket. It will be included in our next update(s).

Please check back and leave a comment to this response to let us know whether or not this solution addresses your concerns.

Additional information:

With v14.1, the DevExpress Dashboard allows you to connect a dashboard to a SQL database with a large number of records using the Server Mode. The main server mode feature is that data-related operations are performed on the server side, while in default data binding modes, these operations are performed on the client side.

After the upgrade, the Server Side data processing mode is automatically enabled for all SQL Server data sources. It is possible to switch data processing mode using the ribbon menu or by setting the DataSource.DataProcessingMode property in code:

C#
DataSource dataSource = DashboardDesigner.Dashboard.DataSources[0];  
dataSource.DataProcessingMode = DataProcessingMode.Server;

*Note: After converting a project to a newer version, it is necessary to update the ribbon by executing the Create Ribbon command from the DashboardDesigner smart tag menu.

DxScreenshot.png

Show previous comments (7)

L.J. van Oort 11 years ago

Is server mode also possible for the pivotgridlisteditor in XAF?

DevExpress Support Team 11 years ago

The PivotGridControl does not yet provide native support for server mode processing. We will update the corresponding ticket once we make a final decision: Server Mode Support.

Martin Praxmarer - DevExpress MVP 11 years ago

Is Sever Mode activated by Default - or should there be made any changes in code?

DevExpress Support Team 11 years ago

The Server Side data processing mode is automatically enabled for all SQL Server data sources. I have added corresponding information to the original answer.

Xavier AYRAL 11 years ago

I realize some test for my client. I want to know what is the best for me between Winform or MVC application.
What is the way for implement Dashboard in MVC application ?
I create a project in server mode with a grid which work perfectly, now i need some Dashboard.
I try to reproduce the same way but for the moment i have not been able to do it.
Can i have some advice ?
Thanks

DevExpress Support Team 11 years ago

It appears that this question is not connected directly to the subject of the thread. To avoid any possible misunderstanding in our following discussion, I have created a separate thread for your second question and will answer you there ASAP. I would like to ask you to create a separate thread for each question, suggestion, or bug you want to ask in the future. Thank you for your cooperation.
What is the best target platform WinForms or MVC

Mike_Grace 11 years ago

I have just upgraded to 14.1.3 and loaded a dashboard into the designer. I have 2 data sources. I only appear to be able to toggle server mode on the second data source. When I select the first data source, server mode is disabled/greyed out. Is this correct?
My data source is SAP-Advantage.
I have attached the dashboard xml file

Sales.xml

Mariusz Muszalski 11 years ago

Is that new option only for Dashboard Designer?

Mariusz Muszalski 11 years ago

Server mode option is disabled for OLAP datasource. Is it by design?

DevExpress Support Team 11 years ago

Yes, it is by design. In OLAP mode data is always aggregated at the data source level. We only display values retrieved from the server in a convenient form.

Created: March 25, 2013 9:09 AM

Modified: March 17, 2015 5:55 AM

Platform: Business Intelligence

Product: Dashboard for WinForms

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.

Data Binding - Provide the server-side data processing mode (Server Mode)

Answers approved by DevExpress Support

Recently viewed tickets