Report Formatting (1 Viewer)

[modest]

I have created a report based on a query that returns the following fields (from 3 different tables)

[Employee ID] [Employee Name] [Supervisor] [Salary]


It displayed just like that, but now we are trying to find the sum of the supervisor's worker's salaries. So I want to group all the employees by their supervisors.

[Supervisor]
------------------------------------------
      [Employee ID] [Employee ID] [Salary]
------------------------------------------
                                   [Total]

I would like the Supervisor name to not repeat and for each supervisor to have their own page. I've done something like this before, but I forget how, please forgive me, my expertise is in the VBA.

 

[modest]

Okay I have the grouping done by right-clicking and selecting "Sorting and Grouping", but as far as breaking after each group, anyone have any ideas?

 

[selenau837]

I have created a report based on a query that returns the following fields (from 3 different tables)

[Employee ID] [Employee Name] [Supervisor] [Salary]


It displayed just like that, but now we are trying to find the sum of the supervisor's worker's salaries. So I want to group all the employees by their supervisors.

[Supervisor]
------------------------------------------
      [Employee ID] [Employee ID] [Salary]
------------------------------------------
                                   [Total]

I would like the Supervisor name to not repeat and for each supervisor to have their own page. I've done something like this before, but I forget how, please forgive me, my expertise is in the VBA.

That would be set up in the group of the report. Need to set the Supervisor at the top most grouping on your report.

 

[modest]

Nevermind, I have it, just put a line-break in the footer.

 

[modest]

Thanks Selena, it seems I knew how to do it, I just rushed too quickly to ask everyone else. I thought it was a little bit harder than what it was for instance, I thought I would to create a sub-report based on the main report's detail. Anyhow, sorry for wasting your time.