Include Null Values

[olushow]

I have a report that lists tickets created daily by a certain Help desk group.(The report has date prompts)

The report works fine, but the way it works now it will not list days where no tickets were created as part of my report, meaning null value.

How can I include dates in which no tickets were created.
So it will display as follows:

02/08/11 - 10
02/09/11 - 0
02/10/11 - 12

 

[Madawc]

Are you able to get tables / datasets added to the database? If you got a table of DATE set up, this could be linked to the activity using LEFT OUTER and you'd still get a slot when there was no activity. (But note that any selection on the second table must do an IsNull test first, otherwise you'll not get the dates with no records, null value for the second record.)

It is also possible to use an Excel spreadsheet as an extra Crystal source.

If neither of those methods can be used, create a 'Mock Crosstab'. Crosstabs are fine if you don't mind the absence of rows or columns with no data, but you said you wanted empty slots to show.

A 'Mock Crosstab' is something that looks like a Crosstab, but in fact you define each column yourself, normally as a running total. This would need to go in the report footer, because running totals count as the reports 'run' and they will not be complete until then. Crystal should have included an example along with the Crosstabs.

You can save a little time by doing a paste to a dummy report, changing the name and then pasting back. In Crystal 11.5, you can also duplicate formula fields using the Field Explorer.


Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[olushow]

Can't add any datasets/tables to the database

I am actually using a Line Chart (Customer's request) that displays the number of tickets opened within a week period (Date Range).

But the client wants dates wants to tickets where no tickets were submitted, as well as those where tickets were submitted, on the report.

I need it to show up in the line chart.

Basically if there is a zero count, it has to be included in the report. - Per Customer's request.

 

[olushow]

I am using date prompts. For example when I enter in the following date prompts:

01/02/11 - 01/08/11

It so happens that there were no records created on 01/02/11, and so it gives me data from 01/03 - 01/08. What I want is for 01/02/11 to show in my chart and totals, with a count of 0.
I currently have the Line Chart setup as follows;

On Change of Table.Date
and show value(s) Table.ticket numbers.

What should I do from this point?

I also have formula that I used to identify each day, and created a group on the formula so that each group name shows as follows

01/11/01

01/12/01

I am thinking I should create a formula

 

[Madawc]

Crystal has a 'flow', a fixed cycle that you have to slot your own code into. It isn't a full programing language: that's the price you pay for a software tool that can be used to produced a nice-looking report very quickly.

I've already told you the solution. Try it.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP