Reportbuilder report sorting error

Question

In a report built in Delphi7 Reportbuilder I have vendor information in a group header and vendor items in a Detail tab just below. The problem is that it is not possible to sort items (Detail) according to parameter ('C' code or’D' description)

More information:

The report data comes from a precedent and the ordering is done directly in the Dataset of the report object in Delphi. That is, I have a precedent that mounts all the sql where the data is pulled that will be displayed while in the IDE the Dataset component has in its sql code the order by that should order the header in alphabetical order and the items according to the parameter.

ex: with code 'C' sorting parameter, i.e., items sorted by code

FORNECEDOR A
item 1 "B"
item 2 "A"
item 3 "C"

FORNECEDOR B
item 1 "B"
item 2 "A"

• If I change the parameter to’D' the result remains the same when expected:

  SUPPLIER TO item 2 "A" item 1 "B" item 3 "C"

  SUPPLIER B item 2 "A" item 1 "B"

in the dataset, obviously gets:

    select (dados) from procedure as alias 
order by (campo do titulo do fornecedor, 
case par_ordenacao
 when 'C' codigo when 'D' 
descrição end

Answer 1

Try it that way:

case
    when par_ordenacao = 'C' then codigo
    when par_ordenacao = 'D' then descricao end asc