How to remove blank pages from Nprinting output while paging applied

[anindya_manna]

Hi Expert,

I am creating a Nprinting output of a report in excel format.I have applied paging option by a particular field.But in the chart that particular field values not present entirely.Few value missing.Thats why in Nprinting few pages are blank.Any idea how to remove those pages?

Header 1	Header 2	Header 3	Header 4
1	a	aa	500
2	b	aa	100
3	c	bb	200

For an eaxmple I am creating the pages based on Headr2 column which have values in DB a,b,c,d,e,f but in chart only a,b,c is there so for d,e,f, blank pages are generated.I dont have any scope to add any column in data model.

Please help

[ggijben]

Hi, I had the same problem. How I fixed it:

I was using CUSTOMER_NAME as page and revenue as measure in a table. But some customers had no revenue resulting in a blank page. Solution in my case: Left Keep on the customer dimension to the fact table. That way you drop the customers who have no revenue and you can get rid of the blank pages.