SEM CPM - Link a Query in Web Mode

Hi all,

Im working with SEM-CPM ; i can't add a link to a query in web mode ; i have tried this :

1)Add URL ; works fine but i cannot add the URL dinamycally in order to take the local server ; for example when i transport to QAS then links points to DEV.

2)Add Query : execute the query in Excel.

How can i add a link to a report in order to executed in Web Mode ?

I will rewards asap.

Thanks !!