Hello, I am writing a report that i want to suppress the detail of if the total is zero. To get the total before I get into the detail, i placed a subreport in the group header section which adds up the detail, then i used shared variable to pass the total from the subreport to the main report. I then told the detail to suppress if that field is equal to zero. It is not working correctly. I even printed the field from the main report just to make sure it is returning the correct value, and it is.   I cannot understand why this would not work. It seems so simple. Any ideas ?

Hi, yes the total of both fields in the sub-report and main report are correct. I placed the sub-report in the group header, then added another section to the group header to show the value, just so that i could make sure it equalled the total in the detail section, which it does. So confused as to why this is not working. I have moved both the sub-report and the field around to different sections, just grasping at straws.

Edited by Kitty1 - 19 Oct 2016 at 4:35am

I am not saying that you did this (I sure have), but did you confirm the shared variable name that you have for detail suppression is the same shared variable name that is used in the sub-report.

Almost seems that the shared variable is getting set by another process.  Hard to say without going through the report very carefully.

Hi, I am back at this again!   I have gone through everything in this report looking for any possible reason for this behavior and I am coming up with nothing. Very frustrating. Most all of the zero invoices are being suppressed, but certain ones are not and I see no difference in any way with these that are showing up. anyone have any other suggestions?