Report shows empty if one of the tables is empty RRS feed

  • Question

  • Hello,

    I have a report from several tables (in a DataSet). If one of the tables has no rows, the entire report shows up empty. How can I still display the information from the other tables?

    Tuesday, December 29, 2009 9:46 AM

All replies

  • You do know the difference between inner and outer JOIN, right?

    If that's not the problem, I'm not sure I understand the question.
    Wednesday, December 30, 2009 10:06 PM
  • Hello,

    I know what JOIN is. Let me explain a little: I use that report for printing an invoice. Sometimes I have some company data attached to the invoice, sometimes I have only a person. When there is no company, the report shows up completely empty, even if the other tables have data.

    Thursday, December 31, 2009 9:54 AM