>>Dear all,
>>I have a table with some records such as below :
>>
>>RecType-Step-Fee
>>1-1-100
>>1-1-200
>>1-2-400
>>2-1-300
>>2-2-500
>>
>>I want to show these recordes in a report as below :
>>
>>RecType:1 and Step:1
>>-----------
>>1-1-100
>>1-1-200
>>-----------
>>Sum : 300
>>
>>RecType:1 and step:2
>>-----------
>>1-2-400
>>-----------
>>Sum : 400
>>
>>RecType:2 and Step:1
>>-----------
>>2-1-300
>>-----------
>>Sum : 300
>>
>>RecType:2 and Step:2
>>-----------
>>2-2-500
>>-----------
>>Sum : 500
>>
>>
>>
>>I put RecType in DataGrouping, Group expression but i don't know how add Step to it.
>>Can i do this?
>>Thanks
>
>
>Hi Reza
>
>By preproccessing report cursor, you can create some fake composite field to group records more easy;
>
>1-1
>1-2
>2-1
>2-2
>
>values can be turned to fixed lenght character expressions like
>
>001001
>001002
>002001
>002001
>(see padl())
>
>Then grouping is easy. If you called this fake hierarchical field 'hkey'
>
>First level of grouping (group expression) can be
>left(hkey,3)
>Second level
>left(hkey,6)
>
>And so for as many level of grouping you need.
>
>
>HTH
>Sergio
Thanks
can you explain below section more?
First level of grouping (group expression) can be
left(hkey,3)
Second level
left(hkey,6)
I don't understand First and second level?