Creating a new sheet while filtering on a variable

building reports desktopintelligence
1

I am new so first of all hi!

I am looking to create a report which has a new sheet for each and every variable within a measure. Is this possible?

For example, if i have a report with three different areas. I would like it to automatically produce the same report three times but on 3 sheets so they can be used as data sets within excel.

Any help is appreciated.

Thanks.

gstewart (BOB member since 2008-07-01)

2

Welcome to B:bob:B!

It is possible with a little bit of VBA code. Take a look here … Create report tab and filter for each value

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

3

Just correcting URL string to directly go to the post.

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

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

4

Thanks … I also fixed it in the original.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)