Skip to Content
avatar image
Former Member

Unable to open xl reporter

hi all,

i have installed the xl reporter successfully and from the tools menu(SBO) i opened the xl reporter.when i clicked the xl reporter, "Run-time error '0' " was displayed. Moreover in the SBO window it displayed the error message as " unable to start xl reporter object variable or with block variable not set "

-regards priya

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Sep 15, 2008 at 10:19 AM

    Hi,priyadharshini venkatesan.

    This is because the old stand-alone version of XL Reporter previously has been installed on the company database you are trying to use. and onceagain Uninstall then Install XL Report Add on.

    Solution :

    Start the Enterprise Manager from the Microsoft SQL Server program folder on your Start menu. Browse down to your Business One database, expand and choose tables. Right-click the table called ixtdbversion and choose Open table -> Return all rows. In the column 'Partner' change the text from SAP to SBOOEM and press Enter. Close the Enterprise Manager and start the add-on. The XL Reporter information in the database should now be upgraded.

    check the version of the dlls required by the DI AP.

    See this Links it will help for you.

    [847981|https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMSZ3PTU4ODAwMDAr)/bc/bsp/spn/smb_searchnotes/display.htm?note_langu=E¬e_numm=847981]

    [861599|https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMSZ3PTU4ODAwMDAr)/bc/bsp/spn/smb_searchnotes/display.htm?note_langu=E¬e_numm=861599][861599|https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMSZ3PTU4ODAwMDAr)/bc/bsp/spn/smb_searchnotes/display.htm?note_langu=E¬e_numm=861599]

    Regds,

    Samapth.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      -->Try uninstalling all addon

      -->Check in the control panel whether it is completely uninstalled

      -->Go to run->%temp%

      Delete all the files which you are able to delete.

      Note:None of the user should be logged in while installing Addon.

      If still the problem persists,check whether the registry is deleted, but i recomend you to take back up before doing any changes in the registry

  • avatar image
    Former Member
    Sep 15, 2008 at 04:43 PM

    Depending on your version, you may also need to delete two files under B1 client folder. File names like: AddOns*.SBO.

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 15, 2008 at 06:46 PM

    Hi

    Please check the following:

    - If you are using SQL 2000 check if the SP3 is installed

    - In case of that did not help follow the steps from SAP Note 819501 in order to clean up a corrupted add-on installation.

    Paulo Calado

    SAP Business One Forums Team

    Add comment
    10|10000 characters needed characters exceeded