InstantForum.NET v4.1.4Interprise Suite Communityhttp://www.interprisesuitecommunity.com/forums@dimesoftinc.comFri, 10 Feb 2012 17:45:12 GMT20http://www.interprisesuitecommunity.com/Topic67-5-1.aspx<DIV><DIV><DIV><DIV>Select the band you wish to hide, click on the scripts, and add the following logic in the following method:</DIV><DIV> </DIV><DIV>private void OnBeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) </DIV><DIV>{</DIV><DIV><BR> // Get the gl amount<BR> decimal glAmount = (decimal)GetCurrentColumnValue("GLAmount");</DIV><DIV> </DIV><DIV dir=ltr> // If the gl amount is zero, do not print the band<BR> if (glAmount == 0)<BR> e.Cancel = true;</DIV><P>}</P><P>The example above simply shows that we dont want a particular band to be printed if the GLAmount field is zero. </P><P>Note: The GLAmount field will need to exist on the report in order for this to work. The GetCurrentColumnValue method will fail if the field doesnt exist. Even if you do not want to show the field, it needs to exist on the report. Simply mark this field as not visible and you are good to go.</P></DIV></DIV></DIV>Thu, 23 Apr 2009 11:01:17 GMTBJ Dimes