Home » Developer & Programmer » Reports & Discoverer » Group by and summary  () 1 Vote
Group by and summary [message #224588] Wed, 14 March 2007 13:24 Go to next message
Messages: 40
Registered: February 2007

I have report like this.. I have to select sum of employee salary based on department.

I did group by department in reportbuilder and my summary colums are in the data model.

It is coming by department wise but sum of salaries of all departments.

where should be my summary columns in the data model.
Re: Group by and summary [message #224627 is a reply to message #224588] Wed, 14 March 2007 15:58 Go to previous message
Messages: 20850
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Create a summary column which will have salary as a source and will break on report. It should not be a part of any existing group. Place it into a top-parent frame (actually, I'd let Report Wizard to do that. It could save you some time and nerves if you aren't experienced in drawing items in the Paper Layout).
Previous Topic: Problem during Discoverer report exporting to another database
Next Topic: XML publisher 6.5.2 MS word template builder fails
Goto Forum:

Current Time: Sat Oct 22 18:39:33 CDT 2016

Total time taken to generate the page: 0.04065 seconds