Unable to open xl reporter

[Former Member]

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

[Former Member]

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

[Former Member]

hi all,

i have solved this issue through this link

thanks and regards

- priya

[Former Member]

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

Thanks,

Gordon

[Former Member]

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&note_numm=847981]

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

Regds,

Samapth.

[Former Member]

hi,

i have done all the above steps already what u said.can u plz tell any other solution.

-regards priya

[msundararaja_perumal]

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