This may sound a little dumb, but I have done this long back and forgotten too…
I have a report which I want to publish through docagent. This report prompts for
customer name as input.
What I want to achieve is build a script which runs a query (or a dummy data provider)
and gets all the customers from the database. Then it refreshes the report passing each of these customer names
and saves the report for each customer. Finally I shall automate this process by scheduling it through docagent.
Now how do I pass/access the prompt variables of the report in the script ?
Dim X As busobj.Variable
Set X = Application.Variables.Add(“select DB”) X.Value = “mydatabase”
Application.ActiveDocument.Refresh
You need to match the (“select DB”) part to your prompt - the .value is what you want stick in the prompt
Good luck,
Brent
Greetings everyone !!
This may sound a little dumb, but I have done this long back and forgotten
too…
I have a report which I want to publish through docagent. This report
prompts for
customer name as input.
What I want to achieve is build a script which runs a query (or a dummy data
provider)
and gets all the customers from the database. Then it refreshes the report
passing each of these customer names
and saves the report for each customer. Finally I shall automate this
process by scheduling it through docagent.
Now how do I pass/access the prompt variables of the report in the script ?