When showing SQL statement in [Database]-[ShowSQLQuery], only the first 2 definitions appears in the orderby query. (It should display all of the 4 definitions)

[Former Member]

(1)Environment

  - Client: SAPCrystalReports2011(Windows7)

  - Server: Oracle11gR2(WindowsServer2012)

(2)Operations and Problem

  - Operation1:

     Set 1 group definition in [Report]-[GroupExport]

  - Operation2:

     Set 4 sorting definitions(including the group definition in Operation1) in [Report]-[RecordSortExport]

  - Problem:

     When showing SQL statement in [Database]-[ShowSQLQuery], only the first 2 definitions appears in the orderby query.

      (It should display all of the 4 definitions)

(3)Remark

  - This Problem occurs if I use a report-file that is created by CrystalReports4.0(1995Release) in SAPCrystalReports2011.

(4)Request

  - Please instruct me how to properly handle this issue.

[abhilash_kumar · Accepted solution]

Hi Anzai,

Could you please elaborate on the 'definitions' part please?

-Abhilash