Home » Developer & Programmer » Reports & Discoverer » Working with graph using three parameter
Working with graph using three parameter [message #210053] Tue, 19 December 2006 02:48 Go to next message
ambreen
Messages: 9
Registered: October 2006
Location: Pakistan
Junior Member

select count(empid) ,VCHARDEPT_NAME,VCHARDESIgNAME from department d,
department_section ds,designation de ,assignments a where de.desig_id=a.desig_id and
d.department_id_pk=ds.department_id_pk and ds.dept_sec_id=a.dept_sec_id
group by vchardept_name,vchardesigname

The above query will display total no of employees with there designation and department
But this graph is very complicated
please describe the formating so that its look good
Re: Working with graph using three parameter [message #210059 is a reply to message #210053] Tue, 19 December 2006 03:01 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
send me table structure and some data i will try it here ...

bye
ashu
Re: Working with graph using three parameter [message #210903 is a reply to message #210053] Sat, 23 December 2006 01:40 Go to previous message
ambreen
Messages: 9
Registered: October 2006
Location: Pakistan
Junior Member

the detail for all tabel the given below

department table contains vchardept_name and department_id_pk
department_section contains dept_sec_id , department_id_pk ,SECTION_ID_PK
designation contains DESIG_ID ,VCHARDESIGNAME
Assignments contains ASSIGNMENT_ID_PK,DESIG_ID,DEPT_SEC_ID

the query is
select count(empid) ,VCHARDEPT_NAME,VCHARDESIgNAME from department d,
department_section ds,designation de ,assignments a where de.desig_id=a.desig_id and
d.department_id_pk=ds.department_id_pk and ds.dept_sec_id=a.dept_sec_id
group by vchardept_name,vchardesigname
Previous Topic: Error Running Report
Next Topic: difference between Character mode report and Bitmap report
Goto Forum:
  


Current Time: Tue Dec 03 15:14:07 CST 2024