i would put each graph on a different RH section and conditionally suppress the sections.
I would create 2 flag formuals to use for the suppression
//IDM_flag
if field.category='IDM' then 1
//NN_flag
if field.category='NN' then 1
make sure both formula are set to 'use defualt values for nulls'
insert sums on each of the formulas
now conditinally suppress each graph section using the sums as
//Graph that will show when there is a category of IDM
NOT(SUM (@IDM_flag)>0 and SUM(@NN_flag)=0)
//Graph that will show when there is a category of NN
NOT(SUM (@IDM_flag)=0 and SUM(@NN_flag)>0)
//Graph that will show when there is both a category of IDM & NN
NOT(SUM (@IDM_flag)>0 and SUM(@NN_flag)>0)
//Graph that will show when there if no category of IDM or NN
NOT(SUM (@IDM_flag)=0 and SUM(@NN_flag)=0)
Edited by DBlank - 13 Mar 2012 at 9:04am
IP Logged
