How to filter empty pages from report?

[#1]

Hi,

I have an object showing data for several departments in file and my report is running over all of them. Not all of them have data relevant to specific week, therefore I get some empty pages (page per department).

How can I create a report showing only the pages/departments with data?

Thank's.

[marcus_sommer]

You could try to filter and select the departments with data before you start the print-job. Maybe a calculated listbox-expression might work. Try something like this:

if(sum(aggr(sum(YourField), Department, Week))>0, 'data available', 'no data')

- Marcus

[ramasaisaksoft]

Hi Ayala,

I hope you need to write a conditional show option.

Select  the ( for all tabs) tab ->right click->Sheet properties->Conditional Show sheet here u need to give condition

like

= if(sum(aggr(sum(YourField), Department, Week))>0, 'ActiveDocument.ActivateSheet "SH01"', ActiveDocument.ActivateSheet "Default Sheet ID"))