Crystal Reports - Programatic Sorting

[simonm]

Hi,

I have VS 2005 and am running a crystal report bound to a typed dataset (that gets it's data from a SQL 2000 database).

Can anyone tell me how I sort the data programatically?

I cannot sort the data in the stored procedure nor can I define the sort fields in the crystal report at design time because they must be specified by the user at run time.

I have tried creating a DataView object and sorting that but the SetDataSource property doesn't take a DataView (only a DataSet or DataTable).

I noticed a ReportDocument.DataDefinition.SortFields object but it doesn't appear to have anyway of adding sort fields.

Please help!

[Ph0b0s]

Have anyone find a solution to this problem? I've the same probleme. Sometimes, i must sort with 2 fields, sometimes with 3, on the same report.

In VB6, we could way easly do this. In VS 2005, with VB i cant really find a way to, neither info on the internet.

Thanks in advance!

[sparrow1]

Hi,

This link could help you to sort data;

http://msdn2.microsoft.com/en-us/library/wxks80sb.aspx

Hope it helps,

sparrow1

[Ph0b0s]

It would help sparrow1, but in fact i'm talking about Crystal Reports for Visual Studio 2005, and not Excel. Maybe you got the wrong link? Hope so, i can find any good info on sorting expert in the programaticly way.

[sparrow1]

It would help sparrow1, but in fact i'm talking about Crystal Reports for Visual Studio 2005, and not Excel. Maybe you got the wrong link? Hope so, i can find any good info on sorting expert in the programaticly way.

Hi,

Here's the link for Crystal reports for VB.Net 2005;

http://msdn2.microsoft.com/en-us/library/ms345074.aspx

Hope it helps now,

sparrow1

[Ph0b0s]

Had already checked it. No info in microsoft website. The inly info they gave is how to change a pre-created sort entry, but no info how to create a new entry.

[sparrow1]

Had already checked it. No info in microsoft website. The inly info they gave is how to change a pre-created sort entry, but no info how to create a new entry.

Hi,

Try this link how to create a new binding;

http://msdn2.microsoft.com/en-us/library/ms227360.aspx

Wkr,

sparrow1

[Ph0b0s]

I'll check it, it's another way to do it.

It was so simple to add new sorts on previous Crystal Reports Engines... dunno why they take what was working well and was helpfull.