Skip to Content
avatar image
Former Member

Crystal Reports XI and access

I have an access database that is used for residential inspections. The main table is the situs information while a linked subtable is the inspection information. The subtable is linked via situs ID. My problem is that when trying to create a report that list each address and all inspection information associated with that address only one inspection will print. The inspection fields are v-ditch, slope, manuer, date, insp by, and letter sent. The record will only print in crystal if ALL feilds from the inspection table have data. There are many instances where there is only a letter sent so the v-ditch and slope feilds are left null. How can I get all inspections to print for each address.

Thanks

Derek

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 22, 2008 at 11:50 PM

    Hi Derek,

    In Crystal Reports, try going to Database|Database Expert. Select the Linking tab. If the two tables are only linked on one field, SitusID, I would suggest right-clicking on the link and change the linking to be Left Outer Join.

    You may need to test with other joins such as Right Outer if the first one doesn't meet your needs.

    Regards,

    Wallie

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      THANK YOU WALLIE!

      This problem is actually solved. The join from the situs to the inspections was not the problem, it was the join from the inspections to the various inspection options. Made them all left outer join and all is well.

      Thanks for the point in the right driection.

      Derek