Create Groups from database-Crystal Report

[Leite333]

Goodmorning
I want little help in a crystal report i try to create.

I wrote the above query
{Emp016.DatePar} >= {?@CXD@_From Date} AND
{Emp016.DatePar} <= {?@CXD@_To Date} AND

{Emp016.PelProm}="1" AND
{Emp016.KwdPar} IN [1,3,5,6,9]

This query select receipts from a database with code 1,3,5,6,9. Now i want to make groups for each code and print a header for every code. For example

1.Receipts->> Customers Sells
-----------------------------------------------------
1......
2.....
3.....
4.....

3.Receipts->Suppliers Sells
----------------------------------
1.....
2.....
3....
4.....

Something like that. I already collect the data 1....,2..... but i cant create the groups with their headers. Can someone help;;; Do i have to change my query or i can make something other.

[jggtz]

You could create those groups in the report itself
In CR ide: menu / insert / group
select {Emp016.KwdPar} field
in group header section insert a formula field

If {Emp016.KwdPar} = 1 Then "Customer Sells" Else
If {Emp016.KwdPar} = 3 Then "Suppliers Sells" Else
If {Emp016.KwdPar} = 5 Then "aaaa aa Sells" Else
If {Emp016.KwdPar} = 6 Then "bbbb bb Sells" Else
If {Emp016.KwdPar} = 9 Then "cccc cc Sells" Else
{Emp016.KwdPar}