Failure Codes (Problem, Cause, Remedy) order issue
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.
Within the SQL im brining back workorder.problemcode 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:
Ideally, I want to show the order as
Appreciate any help with this matter.