Need help with macro to split a report

building reports desktopintelligence
1

Hi,

We are using Business Objects 6.5 and have a report.

The report has couple of blocks and it is a master-detail with a section on a dimension attribute.

Need to split this one big report into multiple reports and save as Excel spreadsheets using the section value as filter. If any body is aware of such a thing, could you share a piece of code or sample.

Regards,
Vaidhy

vaidhyee (BOB member since 2005-12-20)

2

I’m pretty sure that you can’t access section information from the SDK. Sounds like something that can be easily done via the Publisher.

An alternative would be to create a prompt for whatever you are sectioning by and then you can (via your macro) feed in the prompt values for the various sections of your report, saving a copy of the report to Excel as your program loops through a new prompt value.

jresendez :mexico: (BOB member since 2004-05-03)

3

check this code:

https://bobj-board.org/t/70306

BO_Chief :us: (BOB member since 2004-06-06)

4

Jorge,

Thanks for feedback. Can you explain a bit more on publishing part?

Vaidhy

vaidhyee (BOB member since 2005-12-20)

5

Hi Vaidhy

we done the same kind of job in one of my project and have a look on the following link.

Regards

Siva.M

looksmee :uk: (BOB member since 2006-02-08)