Results 1 to 2 of 2
  1. #1
    Guntar is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2012
    Posts
    1

    Chart is not showing up on the report.

    Hello, i created this VBA script that attaches access report to the email as pdf file.


    In this report i have two queries: one query pulls the report information, the second query is for the chart, that summarizes the report.

    When i open this report in access it work fine, i can see all the information.
    When this report get attached to the email, the chart doesn't get generated.
    Here is the VBA:


    1. First i am generating/saving this report on location on my C-drive.

    DoCmd.OutputTo acOutputReport, "rpt_skills_training_this_year", acFormatPDF, strFilePath, False

    2. I am attaching this report to email and emailing.

    emaiSent = Email_Via_Outlook(strEmails, message![email_subject], message![email_message], False, strFilePath, strSignIn)

    Ofcourse there is more code around this function, but these are the two lines that deal with pdf report file.

    Any suggestion/solutions, why don't I see the chart on the report that is attached to the email. But I do get all the information when i am opening this report inside of Access?


    Thank you in advance.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    The saved PDF does not show graph?

    You open the report in PrintPreview before OutputTo?

    Don't specify the report name and the output will use the open report. Works in my code, graphs and all.

    DoCmd.OutputTo acOutputReport, "", acFormatPDF, strPath & rs!LabNum & ".pdf", False
    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.

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

Similar Threads

  1. some problem in showing chart legend
    By afshin in forum Queries
    Replies: 5
    Last Post: 09-16-2012, 10:03 AM
  2. Adding chart to a form showing inventory value
    By mayapredco in forum Forms
    Replies: 1
    Last Post: 04-21-2012, 08:37 PM
  3. Scatter Chart not Showing X-axis Values
    By ward0749 in forum Forms
    Replies: 4
    Last Post: 03-20-2012, 06:37 AM
  4. line chart not showing lines
    By ajetrumpet in forum Reports
    Replies: 0
    Last Post: 09-11-2010, 05:55 PM
  5. Design view not showing data (Pivot Chart)
    By thestappa in forum Reports
    Replies: 0
    Last Post: 06-24-2010, 09:59 AM

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