Create a new report using VBA

[system]

Hi all,

This is a general question on creating a new report from scratch using VBA in BO 6.5. The question is possibly a bit broad but any help on this would be appreciated.

Background:
My requirement is to be able to automate the generation of new reports in BO 6.5 as much as possible, ideally using VBA. I have two input documents, an excel file with the universe object names, formulae and sheet layout and a BO template.

What I can currently do :

1. Parse the input .xls file to obtain the new object names and formula.
2. Add new objects to a report using the “Add” method.

What I would like to be able to do :? :

1. Select a template
2. Populate non VBA data providers
3. Layout tables and header information

From what I’ve read on the boards, I’m guessing that what I can currently do is all I’ll be able to do automatically but I would just like to know if I’m missing some possible automation option. Any help/advice would be greatly appreciated.

Thanks

---

tdeasy2000 (BOB member since 2007-02-09)

[system]

Do a Search on BOB in SDK forum with keywords ‘DPVBA’ or ‘creating dataproviders’
Found one here

120×120 10.4 KB

Hi All, I’ve created a VBA Data Provider using VBA of BO, and saved it as an = Add-in. the code i used was Public Sub simple(dpInterface As DpVBAInterface) Dim i As Integer Dim Col As DpVBAColumn Dim Cols As DpVBAColumns 'the = columns of the microcube Dim newCube As DpVBACube =20 Set newCube =3D dpInterface.DpVBACubes.Item(1) 'there is only one = cube Set Cols =3D newCube.DpVBAColumns 'reference = the columns of the cube Cols.SetNbColumns (2) = 'Number of Columns in the cube Set Col =3D Col…

.

---

haider (BOB member since 2005-07-18)

[system]

Hi, I have the almost the same problem. I have an excel document containing the objects i want to use in a report. So far I managed to open Desktop Intelligence from Excel, but now I’m lost. Can you help me please ?
Thanks

---

andreiv (BOB member since 2009-11-16)