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.