Skip to Content
0
Former Member
Mar 03, 2009 at 10:32 AM

beginner - how to set order at runtime

30 Views

Hello

i'm using Microsoft Visual Studio 2008 Version 9.0.21022.8 RTM, Microsoft .NET Framework Version 3.5 and

Crystal Reports Basic for Visual Studio 2008.

In my web app users can set some values on an asp .net page and pass them to the page which will show the report. I'm been able to select a subset of records using a parameter, Now i need to specify the order (orderby in sql terms) the data is shown.

For instance a user might wish to order infos by date, by date and document id, by office and so on.

I'm gathering data with a microsoft dataset, and the designer doesn't let me use sql expressions

I can't understand how to do this at runtime:

shall i do that handling the dataset?

shall i use a formula? If so could you provide me an example please, since all my attempts haven't been succesfull?

Shall i do that by code? If so which class o property let me set the order of the records ? i've used the CrystalDecisions.Shared and the engine namespaces till now

thank you in advance

Stefano