Days without date in line barchart or line diagram

[derHans]

I have a table which looks like this:

ident | date | quality

I have a stacked barchart which shows me the quality distribution per day. My Problem is, that days without data are not shown.

Is it possible to define a dynamic time range based on user input where the data is mapped on? So if the user defines the time from monday to friday and the database has only values for monday, that monday has a bar chart but the dates of the other days are also visible even if the query results in null.

Thank you for your help.

 

[fisheromacse]

will this do what you are needing?


Creating data for dates not in the data set with SQL Server SQL to create a Periods Table
faq767-4532

http://www.tek-tips.com/faqs.cfm?fid=4532

 

[hilfy]

The only way to do this is to link to some sort of date table that has all of the dates in it. If it's not in the data, Crystal won't show it.

We have a Business_Day_Calendar table that we use that has all of the dates in the year (and all years since we started doing this...) along with other information that we use to determine whether a specific date is a business day or not. When we want to show all dates regardles of whether there's data for the date we then do an outer-join from the date in the calendar table to the date in the data table. On the report we use the date from the calendar table instead of the date from the data table.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[chelseatech]

A numeric or date axis report will show missing values in a series or calendar.

If what you really want is to have the NULL dates convert to a future or past date create a formula of
If IsNull({table.datefield}) then date(2010,1,1)
else {table.datefield)

And use the formula in your chart instead of the field.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm