Combined Totals vs Individual Totals

[Guest]

I posed this question under subject heading deadlines and got most of the
information I was looking for however I think I need to clarify what I need
help with. I work for a call center and I run deparmental reports. One
particular report is called Total Questions Missed. Currently I have a
criteria in the form that this report references that reads =[Forms]![Quality
Intro]![Combo119]. This is good in it allows me to run reports for my
customer service reps individually, however now I need to get grand totals
for my reps in one report (by the way I was gettinig the grand totals before
I put that criteria in). Anway I was told to use redo the criteria to read
something like =[Forms]![Quality Intro]![Combo119] or =[Forms]![Quality
Intro]![Combo119]IsNull. By putting the IsNull it just displays all the
customer service records instead of one main return that displays the total
for everyone. Can somone assist me with this.

 

[Guest]

Hi Julius,
I can't say I completely understand what you want to do but I will try and
help if \i can!
It appears that you are using the combo value as the criteria for your
report - eg: if combo says Smith then the report is based only on Smith - now
what you want is for Null to be in the combo you want the report to print
everybody.
If this is the case try:
=Like[Forms]![Quality Info]![Combo119] & *
This reads - what is in combo 119 or everything!!!
Try it!!!
Frank

 

[Guest]

Frank thank you so much for your assistance. I believe I was being confusing
in what I was asking. Hopefuly I can simplify. I have 266 customer service
reps here, and when I want to look at how many calls were taken for the day,
there are no grand total they always come out individually example: John Doe
10 calls, Jane Doe 15 calls, Bobby Doe 25 calls. The [Combo119] is the combo
box I created and put on the report that references the query I put this in
the criteria field. By placing this in the criteria field of the query
Questions Missed by CSR, I no longer get grand totals, I get individual
totals. If my users does not select a rep name and leave that portion blank
on the drop down combo box making it Null, I want the return results to do a
grand total of all the calls taken for the day as opposed to individually. I
am so sorry I am long winded on this. Please advise.

Hi Julius,
I can't say I completely understand what you want to do but I will try and
help if \i can!
It appears that you are using the combo value as the criteria for your
report - eg: if combo says Smith then the report is based only on Smith - now
what you want is for Null to be in the combo you want the report to print
everybody.
If this is the case try:
=Like[Forms]![Quality Info]![Combo119] & *
This reads - what is in combo 119 or everything!!!
Try it!!!
Frank

I posed this question under subject heading deadlines and got most of the
information I was looking for however I think I need to clarify what I need
help with. I work for a call center and I run deparmental reports. One
particular report is called Total Questions Missed. Currently I have a
criteria in the form that this report references that reads =[Forms]![Quality
Intro]![Combo119]. This is good in it allows me to run reports for my
customer service reps individually, however now I need to get grand totals
for my reps in one report (by the way I was gettinig the grand totals before
I put that criteria in). Anway I was told to use redo the criteria to read
something like =[Forms]![Quality Intro]![Combo119] or =[Forms]![Quality
Intro]![Combo119]IsNull. By putting the IsNull it just displays all the
customer service records instead of one main return that displays the total
for everyone. Can somone assist me with this.

 

[Guest]

Hi Julius,
2 things to think about:
1) Do you want a listing of all CSR with individual numbers for the day and
then a grand total at the end of the report?
2) Do you want a report that says Grand total of calls for 14/06/2007 = xxx ?
and maybe be able to list the number of calls for a specified period say:
01/06/2007 to 14/06/2007...?
Let me know..
Frank

Frank thank you so much for your assistance. I believe I was being confusing
in what I was asking. Hopefuly I can simplify. I have 266 customer service
reps here, and when I want to look at how many calls were taken for the day,
there are no grand total they always come out individually example: John Doe
10 calls, Jane Doe 15 calls, Bobby Doe 25 calls. The [Combo119] is the combo
box I created and put on the report that references the query I put this in
the criteria field. By placing this in the criteria field of the query
Questions Missed by CSR, I no longer get grand totals, I get individual
totals. If my users does not select a rep name and leave that portion blank
on the drop down combo box making it Null, I want the return results to do a
grand total of all the calls taken for the day as opposed to individually. I
am so sorry I am long winded on this. Please advise.

Hi Julius,
I can't say I completely understand what you want to do but I will try and
help if \i can!
It appears that you are using the combo value as the criteria for your
report - eg: if combo says Smith then the report is based only on Smith - now
what you want is for Null to be in the combo you want the report to print
everybody.
If this is the case try:
=Like[Forms]![Quality Info]![Combo119] & *
This reads - what is in combo 119 or everything!!!
Try it!!!
Frank

I posed this question under subject heading deadlines and got most of the
information I was looking for however I think I need to clarify what I need
help with. I work for a call center and I run deparmental reports. One
particular report is called Total Questions Missed. Currently I have a
criteria in the form that this report references that reads =[Forms]![Quality
Intro]![Combo119]. This is good in it allows me to run reports for my
customer service reps individually, however now I need to get grand totals
for my reps in one report (by the way I was gettinig the grand totals before
I put that criteria in). Anway I was told to use redo the criteria to read
something like =[Forms]![Quality Intro]![Combo119] or =[Forms]![Quality
Intro]![Combo119]IsNull. By putting the IsNull it just displays all the
customer service records instead of one main return that displays the total
for everyone. Can somone assist me with this.

 

