How to display a report by Department wise

Question

How to display a report by Department wise

Using Crystal Report 8.5

ID Name Department

001 raja IT
002 Vijay IT
003 Ram CSE
So on...

Display an Each Page by Department wise.

Once IT Department is completed then go to new page and display CSE Department, like that I need.

How to make in crystal report?

Answer 1

use sql group by department

Answer 2

Insert -> Group -> Department.

Once you have a group section, right click on it. It should show you checkboxes on right side which should have an option which could be "print on new page".

See if that helps.

Answer 3

Add group in the crystal report or use group by in the Sql query like that is is possible and set every group comes in the new page in th section expert->select group section and set new page after.

Answer 4

Like others have said. Create a group for the Department field. Go to the section expert for the group footer, enter this into the "New Page After" formula.

not onlastrecord

this will prevent the blank last page.