DB Dataqsource Sorting

[Former Member]

Hi,

I would like to be able to sort data in a matrix based on certain column selections by the user. I am using a DB datasource to populate this matrix. I dont see a DBDataSource.Sort() method? How can I implement this sorting capability in a matrix using DBDatasources.

Any help is appreciated.

Thanks,

Gopal

[Eneveux · Accepted solution]

Gopal,

Sorting in a Matrix or a Grid needs to be done manually using the sorting methods provided by the IDE that you are using such as those methods available with VB.Net. You are correct that there is not a "sort" method that it supplied via the SDK. Hopefully we will see this in an enhancement.

HTH,

Eddy

[Former Member · Accepted solution]

Hi,

thanks Rasmus and eddy for your response. Based on your response here are my conclusions:

1. I am using SAP 2005 SP1. So based on Rasmus's response, there is a bug in the grid that will prevent me from doing this.

2. I cannot use the DB DS to do this.

Eddy,

What do you mean by the "Sorting in a Matrix or a Grid needs to be done manually using the sorting methods provided by the IDE". By IDE are you referring to Visual Studio or SDK interfaces?

Thanks,

Gopal

[rasmuswulff_jensen · Accepted solution]

Well... The bug have a work-around... see this thread:

[rasmuswulff_jensen]

Well. SAP Doesn't support dbds sorting... They promised the feature for som time now (First time I heard about it was SBO2004A)... Now 2006A is the best bet...

If you use SBO2005A and are not using UDO's, you can perhaps use a Grid-item instead .. Here you doesn't need to use the condition object, but get to use sql (and in there sort by)... But sigh... if you use SBO2005A SP01 there are currently a bug that prevent you from using this feature of the grid (aka a normal day in the life of a SDK-programmer)...

If you don't have access to the grid object you could use a matrix with userdatasources, and fill it with a recordset (Works but slow solution)...

Then there's the hack solution where you create a temp table that suit you matrix-data and use this as dbds (This hack also left you do pseudo joins to fill matrixes)...

To sum things up: Can't do it with a matrix. Use grid instead...