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