Problem with Excel Export

Posted by: mecano on 4 August 2017, 3:09 pm EST

  • Posted 4 August 2017, 3:09 pm EST

    Hi,



    we use ActiveReports in our company and the problem is, that on some PC's the Excel export doesn't work. The following error occurs (I must translate from german ;-)



    Script-Error:

    In the script on this page an error occured.

    Line: 40

    Character: 2

    Error: The object does not support this property or method



    Things I've done yet to solve the Problem:

    - Checked the versions between the PC's working and not working.

    - Checked the IE-Versions

    - Re-registered the dll

    - Copied the dll from a working PC





    Any ideas?



    With kind regards



    In the File attachment you'll find a hardcopy of the error (in german)



    Andreas Weber
    2008/03/Error Excel Export.JPG
  • Replied 4 August 2017, 3:09 pm EST

    Hello ,


    It looks like the excel export dll is not registered properly.


    Could you please describe the system/hardware enviroment of PC?


    What is the build number of excel export dll?


    What does code line throw exception? 


    Thanks,


    Sergey Romanov.

  • Replied 4 August 2017, 3:09 pm EST

    I updated to the latest version of Active Reports, but still the same error.



    We all use Excel 2003 SP3



    Greetings

    Andreas Weber
  • Replied 4 August 2017, 3:09 pm EST

    Please, try to install the latest version of Active Reports 2.0 (or just exclexpt file) on this machine.


    http://www.datadynamics.com/forums/37/ShowForum.aspx


    Also, Do you use  a same version of MS Excel on all machines?


    Thanks,


    Sergey Romanov.

  • Replied 4 August 2017, 3:09 pm EST

    The PC is a DELL Optiplex 755, Intel Core 2 duo processor, 2GB RAM with Win XP professional SP2, latest patches.

    The version of exclexpt.dll is 2.0.0.1253

    But this is the same version as on computers where everything works.



    Thank you for your help!



    Andreas Weber
  • Replied 4 August 2017, 3:09 pm EST

    Could you please send me or attach in forum the report.asp file packed in ZIP archive?


    Thanks,


    Sergey Romanov.

  • Replied 4 August 2017, 3:09 pm EST

    Hi, thanks for your help!



    In the attachment you find the report.asp
  • Replied 4 August 2017, 3:09 pm EST

    It looks like, the attachment was blocked.


    Could you please attach it in zip file archive?


    Thanks,


    Sergey Romanov.

  • Replied 4 August 2017, 3:09 pm EST

    Done!



    A screenshot of the result messagebox is in the attachement.



    Greetings

    Andreas Weber
    2008/04/Result VBS.JPG
  • Replied 4 August 2017, 3:09 pm EST

    Thanks, it is a correct result :)


    Possibly, the problem does not relate to the export dll, we need to check the common dialog as well.


    Try to remove the using of "show save" dialog and set the constant file name for tests.


    Thanks,


    Sergey Romanov.

  • Replied 4 August 2017, 3:09 pm EST

    Hello ,


    Your asp file creates an instance of Excel export filter on the client machine.


    It requires the installed excel export dll on the client machine.


    Thanks,


    Sergey Romanov.

  • Replied 4 August 2017, 3:09 pm EST

    Ugh! I'm not the programmer :-)



    Could you please edit the report.asp in the way you described and attach it to a message here, so I can exchange the file on our server.



    Thanks!

    Andreas Weber
  • Replied 4 August 2017, 3:09 pm EST

    As I said, the DLL is installed on the client.



    Greetings

    Andreas Weber
  • Replied 4 August 2017, 3:09 pm EST

    Could you please create and execute a VBScript file (.vbs extension) on the client machine with following code:


    dim xls
    set xls = CreateObject("ActiveReportsExcelExport.ARExportExcel")
    MsgBox xls.Version


    This script should not throw any exception if excel export filter is registered correctly.


    Thanks,


    Sergey Romanov.

  • Replied 4 August 2017, 3:09 pm EST

    Hi, sorry for the delay.



    I attached the report.asp in a RAR-file.



    I hope you can help!



    Greetings

    Andreas Weber
    2008/04/report.rar
  • Replied 4 August 2017, 3:09 pm EST

    Hi!



    The test worked!!

    The file C:\Test.xls was generated correctly.

    No errors!



    This means the common dialog component is corrupt?



    What can I do?



    Thank you very much for your help!!

    Andreas Weber
  • Replied 4 August 2017, 3:09 pm EST

    There has been a recent Microsoft update that affected many of the Microsoft 2003 Excel spreadsheets users where I work. We had to verify what systems were affected and found that the Active Report Excel files that were being created for the first time would no longer work.


    I did find that using a pre-existing file and writing to it did work.  


    Thanks for the actual fix. I hate work arounds.

  • Replied 4 August 2017, 3:09 pm EST

    Hi!



    I GOT IT :-)))



    The solution was: on the PC's that don't work, the file "comdlg32.ocx" was missing!! (comdlg32.dll was there)



    Copied it from another PC and registered it, and everything works fine!



    Thank you very very much for your help!!



    Greetings

    Andreas Weber
  • Replied 4 August 2017, 3:09 pm EST

    Hello ,


    There are many reasons for why the common dialog control can not work correctly:


    1) Make sure that comdlg32.cab file is placed on server in folder with report.asp page.


    2) The loading of comdlg32 can be blocked by security settings.


    3) The client machine has some older/newer version of common dialog control.


    4) license issues.


    etc.


    Thanks,


    Sergey Romanov.

  • Replied 4 August 2017, 3:09 pm EST

    You can find report2.asp in attachment.


    2008/04/report2.zip
Need extra support?

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

Learn More

Forum Channels