how to display

Tue, 13 Aug 2013 08:25:07 GMT

how to display count of employees in each department in the below table format

load * from employee;

load * from department;

whenver I clik on concerned department those details are to be displayed in ohter table

i.e. when i click i slaes all the 10 records are to be displyed as below

department	employee number	Emplyee type	salary	country	manager
sales	1	Regular	40k	IND	XXX
sales	2	Temp	50k	IND	YYYY
...	...	....			.....
sales	10	temp	60k	IND	ZZZZZ

Re: how to display

Tue, 13 Aug 2013 08:46:35 GMT

in script--

load *

from tablename;

load

department,

count([employee number]) resident tablename group by department;

****************************************

in expression--

Aggr(count([employee number]),department)