Results 1 to 3 of 3

Thread: Multiple tables linked with subreporting

  1. Aug 30th, 2007, 07:32 PM #1
    CloudDust
    CloudDust is offline

    Thread Starter
    Member
    Join Date
    Apr 2006
    Posts
    45

    Resolved Multiple tables linked with subreporting

    hi,

    i have 3 tables:

    Tables
    ProductInfo
    - ProductCode - PK
    - ProductName

    InventoryDeposit
    - TraceNumber - PK
    - Date

    InventoryDeposititems
    - TraceNumber -FK
    - ProductCode - FK
    - Quantity

    The Report should display:
    the Subreport items is the one underlined
    ProductCode ProductName TraceNumber Date Quantity

    i was able to display results for everything except the "InventoryDeposit.Date"

    How am i going to make it display with these relationship??
    Last edited by CloudDust; Sep 11th, 2007 at 03:54 AM.
    Reply With Quote Reply With Quote
  2. Sep 6th, 2007, 03:17 PM #2
    Mark Gambo
    Mark Gambo is offline
    Giants World Champs!!!! Mark Gambo's Avatar
    Join Date
    Sep 2003
    Location
    Colorado
    Posts
    2,965

    Re: Multiple tables linked with subreporting

    Can you attach the report and datasource?
    Regards,

    Mark

    Please remember to rate posts! Rate any post you find helpful. Use the link to the left - "Rate this Post". Please use [highlight='vb'] your code goes in here [/highlight] tags when posting code. When a question you asked has been resolved, please go to the top of the original post and click "Thread Tools" then select "Mark Thread Resolved."

    Reply With Quote Reply With Quote
  3. Sep 11th, 2007, 03:53 AM #3
    CloudDust
    CloudDust is offline

    Thread Starter
    Member
    Join Date
    Apr 2006
    Posts
    45

    Resolved Re: Multiple tables linked with subreporting

    i'm using mysql as ny datasource.
    anyway, thanks. i got it running.
    i joined the table via sql queries.
    then made use of subreports
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width