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.

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?

Hi Frank,

It is not for competation sir, I was using the same user id. Actually I did try to work around.
When you use SubHeading, u can only group by Columnwise. Either by Department or by JOB_DESC. I want count of Employees(Count of Managers, Asst. Mgr,Developers etc) who belong to Department.

Please check the following code & guide me.

ON EMPLOYEE.EMPINFO.DEPARTMENT SUBTOTAL AS '*Count Of Managers : Count of Asst.Managers:WHEN EMPLOYEE.JOBSEG.JOB_DESC EQ 'MANAGER';


ON EMPLOYEE.EMPINFO.DEPARTMENT SUBFOOT
"Count Of Manager : WHEN EMPLOYEE.JOBSEG.JOB_DESC EQ 'MANAGER';

Thanks in Advance

WebFOCUS 7.1
Windows
Output: HTML, Excel & PDF

Prash,

Have you had any basic training? If not then I would sincerely suggest that should be your first step. Once you have had that then you will understand so much more of what you are trying to do.

T