"Hello, thank you for this excellent post. I was wondering if you could elaborate.
In this part of your tutorial you show the arguments section. What I would like to do is pass through todays date as the date parameter. In this example shown below in…"
This an example from a search engine:
Sub Simplemacro()'show dialog boxDim nResult As LongnResult = MsgBox( _Prompt:="Really run this macro?", _Buttons:=vbYesNo)If nResult = vbNo ThenExit SubEnd IfEnd…"
The date format is control by the operating system regional & settings option and it what BI5.5 will inherit those settings. Once date format is reflect correctly, then inside Report you may specify @Date@ parameter and…"
Please can you try performing the following the below steps to resolve this issue:
Check on the windows directory c:\Program Files\Common Files\BIComponents whether the DLL file exists If yes, browse to…"
Yes, the report can be deployed successfully; SMI Report Designer can be run out although the problem will come whereby when clicking on the BI Tools ribbon it will show “Genie not licensed” resulting in the report layout not…"
Please can you confirm the[instDir]\ SAI Component files installed by default successfully and the local user is part of Administrator group.
Something else that could prevent the program from running is the Windows UAC…"
Does the machine have Alchemex stand alone (with Administrator licence) on it local?, if yes, then you can connect directly to the database via Administrator within Alchemex standalone and if not, then BIC needs to be…"
Please can you try to register .dll file and then Launch the Pastel ERP Application.
How to register:
> regsvr32 /u "C:\Program Files\Pastel Evolution\evbicactiveXe.dll"
> regsvr32 "C:\Program Files\Pastel…"
Please can you try performing the couple method on the workbook, run the out the report in BIC, click on lookup worksheet, select from the start to end of the account to clear and then go into BIC select the option to create and link…"
"Yes that it's correct the container & the expression syntax needs to be changed be changed simpler to the database engine the report needs to on. The report which you needs to change is it a standard report which is shipped with the ACCPAC…"
Please can you perform a Windows search to see if the file does exist on ACCPAC directory, the permission on folder has been granted administrative rights.
if the a4wapi file does exist on the folder run ( regsvr32 /u /r "c:\ sage…"
The problem you are experiencing when running the report is related to pvsql vs ms sql syntax statement is different. An example will be PVSQL e.g. Select * from "tablename" and with MS SQL e.g. select * from tablename , you…"