Where exactly the macro gets executed

[#1]

Hi all,

I have a requirement where as soon as user opens the report, he should get an update about status of a task.

This status I have to take from database.

So I used a macro to connect to the database, and is working fine in my system(on Qlikview Client)

Now I had put the same report to the Qlikview server and changed the connection string accordingly.

Now it is throwing error saying 'Driver not found'.

Is macro getting executed at client side?

If so, is there any other way to do the above mentioned task.

Thanking in advance.

[hic]

It depends on which client you use: The Internet Explorer PlugIn (OCX) or Ajax (JS). The Plugin runs client side and is quite capable, whereas the Ajax client is a thin client that cannot run client side macros, so it is very limited when it comes to the macro functionality.

See also http://community.qlik.com/blogs/qlikviewdesignblog/2014/04/28/macros-are-bad

HIC