Grouping Problem

[bionicman]

Ok, this problem stems back a couple of months. You can look here to see where i was coming from.

Anyway, i could not figure it out at the time, so i shelved it and decided to come back to it now, but i still can't figure it out. After a lot of help from pdx_man (Thank you again!) I got a really nice report that seperates my information by week in the month. this works great, all i have to do is select the employee from a combo box.

What i would like to do is be able to just enter the call center name and still have it display the same way, but pull up all information for that call center. (so each employee would still have their own page with their information seperated by week)

I have attached a sample so you can see the report, and possibly be able to help me.

Thank you in advance,
Dennis

 

[GumbyD]

I took a look at your database and report and updated to what I think you want. Please take a look at the new report that I added. I made quite a few changes so you will have to look it over. Post back if you have any questions.

GumbyD

 

[bionicman]

Works GREAT!! Just what i needed...

THANK YOU SO MUCH!!

 

[bionicman]

GumbyD,
Do you know of a way that i could have this report display zero's if there is no information for that week.

example:
week 12/1 total: 3
week 12/8 total: 1
week 12/15 total: 0
week 12/29 total: 4

I have tried using IIF(isnull), but to no avail.

Thanks in advance!

 

[GumbyD]

There is not a really simple way to do that from where you are. I will look at it some more. It may take a few days so if someone else has a great simple way to do this- Speak Up Now! I will take a peek and see what I can come up with.

GumbyD

 

[bionicman]

just checking to see if you or anyone else has come up with something yet?

If this is not possible very easily, would it be easier to come up with a report where it would just list who had no errors?
i assume i would need to make a query that stores the totals by person (is that possible?) and then set the value to zero.

Thanks!

 

[GumbyD]

Sorry - I posted this to the wrong thread!

After looking at and working with your issue some more - there is one method I think would work, but it will be slow and ugly. Since you know it will always be 1 month of information and you have a start date. You could build subreports pulling data with criteria for each week - the criteria would have to be filled from the value on the main report. Then on the on open of the subreport you could use on no data to hide the subreport if it did not contain data and make visible a line of zeros or some text stating there were no errors during the week.

I have been trying to think of other options but so far no luck. I hope that gets you started. If you have any questions let me know.

GumbyD

 

[bionicman]

heh... you are right, seems quite ugly!
gives me something to mess with though!

Thanks for all the help!