Show Zero Values In A Cross Tab

[mabis]

Crystal V10

My crosstab summarizes phone calls made by customer service people. It counts the number of phone calls made by employees and breaks down the rows by date completed
{history.completedate} and calls during each half-hour block during the day {@halfhour}.

The rows are by user {history.username} and the result of the call such as “left voicemail”, “call completed.” {history.result}. The summarized field is solely history.result.

My Problem: I want to view inactivity as well as activity. I need to show 0 values during the periods where sum of history.result is null. I have been unsuccessful in finding any solutions. Many have said it can not be done in Crystal. Some have mentioned ‘inner joins’ but I am unfamiliar with working with joins.

Any help is greatly appreciated.

 

[synapsevampire]

There are a variety of ways that people address this sort of thing, the best method is to work it out on the database side, but you didn't post the database being used.

And referencing things like {@halfhour} doesn't help us, we don't know what's in that formula, right? So post it.

If you don't have a way to provide all of the 1/2 hour increments (and is this for 24 hours, meaning 48 periods?) then you'll probably have to manually generate formulas for the 48 periods.

Crystal only produces results based on the data supplied.

Try posting example data and what the expected output willneed to look like.

-k

 

[kenhamady]

I have a summary of several methods in the following Article, but only some can be used in cross-tabs and charts.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides for Formulas, Parameters, Subreports, VB, .NET, Tips and Tricks

http://www.kenhamady.com/