loop and print selection

[#1]

Hello,

I have a pivot table which displays information about sales, variance, profit etc. Those information are based on a department selection, so for example when user selects frozen department, it will display information only about that department. There are about 10 departments overall.

Is it possible to create a button, which will loop through those 10 departments, and print out sheet with pivot table for each department?

Thanks

[sebastiandperei]

No, in first place, try to identify why these report is blank. You said: "... Blanks happen when one of the values I band over does not return any values and the graph is blank in QV..."

This is always like that? e.g.: The field that i loop is "Product", and if you know that the product "Beer" doesn't have any data, you should create another dimention like "Product_report", linked with "Product", but without the row "Beer"...

Could you send a reduced sample?

[sebastiandperei]

So?