Ok i got it - you are right as you still use CYCLE functionality on FIELD to create reports for each cutomer..
Well i would create an aggregate amount in script and flag customers with amout > 0, or even create dedicated Customer DImension only for Customers with Amount > 0 and cycle through this additional dimension
You got the problem correct Lech,
But thing is, I do not want to skip customers without orders. I want to create a report for each customer, displaying his invoices. And if there are orders, add a list of the orders on that same report.
Only solution I see is to use a report for customers with orders and a report for customers without orders. And use some dedicated field to cycle through each set of customers.
But I'm hoping there is a better approach.
Found a solution for this I'd like to share;
You can link a 'formatting rule' in the property tab of a detail report inside your report.
Making this detail report invisible based on a Formula!
Set default 'visible = no, create formatting rule with a condition 'vShowChart = 1' or something and set in this rule the visible property to yes
Once this is done I made sure my charts and fields used in the sublevels both have no null values and no empty charts when cycling. (displaying 0 or ' ')
In my case the source qvw is only used to source the report so for me it was not a problem to have 0 lines or ' ' values in the charts in the qvw report, because they will be hidden in the NPrinting reports.