January 02, 2008, 08:12 AM
PrashWant to have following output in my report.
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.
January 02, 2008, 09:41 AM
FrankDutchMoju, 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?
January 02, 2008, 11:47 PM
PrashHi 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
January 04, 2008, 09:34 AM
Tony APrash,
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