Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2012
    Posts
    2

    Lightbulb Unanswered: Display all days even with no data

    I my question its simple for sure but this is my first report

    I already have a report that display employee results
    by NrEmployee and between Dates

    TableInfo
    -Id
    -Date
    -NrEmployee
    -...
    -...

    Now i whant to show all days between dates even they have no information to the selected NrEmployee

    To have the dates i create a table with all dates from 2000 to 2020
    and make the relation in crystal TableInfo.Date = AllDatesTable.Date

    AllDatesTable
    -Date

    Now what is the best way to display all dates even when TableInfo.NrEmployee does not exists

    I try with outer join etc option in crystal but with no sucess

    Thanks.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    fake it, create a table with numbers(1..31) or dates and join to your other data.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Apr 2012
    Posts
    2
    I already create a table with the dates
    but the parameter field NrEmployee don't let show the dates from the auxiliary table.

    Sorry, but this is my first contact with CR

  4. #4
    Join Date
    Mar 2012
    Posts
    12
    Quote Originally Posted by vidaul View Post
    I already create a table with the dates
    but the parameter field NrEmployee don't let show the dates from the auxiliary table.

    Sorry, but this is my first contact with CR
    Did you ever figure out the answer to your question? If yes, what was the answer?

    If no, here is how I would approach it.
    - create a Crystal Report on just one table, DATES.
    - specify a date range, say Jan1 - Feb 15, 2011.
    - see if you can print one row for each day in the date range

    When that is successful, try adding another table for the Employees.

    Good luck!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •