Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Mar 2004
    Location
    Essex, England
    Posts
    93
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linking Sub report to Main Report (2000)

    I am trying to emulate the "Sales by Category" in the Northwind database.
    I want to create a Customers report and for each customer I want to include a graph showing Sales by month.
    The Customer Report links to the query and I have used the Grouping options to create a Customer Name section, wher i have placed the Customer name field.
    I then inserted a graph and linked it to the same query.
    If I link Child and Master fields to the "CustomerID" field, no data appears in the graph. If I leave the Child and mater Fields blank, graph data is returned for all customers. (ie the same graph is repeated under each customer heading).

    Caould anyone offer any pointers as to where I am going wrong.

    Thanks
    Robert

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Linking Sub report to Main Report (2000)

    Have you tried using the customer name field to link the graph to the report? See the attached (rather silly) example.

  3. #3
    Star Lounger
    Join Date
    Mar 2004
    Location
    Essex, England
    Posts
    93
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking Sub report to Main Report (2000)

    Thanks Hans. I'm afraid I'm still struggling a little but I will study your attachment and try to work out where I'm going wrong.

Posting Permissions

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