Knowledgebase: EC Enterprise
EC Enterprise: Billing Period Filter Options Missing
Posted by Barry Kroeker, Last modified by Joel Brickell on 10 July 2015 12:09 PM

Issue: Some reports and/or Custom Spreadsheets in EnergyCAP Enterprise Rel. 4.3 and previous don't show billing period filter options for "last month," "last year" and other similar choices.

Solution: New options were added to Billing Period report and Custom Spreadsheet options in release 4.3.

You will not see these options if:

1. You are running a release prior to 4.3. Upgrade to the latest release. Then install updated reports.

2. There may be out-of-date information in one of you database tables. The one-line SQL script below will repair it. You can copy/paste/save this line as a text file and then run it against the EnergyCAP database using the EnergyCAP Adminstrator program. Consult your system administrator for assistance.

UPDATE DataField SET dataType = 10 WHERE fieldName = 'billingPeriod'


by Administrator  last modified 06/25/2007  EnergyCAP Rel. 4.3 and previous.

(309 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name: