Skip to Content
0
Former Member
Oct 08, 2014 at 08:57 AM

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)

16 Views

(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.