Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009

    Unanswered: Linking Subreports with Null Date Fields

    I am working on a report which requires me to group my data by date. It's using a subreport to pull data from an order table and link it to data from a shipped table. I need to link the reports using the dates so they group correctly to get a daily pulse of orders and shipments. However, some days seem to have no shipments but do have orders. The orders do not show up because the date does not exist in the shipment table. Any ideas on a work around?

  2. #2
    Join Date
    Dec 2004
    I'm not sure I understand what you're looking for.

    Do you want a listing for every date with a subreport for orders received that date and another subreport for shipments that went out on that same date?

    Or do you want to relate shipments to orders in some way?

Posting Permissions

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