g/laccount no field in g/l entry table must be flow field

ahmedba

Hi guys i have proplem in report i make report consist from three data item
g/laccount
g/lentry
g/l entry2
like above i put two text boxes in FromNo,ToNo in Request form to filter document no
Meaning as example i will write from document no 2 to 122 but i face proplem third data item g/lentry2
i want to group g/laccount no and credit amount i dont know how to make grouping in third data item by g/laccount no .
how i make setrange in third data item to accept range of document no between these two numberes.
can any one help me
thanks

ahmedba

To show you what i need is ex :

in request form

From No 130 (documentNo)

To No 134 (Document No)

Report what i need like this :

Date DocNo No Name CreditAmount

12/12/12 130 130101 cash in hand 10000

13/12/12 131 130101 cash in hand 50000

14/12/12 132 130102 tradeRecivable 20000

14/12/12 133 130102 tradeRecivable 1000

15/12/12 134 130103 pettycash 3000

Total 84000

group no Total

130101 60000

130102 21000

130103 3000

this is report what i need .

Can you told me how..the proplem in this report how i make grouping inlast of report as following :

group no Total

130101 60000

130102 21000

130103 3000

this third data item are i make g/l entry or g/l account and how i make grouping .

any one told me how