Please Help! Populate Prompts with Macros on refresh - BO6.5

[system]

Hi everyone Im using Business Objects 6.5 Service Pack 2,

Please someone help me its urgent, im at such a deadend!

I have over 40 reports to run and will take some hours over night to refresh. I am automating the whole process using Macros; Open, Refresh, SaveAs and Close then move on. I have this working apart from 1 thing.

Problem is each Report has Prompts! and requires User input for the Reports to continue to refresh.

The prompts are all same for all the Reports:
‘Current Month’
‘This Year’
‘Last Year’
I can use a variable to populate these at the start but how do i get these variables into the Prompts? What is the Macro Code? Please help!!!

Thank you in advance

---

sdleigh (BOB member since 2009-05-14)

[system]

Hi,

In the SDK forum you can find some examples of how to do it. Check out for instance these:

120×120 10.4 KB

Hi, I am trying to enter data into 2 prompts to a query with VBA like this: Application.Variables.Item(“date”).Value = #2/7/2006# Application.Variables.Item(“gcc”).Value = “3710BARBCAP1” And I am getting an error on the date (SQL error). I tried entering the date as “2/7/2006” but I got the same error. Any ideas ? Thanks for your help !!!1 eransh10 (BOB member since 2008-09-09)

120×120 10.4 KB

Hi, I’ve been trying to schedule a report with multiple value prompts for a long time. However, i’m very much able to schedule reports with single value prompt. Eg: Say i have a prompt text like “Select Country:” and want to pass multiple values with the help of BO SDK. I tried to pass values in this format “Australia;India;England” but the BO is taking it as a single value (Australia;India;England) instead of taking it as 3 separate values. Can someone tell me how would i achieve to meet my …

120×120 10.4 KB

My manager is the only person with a BO 5.1.3 licence so I have to write this message partially from memory. Sorry. I need to automatically run the same report about 30 times, using the 30 values from a results column in Excel as values for each report’s Variable. It needs to execute quickly when required, without manual intervention beyond clicking a command button on the Excel sheet. Using “TUTORIAL.REP” for an example, my code to set cell values of “Accessories” and 1234 is something like …

Or search for more topics in the SDK forum.

---

Marek Chladny (BOB member since 2003-11-27)

[system]

Thanks so much for the Links, i got exactly what i needed, this fills in the Prompt and then refeshes then saves.

cheers Marek

Private Sub Document_Open()

'Get through the Prompts and refresh
Application.Interactive = False

ThisDocument.Variables.Item("Year").Value = "2008"
ThisDocument.Refresh

Application.Interactive = True

'Save the Document now it is refreshed
Me.Save

'Save the Document as a PDF
Me.SaveAs ("...\Document2.pdf")

End Sub

Thanks again life saver

Stu

---

sdleigh (BOB member since 2009-05-14)

[system]

You are welcome. Glad it helped.

[Moderator Note: Moving to SDK forum]

---

Marek Chladny (BOB member since 2003-11-27)