Grouping level and calculation

[Mary]

I have a report grouped by Month and Employee. The report lists the
RequestIDs that were assigned to each employee. Some RequestIDs were
assigned to more than one Employee. I'd like to see a summary at the end of
the report that totals the number of Requests for the Month as well as the
number assigned to Employees. I know the correct totals right now are 43
requests assigned to 60 employees. When I get the correct total to display,
I lose the grouping format. It should be by Employee for the month. When I
add a footer to calculate the number of requests, the employee data is no
longer grouped together. I'm sure it's something simple that I'm just not
seeing, maybe some fresh eyes can steer me in the right direction?

 

[Barb]

Hi Mary
It looks like you need a subreport. Just design a simple small report with
these additional calculations and insert it into your report footer.

Barb

 

[Mary]

I now have a subreport with the correct figure. I'd like to see that figure
in a string and now I'm having trouble referring to the subreport.

My string is the Control Source in a Textbox in the Month Footer section.

=Count([Date]) & " NMC Representatives were assigned to " &
Reports![NMC_Assigned].[CountOfCRs].[TotalCRs] & " PNMP/ENMP Activities for "
& [Month] & "."

Subreport Name: CountOfCRs
Subreport Control Name: CountOfCRs
Control on Subreport I need to reference: TotalCRs
Main Report: NMC_Assigned

Thanks,
Mary

 

[Barb]

Hi Mary
Try Expresion builder to direct it to the subreport. Looks like "..." in the
properties - control source.

Barb

I now have a subreport with the correct figure. I'd like to see that figure
in a string and now I'm having trouble referring to the subreport.

My string is the Control Source in a Textbox in the Month Footer section.

=Count([Date]) & " NMC Representatives were assigned to " &
Reports![NMC_Assigned].[CountOfCRs].[TotalCRs] & " PNMP/ENMP Activities for "
& [Month] & "."

Subreport Name: CountOfCRs
Subreport Control Name: CountOfCRs
Control on Subreport I need to reference: TotalCRs
Main Report: NMC_Assigned

Thanks,
Mary

Hi Mary
It looks like you need a subreport. Just design a simple small report with
these additional calculations and insert it into your report footer.

Barb

 

[Mary]

Barb, I tried using the expression builder, it gave me:
[Reports]![CountOfCRs]![TotalCRs]. When I put that in my string, it doesn't
work. I want the figure to inserted into my string. Any other thoughts on
how to get it there? Thanks, Mary

Hi Mary
Try Expresion builder to direct it to the subreport. Looks like "..." in the
properties - control source.

Barb

I now have a subreport with the correct figure. I'd like to see that figure
in a string and now I'm having trouble referring to the subreport.

My string is the Control Source in a Textbox in the Month Footer section.

=Count([Date]) & " NMC Representatives were assigned to " &
Reports![NMC_Assigned].[CountOfCRs].[TotalCRs] & " PNMP/ENMP Activities for "
& [Month] & "."

Subreport Name: CountOfCRs
Subreport Control Name: CountOfCRs
Control on Subreport I need to reference: TotalCRs
Main Report: NMC_Assigned

Thanks,
Mary

Hi Mary
It looks like you need a subreport. Just design a simple small report with
these additional calculations and insert it into your report footer.

Barb

:

I have a report grouped by Month and Employee. The report lists the
RequestIDs that were assigned to each employee. Some RequestIDs were
assigned to more than one Employee. I'd like to see a summary at the end of
the report that totals the number of Requests for the Month as well as the
number assigned to Employees. I know the correct totals right now are 43
requests assigned to 60 employees. When I get the correct total to display,
I lose the grouping format. It should be by Employee for the month. When I
add a footer to calculate the number of requests, the employee data is no
longer grouped together. I'm sure it's something simple that I'm just not
seeing, maybe some fresh eyes can steer me in the right direction?