Change Order By - Crystal Reports 9


I have no prior exposure to Crystal Reports, but now I have to make a new report available to our Delphi 7 application. It will be basically the same report except the sort order is different.

I guess I need to change the Order By clause in the SQL query. I can see it from the menu in the designer, but I can't figure out how to edit it. I either have to know this, or how to change the Order By clause at runtime.

I'm reading books on Crystal Reports, but I haven't found how to do this. I might be able to find it with enough reading, in a week or so, but I only have a couple of days.

Help,

Jon
.

Relevant Pages

  • Re: Crystal Reports and Oracle Stored Procedure Insert statments
    ... I'm using Oracle 9i, Crystal Reports 10, ODBC connection. ... Look at writing queries with the WITH clause. ... My sub1 returns less rows than sub2, but is a more complicated query. ...
    (comp.databases.oracle.server)
  • Re: Newbie - Date range parameters question
    ... I have tried in but I get a Crystal Reports error ... Crystal Reports: Database Error ... >> I pass those parameters on to the SQL query? ... > clause of the SQL being passed to the database). ...
    (microsoft.public.vb.crystal)
  • Crystal Report, custom SQL
    ... I am using Crystal Reports and need to modify the SQL it calls each time ... it returns data (I need to add a where clause on the end of the ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Next vresion reporting
    ... consolidated updates available and many issues addressed... ... you can still use active data connectors to get data directly from Delphi ... > I'm totally amazed to see demand for Crystal Reports. ... > have to start over just to change the original query (and it deletes all ...
    (borland.public.delphi.non-technical)
  • Re: Crystal Reports and Delphi
    ... We use this technique to create a crystal viewer in Delphi ... You should be able to embed the desinger components into your Win32 ... app using RDO as well, although I have not tried this. ... Most of our customers don't build their own crystal reports. ...
    (borland.public.delphi.thirdpartytools.general)