Skip to Content
0

Excluding Sheets without data in Worksheet Generation

Dec 01, 2017 at 09:17 PM

41

avatar image
Former Member

Hello SAP Gurus,

Here is what I am trying to do:

In a report, I use worksheet generation to display worksheets by costcenter. This works fine but here is the problem. Lets say I expand for all costcenters under IT, and there are 9 members under it. It will create worksheets for all 9 costcenter member, even for the ones that have no data. Is there a way to essentially surpress/not create sheets for cost centers that dont have data?

Thanks.

Zalak

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Dec 02, 2017 at 07:01 AM
0

Write your own worksheet generation procedure in VBA.

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Yeah was trying to avoid that but might have to go that route.

0

It's not a hard job if you know VBA. Just copy template sheet and fix a page axis member in a loop.

0

Interesting to know why you decided to unaccept the correct answer?

0