Grouping in NAV 2009 Reports

sakameeran

Dear All,

This is for a new report in navision and we need to set a group in this report just like creating a group in crystal report. For better understanding I'll just brief my requirement.
For a Country A there will be 4 branches in it say 1,2,3,4 and aslo country B which has two branches 5 and 6 ,and wat the requirement is like first we need to group it with country and inside it the branches group has to be made like
Country A

---

1

---

2

---

3

---

4
Country B

---

5

---

6
We tried it by adding the group through F3 but it is not showing. If we want to specify the field by which the group has to be made how we can do that. Like the below sql query works,
Example:
select [Location Code], Sum([Sales Amount (Actual)]) from [CRONUS LS 2009 (6_0) W1 Demo$Value Entry]
where [Posting Date] = '2006-01-16'
group by [Location Code]

vijay_g

First of all.
are you Nav User or developer?
whether your requirment looking with basic concept so you need to read how's Grouping works in Dynamics Nav.
So would be better,first read C/AL Porgamming help.

kriki

[Topic moved from 'NAV Three Tier' forum to 'NAV/Navision Classic Client' forum]