DevForce Classic: Crosstab databinding

Crosstab databinding

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce Classic
Forum Discription: For .NET 2.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=845
Printed Date: 11-Jun-2026 at 1:37am

Topic: Crosstab databinding

Posted By: jarith
Subject: Crosstab databinding
Date Posted: 16-Jun-2008 at 10:07am

Hello,

I have a data entry form which looks much similar to the one you can see in the below URL

http://www.codeproject.com/KB/aspnet/Data_Entry_and_GridView.aspx - http://www.codeproject.com/KB/aspnet/Data_Entry_and_GridView.aspx

I would like to know whether DevForce supports crosstab databinding on Datagridview or XtraGrid. Any sample would be highly appreciated.

Thanks.

Regards,

Jarith

Replies:

Posted By: davidklitzke
Date Posted: 16-Jun-2008 at 7:33pm

I have not built an example. but the IdeaBlade DevForce AspDataSource supports the DevExpress PivotGrid in ASP.NET, so I believee that the example Code Project should be able to be ported.

I also found this on the web:

http://demos.devexpress.com/XtraReportsDemos/ReportControls/XRPivotGrid.aspx - http://demos.devexpress.com/XtraReportsDemos/ReportControls/XRPivotGrid.aspx

This demo shows how to create a cross-tab report. To accomplish this, use the XRPivotGrid control (which can be added to any report band) and then bind it to a report's (or its own) datasource to display data in a matrix form.

Posted By: jarith
Date Posted: 16-Jun-2008 at 7:50pm

Hello David Klitzke.

I am aware of XtraPivotGrid but what I am looking for is 'Editable' PivotGrid similar to the one you can find in the below URL

http://69.10.233.10/KB/vb/MatrixInputGrid.aspx

There is a workaround to use XtraPivotGrid as an editable control but it is a complex procedure and I do not know how to link DevForce with it.

I think DynamicProperties or DynamicEntities can be used to achieve the Matrix Input.

I appreciate your help.

Regards,

Jarith

Posted By: jarith
Date Posted: 16-Jun-2008 at 7:52pm

Also, I need this for Windows Forms app and not for web.

Thanks.

Posted By: davidklitzke
Date Posted: 18-Jun-2008 at 10:16am

Jarith,

We have no Pivot Controls (including any from Developer Express) that we advertise that we support for Windows Forms, but it may be possible to port a Pivot Grid control so that it could be used by DevForce. This is an unknown amount of work. It could be a few hours or a few weeks or might not even be possible at all.