Search code examples
crystal-reports

How to edit Crystal Report "Show SQL Query"?

I want to modify "Show SQl Query" at crystal report. I had read many articles that tell (Report -> Selection Formula -> Record) but i still can't find it.

This is the code from "Show SQL Query" 

 SELECT `TestResult`.`LotNumber`, `TestResult`.`TestNo`, `TestResult`.`Test1Result`, `TestResult`.`Test2Result`, `TestResult`.`Test3Result`, `TestResult`.`Test4Result`, `TotalResult`.`TotalTested`, `TotalResult`.`TotalReject`, `ReportUse`.`Label1`, `ReportUse`.`Label2`, `ReportUse`.`Label3`, `ReportUse`.`Label4`, `TotalResult`.`ItemNumber`, `ReportUse`.`Parameter1a`, `ReportUse`.`Parameter1b`, `ReportUse`.`Parameter2`, `ReportUse`.`Parameter3`, `ReportUse`.`Parameter4`, `EEPROM`.`ProgrammerStation`, `TestResult`.`Eeprom`, `TestResult`.`FlowTest`, `TestResult`.`Remarks`, `TestResult`.`TNo`
 FROM   ((`ReportUse` `ReportUse` INNER JOIN `TotalResult` `TotalResult` ON `ReportUse`.`ItemNumber`=`TotalResult`.`ItemNumber`) INNER JOIN `TestResult` `TestResult` ON `TotalResult`.`LotNumber`=`TestResult`.`LotNumber`) INNER JOIN `EEPROM` `EEPROM` ON `TotalResult`.`ItemNumber`=`EEPROM`.`ItemNumber`
 ORDER BY `TestResult`.`TestNo`

I want to change this code to "ORDER BY Tno" instead of "ORDER BY TestResult.TestNo"

Solution

  • You cannot. You have to set required order from some CR menu (Report - Record sort expert on my old CR v11).