Intervals not showing because there is no data

[dannab]

Im using crystal 8.5 connecting via ODBC to a symposium database (I do not have permissions to add/change symposium tables).

I have created a DNIS report, grouped on timestamp & time, to show calls ans, calls abandoned etc.

My problem is only intervals with data in them appear on the report and I need all of them to show.

I have read on other forums (most of which I dont understand) to try the following:
1. add a table and use a left join (I dont think I can do this bcos I dont have permissions to add tables to symposium)
2. create a running total formula and include all of the intervals (I cant figure out how to do this! and get it to work for all intervals)

Please help! This is what my report looks like now:
Time callsans callsaband
12:30 6 4
06:30 1 7
06:45 2 0

I need it look like this:
00:00 0 0
00:15 0 0
00:30 0 0
00:45 0 0
12:00 0 0
12:15 0 0
12:30 6 4
and so on for each 15 min interval.



dannab

 

[adhhealth]

are you sure these fields are not "suppressed if zero"?

 

[lbass]

For each cell of this manual crosstab you would either have to create a formula like:

//{@00:00to00:15callsans}:
if {table.time} in time(0,0,0) to time(0,15,0) and
{table.callstatus} = "Answered" then 1 else 0

You would then right click on this formula and insert a summary (SUM, not count) at the group level (if you are grouping on date) or a grand total, if the summary is for the report level.

Or you could create running totals using the running total expert, where you choose {table.callID}, distinctcount, evaluate based on a formula:

{table.time} in time(0,0,0) to time(0,15,0) and
{table.callstatus} = "Answered"

Reset on change of group (if you are grouping by date, e.g.) or never, if you want the result at the report level.

With either approach you would have to arrange the summaries in the footer (group or report), and add text boxes with labels. It's a lot of work, since you will need two formulas or running totals for each 15-minute interval.

-LB