×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Days without date in line barchart or line diagram

Days without date in line barchart or line diagram

Days without date in line barchart or line diagram

(OP)
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.

RE: Days without date in line barchart or line diagram

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.

RE: Days without date in line barchart or line diagram

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
www.chelseatech.co.nz/pubs.htm

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close