How to Supress an Entire Band Based on a Field Value

Interprise Suite Community

Home

Members

Calendar

Who's On

Welcome Guest ( Login | Register )

How to Supress an Entire Band Based on a...

Rate Topic

Display Mode

Topic Options

Message

Posted 4/23/2009 11:01:17 AM

Post #67

BJ Dimes

Select the band you wish to hide, click on the scripts, and add the following logic in the following method:

private void OnBeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)

{

// Get the gl amount
decimal glAmount = (decimal)GetCurrentColumnValue("GLAmount");

      // If the gl amount is zero, do not print the band
      if (glAmount == 0)
          e.Cancel = true;

}

The example above simply shows that we dont want a particular band to be printed if the GLAmount field is zero.

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.

BJ Dimes
Software Development & Support Engineer
DimeSoft Business Solutions, Inc.
Interprise Suite Plugins
Interprise Suite Blog

« Prev Topic | Next Topic »