Hi,
I'm new to Web Focus & I have a requirement where in I have to show the result in the following way.

Here Columns Names are :
Department :- MIS, Production
First_Name :-
Last Name :-
Job Desc :-
Sal :-

and the table is as follows.

Here I have to group with respect to "DEPARTMENT" & I have to retrieve the count of "JOB_DESC" ( Number of Managers, Asst.Mgrs etc )in the Subtotal or in SubHeading.

Department First_Name Last_Name Job_Desc Sal
-----------------------------------------------
MIS as asd Manager 10000
rew ree Manager 25001
buyv joh Asst.Manager 10
tfcy yfy Secratery 5000
-----------------------------------------------
Name Of Dept: MIS Count Of Mgr :2
Count Of Secratery : 1 Count Of Asst.Mgr :1
------------------------------------------------
Production ws ad Manager 10000
mw rae Asst.Manager 25001
ads joh Asst.Manager 10
tfcy yfy Secratery 5000
-----------------------------------------------
Name Of Dept: Production Count Of Mgr :1
Count Of Secratery : 1 Count Of Asst.Mgr :2
------------------------------------------------


Can anybody guide me how to achieve the above result.

Thanks in advance.

This message has been edited. Last edited by: Moju,

Moju, Prash

You both ask the same question. What is that for, doing a webfocus competition and see who is the quickest to solf this.....

Did you have tried this your self?