Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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"))