Ole object(Excel) not appearing on the web

Posted by: sujatha095 on 4 August 2017, 2:43 pm EST

  • Posted 4 August 2017, 2:43 pm EST

    Hi,

     

    We developed our report using rpx files instead of dlls.  We now have a prototype running on the client-server version..  However, we are having problems running the report on the web.  We were wondering if you could give us some insight into this...

     

    The report uses OLE objects to display excel charts.  The chart is then populated onReportStart with the ado recordset.  This works perfectly on the client-server but the charts fail to populate on the web (all that displays is a blank chart).  I have attached screenshots to display this.

     

     

     

    We have also sent an email to support with the same issue.
    Please let us know if you have any ideas at all.  Thank you!


     

    Sujatha


    2005/09/OLE_Problem.zip
  • Replied 4 August 2017, 2:43 pm EST

    It appears that the data is not available to the process that is running this web application.  Call App.LogEvent to output a record count of your data before it is passed to these controls.

    Also, your client application uses our native viewer, whereas your web application is an exported PDF file.  Are you able to view all of your data in your client application after exporting to PDF?
  • Replied 4 August 2017, 2:43 pm EST

    Hi Peter,

    Thanks for the reply.  The data is available in the report, we are able to retrieve the data from the ole object and place outside the chart for viewing.  Only the chart is not being drawn.

    We spoke with our architect and our app developers and here is their conclusion:

     Listed below are the actual property settings that we are applying:

    Set pdfexpt = New ActiveReportsPDFExport.ARExportPDF

    pdfexpt.AcrobatVersion = DDACR40

    pdfexpt.JPGQuality = 100

    pdfexpt.SemiDelimitedNeverEmbedFonts = ""

    pdfexpt.ShowBookmarksInAcrobat = False

    I have stepped through the code and bypassed these settings to no avail. The report still does not appear to function properly.

    One thing to note here is that the actual mechanism for generating the report is different between the two applications. The client-server application is instantiating an ARViewer2 control and displaying the report via the control, whereas, the web application is generating the report dynamically as a PDFExport and sending it to the WebCache.dll. The WebCache.dll runs as a system service and processes all of the ActiveReports requests for the web application.

    In conclusion, we believe that the problem is with the PDF Export.  So, what can we do to get the chart working on the web?

    Thanks,
    Sujatha

  • Replied 4 August 2017, 2:43 pm EST

    Can your client-server app export to PDF using the same settings and the same export DLL version as your web app?
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels