views:

154

answers:

0

I have a simple report in SSRS 2008 that lists employee name and their department.

table emps
(
 PersonFullName VARCHAR2(64 Byte)
 Dept           INT(4 Byte)
 ShiftStartDTM  DATE
)

I made very simple report to display this data ordered by shift start time. However now I need to make a another version of the report for departmental managers that groups by department (Dept) and add a page break after each page. In crystal I could do this in 5 minutes, however in SSRS 2008 it's giving me fits.

These are very NOOB questions for SSRS, but i'm unable to get a trivial report to work.

1) When i go to 'Group Properties' and add a group on Dept. I only get some of the records returned. 103 records in dataset and only 12 returned when i group like this! Any ideas why this would be occurring?

2) I don't see a way to insert a page break after a group. Appears to require 'Between each instance of a group' to set 'Also at the end of the group'. I only want a page break after each group. I must be missing something simple here.

Thanks