Accessing prompt values of reports

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 ?

your help is highly appreciated.

Thanks,


Listserv Archives (BOB member since 2002-06-25)

Here is a quick sample, from this group:

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 ?

your help is highly appreciated.


Listserv Archives (BOB member since 2002-06-25)