Failure Codes (Problem, Cause, Remedy) order issue

Migrateduser

<p>Hello,<br>
 <br>
I'm still getting to grips with eclipse and SQL, but I would really appreciate some advice on how to correctly order the problem, cause & remedy data within a table element.<br>
 <br>
Within the SQL im brining back <em>workorder.problemcode </em>in the select staetment. This will bring back the problem, cause and remedy fields, but unfortunately, on the report it will list them in the wrong order; for example:<br>
 <br><strong>cause</strong><br><strong>problem</strong><br><strong>remedy</strong><br>
 <br>
or<br>
 <br><strong>remedy</strong><br><strong>cause</strong><br><strong>problem</strong><br>
 <br>
Ideally, I want to show the order as<br>
 <br><strong>Problem</strong><br><strong>Cause</strong><br><strong>Remedy</strong><br>
 <br>
Appreciate any help with this matter.</p>