Skip to Content
avatar image
Former Member

table and date question

I have three tables and one ADD Command table that just pulls out date and result from another table in the database. All table are linked by date. When the report is run, the report stops on the last date with the last result. (ie the command table only has data in it until 10/29/2107 currently whereas the other table have data up till the end of the month) the report is only showing up to the 10/29 date and not displaying the rest of the days of the month just leaving the values empty for the add command linked table) Hope I explained this correctly.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 03, 2017 at 11:03 AM

    Change join to Command - make it a Left outer join

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks, but that made no difference. report still stops on the last data that was entered in the table for the command.

  • Nov 14, 2017 at 08:43 AM

    Which way is data link running

    Command should be on left and then joined to data with a left outer.

    Check your filters and grouping make sure they refer to Date in command other wise dates in data tables will override links

    Add comment
    10|10000 characters needed characters exceeded