[Guest]

Thank you Frank for your assistance. I need number 2. I already have 1
setup.

Hi Julius,
2 things to think about:
1) Do you want a listing of all CSR with individual numbers for the day and
then a grand total at the end of the report?
2) Do you want a report that says Grand total of calls for 14/06/2007 = xxx ?
and maybe be able to list the number of calls for a specified period say:
01/06/2007 to 14/06/2007...?
Let me know..
Frank

Frank thank you so much for your assistance. I believe I was being confusing
in what I was asking. Hopefuly I can simplify. I have 266 customer service
reps here, and when I want to look at how many calls were taken for the day,
there are no grand total they always come out individually example: John Doe
10 calls, Jane Doe 15 calls, Bobby Doe 25 calls. The [Combo119] is the combo
box I created and put on the report that references the query I put this in
the criteria field. By placing this in the criteria field of the query
Questions Missed by CSR, I no longer get grand totals, I get individual
totals. If my users does not select a rep name and leave that portion blank
on the drop down combo box making it Null, I want the return results to do a
grand total of all the calls taken for the day as opposed to individually. I
am so sorry I am long winded on this. Please advise.

Hi Julius,
I can't say I completely understand what you want to do but I will try and
help if \i can!
It appears that you are using the combo value as the criteria for your
report - eg: if combo says Smith then the report is based only on Smith - now
what you want is for Null to be in the combo you want the report to print
everybody.
If this is the case try:
=Like[Forms]![Quality Info]![Combo119] & *
This reads - what is in combo 119 or everything!!!
Try it!!!
Frank

:

I posed this question under subject heading deadlines and got most of the
information I was looking for however I think I need to clarify what I need
help with. I work for a call center and I run deparmental reports. One
particular report is called Total Questions Missed. Currently I have a
criteria in the form that this report references that reads =[Forms]![Quality
Intro]![Combo119]. This is good in it allows me to run reports for my
customer service reps individually, however now I need to get grand totals
for my reps in one report (by the way I was gettinig the grand totals before
I put that criteria in). Anway I was told to use redo the criteria to read
something like =[Forms]![Quality Intro]![Combo119] or =[Forms]![Quality
Intro]![Combo119]IsNull. By putting the IsNull it just displays all the
customer service records instead of one main return that displays the total
for everyone. Can somone assist me with this.

 

[Guest]

Hi Julius,
You can do it in the report 1 by putting the =Sum(Individual Total) in the
report footer.
For report 2 - build a new query that is grouped on the date and then sum on
the calls - don't put in the CSR field and you will get the Date with the
total number of calls - build a new report and format it to suit.
You could put a parameter entry request in the date field that would let the
user enter 2 dates to give the information of that date spread.
In the criteria column of Date enter:
Between[Enter the start date for your report]and[Enter the end date]
I hope this helps,
Frank

Thank you Frank for your assistance. I need number 2. I already have 1
setup.

Hi Julius,
2 things to think about:
1) Do you want a listing of all CSR with individual numbers for the day and
then a grand total at the end of the report?
2) Do you want a report that says Grand total of calls for 14/06/2007 = xxx ?
and maybe be able to list the number of calls for a specified period say:
01/06/2007 to 14/06/2007...?
Let me know..
Frank

Frank thank you so much for your assistance. I believe I was being confusing
in what I was asking. Hopefuly I can simplify. I have 266 customer service
reps here, and when I want to look at how many calls were taken for the day,
there are no grand total they always come out individually example: John Doe
10 calls, Jane Doe 15 calls, Bobby Doe 25 calls. The [Combo119] is the combo
box I created and put on the report that references the query I put this in
the criteria field. By placing this in the criteria field of the query
Questions Missed by CSR, I no longer get grand totals, I get individual
totals. If my users does not select a rep name and leave that portion blank
on the drop down combo box making it Null, I want the return results to do a
grand total of all the calls taken for the day as opposed to individually. I
am so sorry I am long winded on this. Please advise.

:

Hi Julius,
I can't say I completely understand what you want to do but I will try and
help if \i can!
It appears that you are using the combo value as the criteria for your
report - eg: if combo says Smith then the report is based only on Smith - now
what you want is for Null to be in the combo you want the report to print
everybody.
If this is the case try:
=Like[Forms]![Quality Info]![Combo119] & *
This reads - what is in combo 119 or everything!!!
Try it!!!
Frank

:

I posed this question under subject heading deadlines and got most of the
information I was looking for however I think I need to clarify what I need
help with. I work for a call center and I run deparmental reports. One
particular report is called Total Questions Missed. Currently I have a
criteria in the form that this report references that reads =[Forms]![Quality
Intro]![Combo119]. This is good in it allows me to run reports for my
customer service reps individually, however now I need to get grand totals
for my reps in one report (by the way I was gettinig the grand totals before
I put that criteria in). Anway I was told to use redo the criteria to read
something like =[Forms]![Quality Intro]![Combo119] or =[Forms]![Quality
Intro]![Combo119]IsNull. By putting the IsNull it just displays all the
customer service records instead of one main return that displays the total
for everyone. Can somone assist me with this.