I have a report in CR 2008 with 3 sub-reports. All 3 sub-reports are based on the same stored procedure. Each sub-report has 6 columns of numbers. I would like to be able to selectively supress a record if all 18 columns show a value of zero. So far I’ve tried using shared variables to pass the data from each sub-report to the other two sub-reports and then using selective suppression based on a calculation of the passed data. So far I’ve only gotten this to work in each individual sub-report so sub-report one may suppress 3 records while sub-report two only suppresses one record. I did notice that the value passed from sub-report one is equal to the total in sub-report one instead of on a record by record basis. Thanks in advance for any assistance.
rglamb1 (BOB member since 2012-04-03)