Results 1 to 5 of 5
  1. #1
    beribimba is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    Aug 2011
    Posts
    12

    Chart in Report Only Works When Detail Section is Closed

    I have attached a test database illustrating the issue I'm having.

    I created a chart that changes with the field "unit." It works fine. Now I want to add other fields describing each unit to the detail section. When I open up the detail section (even before putting any fields in it), the chart stops working (goes blank). I don't understand what the problem is. It seems like it might be a simple fix, but I can't see it.

    Thanks!
    Attached Files Attached Files

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Open the report in Layout view, save, now open in Design view. Different? It worked for me. That is one of those 'undocumented' quirks just happen to figure out. Save a report from Layout view and your graph settings should then display in Design view. I know, bizarre.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    beribimba is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    Aug 2011
    Posts
    12
    I think you're referencing not being able to see the chart as it will appear when printed in design view. Thanks for that explanation; I was wondering about that, too.

    My issue, though, is that if you view the report, the chart displays the actual data. Then if you go back to "design view" and expand the "detail" section, then go back to "report view," the interior of the chart is suddenly blank.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Yes, see that now.

    I think the issue is the Master/Child links. Unit field is not included in the graph's RowSource so there is no field to link on.
    Remove the links, name the Unit textbox to tbxUnit, and change the Row Source to: SELECT [JG],[A],[B] FROM [TestData] WHERE Unit = tbxUnit;
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    beribimba is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    Aug 2011
    Posts
    12
    Perfect! Thank you for your help!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Columns in Report Detail Section only
    By gg80 in forum Reports
    Replies: 10
    Last Post: 08-03-2014, 07:41 PM
  2. Count in detail section of a report
    By ccordner in forum Reports
    Replies: 9
    Last Post: 02-08-2012, 06:55 AM
  3. The length of detail section of a report
    By blueraincoat in forum Reports
    Replies: 2
    Last Post: 04-06-2011, 12:24 AM
  4. Replies: 0
    Last Post: 03-28-2011, 05:06 PM
  5. Replies: 1
    Last Post: 10-11-2009, 08:31 PM

Tags for this 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
  •  
Other Forums: Microsoft Office Forums