Very Strange Issue With Days of the Week

[Proauntpatty]

All,

I am using Crystal to report on Nortel's Contact Center Manager. When I run reports to look at the whole week (7x24) I get Monday through Saturday listed on the report with their totals for those days. However, Sunday does NOT show up, but the data is included in the Report total.

For example:
Day of week Number of Calls
Monday 10
Tuesday 10
Wednesday 10
Thursday 10
Friday 10
Saturday 10
Report Total 70

Does anyone have any suggestions? Obviously a 7x24 opertion want to know what is going on in their organization.

A little more detail:
The Details section is suppressed.
GF1 is the total for the day of the week
The Report Footer Summarizes ALL data for that time period.


I appreciate everyone's help.
Patty

 

[Madawc]

First, are you grouping by days? Or are these detail records.

Second, have you got some sort of section suppression? Is this a report you wrote or something you've been asked to maintain.

Check Report > Selection Formula > Group, that also could be a cause.

Also what software? If this is Crystal Reports rather than Crystal Enterprise, it should be in one of those threads. And it helps to give the version number.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[Proauntpatty]

I figured it out. The first thing I looked at was suppression and I didn't see anything. There was a formula to suppress Sunday for the Group. I deleted the formula and now I see the data for Sunday.

Thanks for your reply.
Patty