Support

This page provides a list of monthly updates to EnergyCAP Enterprise and Express reports.

Latest EnergyCAP Report Zip Files

• EnergyCAP Enterprise Reports
• EnergyCAP Online Reports

• BL36, version 4: Updated report logic that was incorrectly removing identical bill use and cost from the summary.
• CH06, version 3: Updated report to prevent duplication of values due to roll-over from SQL queries.
• CAP01EU, version 2: Updated report to display global unit values.

• AN10, version 3: Removed phantom crosstab when filtering for all commodities.
• AN12, version 2: Changed data being displayed from common units to native units since this report is at the meter level.
• AN19, version 5: Organization-specific unit conversions now recognized/honored for multi-tenant databases.
• BL01B, version 4: Organization-specific unit conversions now recognized/honored for multi-tenant databases.
• BL01C, version 3: Organization-specific unit conversions now recognized/honored for multi-tenant databases.
• BL02B, version 3: Organization-specific unit conversions now recognized/honored for multi-tenant databases.
• BL16, version 6: Added caption filter and caption column to the report.
• BL23, version 5: Removed leading spaces from cost column header.
• BL30A, version 1: New report. Identical to BL30A but designed for easy export to Excel.
• CAL17, version 4: Grouped monthly data together to avoid multiple records for the same month.
• CAP01B-2, version 2: Changed sorting order of report. Now sorts by Place Type and then Place.
• CAP01BU, version 3: Organization-specific unit conversions now recognized/honored for multi-tenant databases.
• CAP04, version 2: Organization-specific unit conversions now recognized/honored for multi-tenant databases.
• CAP04A, version 2: Organization-specific unit conversions now recognized/honored for multi-tenant databases.
• CAP07, version 5: Organization-specific unit conversions now recognized/honored for multi-tenant databases. Correct YTD values were not being calculated or displayed properly when a Cost without CAP or Cost with CAP value was missing.
• CAP10, version 4: Organization-specific unit conversions now recognized/honored for multi-tenant databases.
• CAP13, version 4: Organization-specific unit conversions now recognized/honored for multi-tenant databases.
• CAP15, version 3: Organization-specific unit conversions now recognized/honored for multi-tenant databases. CAP15A, version 3: Organization-specific unit conversions now recognized/honored for multi-tenant databases.
• CAP15B, version 3: Organization-specific unit conversions now recognized/honored for multi-tenant databases.
• CAP16PT, version 2: Organization-specific unit conversions now recognized/honored for multi-tenant databases.
• CAP18PT, version 2: Organization-specific unit conversions now recognized/honored for multi-tenant databases.
• CAP19, version 5: Organization-specific unit conversions now recognized/honored for multi-tenant databases.
• CAP19A, version 4: Organization-specific unit conversions now recognized/honored for multi-tenant databases.
• CAP21, version 3: Organization-specific unit conversions now recognized/honored for multi-tenant databases.
• CAP23, version 2: Organization-specific unit conversions now recognized/honored for multi-tenant databases.
• SU28, version 3: Added a Commodity filter and a Commodity column to the report.
• SU38, version 3: Now displays which User changed the account code.
• SU59, version 2: Organization-specific unit conversions now recognized/honored for multi-tenant databases.
• WTHR03, version 3: Removed empty groups from the report.
• YY16, version 5: Organization-specific unit conversions now recognized/honored for multi-tenant databases.
• YY16A, version 5: Organization-specific unit conversions now recognized/honored for multi-tenant databases.

• BL17, version 5: Report now displays the Vendor Code. Previously the Vendor Code was only available if the report was exported.
• CH09, version 2: If a meter has historical serial numbers assigned to it, only the current serial number will be displayed.
• YY16, version 4: Modifed the report to display equivalent Year-To-Date (YTD) comparisons. Comparison baseline data will only be included for months corresponding to the requested current year date range.
• YY16A, version 4: Modifed the report to display equivalent Year-To-Date (YTD) comparisons. Comparison baseline data will only be included for months corresponding to the requested current year date range.

• SU50, version 3: Added an Account Active filter.
• YY01, version 5: Improved report logic so variance is for the equivalent year-to-date.
• YY01A, version 3: Improve report logic so variance is for the equivalent year-to-date.
• YY02, version 5: Improved report logic so variance is for the equivalent year-to-date.
• YY02A, version 3: Improved report logic so variance is for the equivalent year-to-date.
• YY03, version 3: Corrected the Commodity filter to use the Common Use only when searching for one commodity.
• YY04, version 4: Corrected the Commodity filter to use the Common Use only when searching for one commodity.
• YY06, version 7: Increased the size of the Place Code display field to accommodate longer codes.

• BL07HP, version 1: Created a new report similar to BL07 with high precision values (up to four decimal places).
• BL07AHP, version 1: Created a new report similar to BL07A with high precision values.
• BL30, version 2: Added Maximum Demand for each place.
• CAP19, version 4: Updated the factor used for calculation of CO2 equivalent for cars removed from the road. Factor was modified by the EPA.
• CAP19A, version 3: Updated the factor used for calculation of CO2 equivalent for cars removed from the road. Factor was modified by the EPA.
• YY05, version 8: Changed the length of text being shown for the Place Code.
• YY05A, version 8: Changed the length of text being shown for the Place Code.

• BL01B, version 3: Corrected the report to prevent inflating of cost and use in certain circumstances.
• BL16, version 5: Updated a filter description to Bill Line Unit Value to clarify meaning.
• BL16A, version 5: Updated a filter description to Bill Line Unit Value to clarify meaning.
• BL17, version 4: Added an Export Date filter to enhance reporting.
• BT06, version 6: Corrected the actual budget cost to display actual cost values.
• CAP18PT, version 1: Added Special Savings to the report.
• SU48, version 4: Added a filter and column for commodity.
• YY06, version 6: Corrected the equivalent YTD calculations.

• AN13, version 5: Added a floor area square footage filter to the report.
• AN13PT, version 3: Added a floor area square footage filter to the report.
• AN17, version 5: Corrected an issue with display of global or common use units of measure.
• AN17PT, version 5: Corrected an issue with display of global or common use units of measure.
• AN19, version 4: Changed the report to show the maximum watts for the billing period.
• BL11, version 4: Corrected the cost/day calculation.
• BL11A, version 5: Corrected the cost/day calculation.
• BL23, version 5: Corrected the total cost calculation when multiple meters are associated with an account.
• BL23A, version 5: Corrected the total cost calculation when multiple meters are associated with an account.
• BL26, version 2: Corrected an issue with display of global or common use units of measure.
• BL32, version 4: Modified the unit of measure column header to be the common unit of measure for the commodity.
• CAP01G, version 1: Created a new report summarizing cost avoidance by Rate Code. Sorted by Rate Code.
• CAP07, version 4: Corrected an issue with skipping months depending on billing period settings. Calculations are now the same as the Cost Avoidance manager in ECE.
• CAP17PT, version 1: Created a new report for viewing special savings.
• CAP18PT, version 1: Added special savings to the report.
• YY16, version 3: Added meter code/name filters to the report.
• YY16A, version 3: Added meter code/name filters to the report.

• AN03, version 4: Rename the Demand Total column to TOTAL and created a new column for Maximum Demand.
• BL16A, version 4: Updated the report header for web clients to honor topmost view permissions.
• CAL17, version 4: Redesigned YTD calculations to only account for the equivalent months in the CURRENT year.
• CAP01E-0, version 1: Created a new report summarizing Cost Avoidance by Meter. Sorted by Meter.
• CAP01E-1, version 1: Created a new report summarizing Cost Avoidance by Meter. Sorted by Cost without CAP.
• CAP01EU, version 1: Created a new report summarizing Use Avoidance by Meter. Sorted by Cost Avoidance %.
• CAP01F, version 1: Created a new report summarizing Cost Avoidance by Vendor. Sorted by Vendor.
• CAP01G, version 1: Created a new report summarizing Cost Avoidance by Rate Code. Sorted by Rate Code.
• CAP16PT, version 1: Created a new report displaying Use & Cost savings for the most recent month and the period-to-date.
• CAP18PT, version 1: Created a new report to show total savings for a Place Type during a defined period of time.
• YY05, version 7: Updated YTD calculations to only account for the equivalent months in the CURRENT year.
• YY05A, version 7: Updated YTD calculations to only account for the equivalent months in the CURRENT year.

• BL38A, version 1: New report for filtering monthly bills by meter by the accounting period.
• BT06, version 5: Modified report to correct cost value for multiple meters assigned to an account.
• BT06B, version 5: Corrected report to remove inflation of values when there are multiple accounts associated with a meter.
• BT07A, version 4: Corrected report to remove inflation of values when there are multiple accounts associated with a meter.
• BT07B, version 4: Corrected report to remove inflation of values when there are multiple accounts associated with a meter.
• BT08A, version 4: Corrected report to remove inflation of values when there are multiple accounts associated with a meter.
• CAP01APT, version 1: New report for summarizing Cost Avoidance in an organization. Sorts by Place Type being summarized.
• CAP01A-1PT, version 1: New report for summarizing Cost Avoidance in an organization. Sorts by Cost without CAP.
• CAP01A-2PT, version 1: New report for summarizing Cost Avoidance in an organization. Sorts by the Cost Avoidance %.
• CAP01B-1, version 1: New report to summarize actual cost, Cost without CAP, Cost Avoidance dollars and Cost Avoidance % by building. Sorted by building.
• CAP01B-2, version 1: New report to summarize actual cost, Cost without CAP, Cost Avoidance dollars and Cost Avoidance % by building. Sorted by Cost without CAP.
• CAP03, version 1: New report charts cost savings. Includes a chart showing the cost savings for each month of a year, and a table with the cost savings amount for each month.
• CAP03A, version 1: New report charts the cost savings percent. Includes a chart showing the cost savings percent for each month of a year, and a table with the cost savings percent amount for each month.
• CAP04, version 1: New report charts the use savings. Includes a chart showing the use savings for each month of a year and a crosstab showing the use savings amount for each month.
• CAP04A, version 1: New report charts the use savings percent. A chart showing the use savings percent for each month of a year, and a table with the use savings percent amount for each month.
• CAP16PT, version 1: New report to provide use & cost savings for the most recent month and the period-to-date.
• CAP18PT, version 1: New report to show total savings for a Place Type during a defined period of time.
• YY05, version 6: Corrected report for excel export to align columns with the column headers.
• YY05A, version 3: Corrected report for excel export to align columns with the column headers.
• YY16, version 2: Corrected report to display use when it is equal to cost.
• YY16A, version 2: Corrected report to display use when it is equal to cost.

• BL18, version 3: Removed duplicate records which were being produced when multiple meters were assigned to an account.
• BL31, version 4: Modified report to correct a calculation error associated with meters that had been assigned inactive rates.
• CAP01E, version 4: Updated report layout to provide more space to display the meter name.
• CAP21, version 2: Added capability to display special savings in a future software release.

• AN02, version 5: Added a summary chart and grid when report is showing multiple places.
• AN10, no version chg: Updated the report description.
• AN12, no version chg: Updated the report description.
• BL01TOU, no version chg: Updated the report description.
• BL07A, version 2: Updated the procedure for gathering report data, and updated the report description.
• BL08, no version chg: Updated the report description.
• BL11A, version 4: Updated the report to include bills even if they are not assigned to batches, and updated the report description.
• BL17, version 3: Corrected a display issue with the bill batch field and updated the report description.
• BL28, version 3: Updated the report to include bills even if they are not assigned to batches, and updated the report description.  
• BL37, no version chg: Updated the report description.
• CAL13A, version 2: Corrected the report to display the correct unit of measure for different commodities, and updated the report description.
• CAL17, no version chg: Updated the report description.
• CAP02, version 3: Added an option to provide page breaks between places, and updated the report description.
• CAP15A, no version chg: Updated the report description.
• NORM06A, no version chg: Updated the report description.
• NORM07A, no version chg: Updated the report description.
• SU14, version 2: Added a commodity column and provided sort results by vendor, commodity, and rate. Updated the report description.
• WTHR03, no version chg: Updated the report description.
• YY05, no version chg: Updated the report description.
• YY05A, no version chg: Updated the report description.
• YY16, no version chg: Updated the report description.
• YY16A, no version chg: Updated the report description.

• BL10, version 4: Improved pie chart display to avoid clipping.
• BL33, version 5: Report now includes results for bills not assigned to batches.
• BL33A, version 4: Report now includes results for bills not assigned to batches.
• CAL14, version 4: Report now displays global units when multiple commodities are returned.
• CAL14A, version 3: Report now displays global units when multiple commodities are returned.
• CAP19, version 2: Add special savings holder to the report.
• SU06, no version chg: Updated stored procedure to return results for email batches.
• SU08, version 3: Added Topmost Place and Topmost Cost Center filters to the report. Sorted results by user full name. Updated stored procedure to return results for email batches.
• SU14, no version chg: Updated stored procedure to return results for email batches.
• SU48, no version chg: Updated stored procedure to return results for email batches.
• SU48A, no version chg: Updated stored procedure to return results for email batches.
• YY07, version 2: Modified report to prevent truncation of a query which can cause the report to fail.
• YY08, version 2: Modified report to prevent truncation of a query which can cause the report to fail.
• YY09, version 2: Modified report to prevent truncation of a query which can cause the report to fail.

• AN17, version 4: Change the default billing period value from Current Fiscal Year to Fiscal YTD.
• AN19, version 3: Change the default billing period value from Current Fiscal Year to Fiscal YTD.
• AN24, version 3: Modifications made to allow this report to run under EnergyCAP Enterprice 6.3.
• AN24A, version 3: Modifications made to allow this report to run under EnergyCAP Enterprice 6.3.
• BL11B, version 3: Update the report to limit results for the accounts that are associated with meters within the place tree that the user has access to.
• BL28, version 2: Change the default billing period value from Current Fiscal Year to Fiscal YTD.
• BL31, version 3: Change the default billing period value from Current Fiscal Year to Fiscal YTD.
• BL32, version 3: Change the default billing period value from Current Fiscal Year to Fiscal YTD.
• BT01, version 3: Update the table location of the budget name for the filter.
• BT02, version 3: Update the table location of the budget name for the filter.
• BT02A, version 3: Update the table location of the budget name for the filter.
• BT02B, version 3: Update the table location of the budget name for the filter.
• BT03, version 3: Update the table location of the budget name for the filter.
• BT03A, version 3: Update the table location of the budget name for the filter.
• BT03B, version 3: Update the table location of the budget name for the filter.
• BT04, version 3: Update the table location of the budget name for the filter.
• BT04A, version 3: Update the table location of the budget name for the filter.
• BT04B, version 3: Update the table location of the budget name for the filter.
• BT05, version 4: Update the table location of the budget name for the filter.
• BT06, version 4: Update the table location of the budget name for the filter.
• BT06A, version 4: Update the table location of the budget name for the filter.
• BT06B, version 4: Update the table location of the budget name for the filter.
• BT07, version 3: Update the table location of the budget name for the filter.
• BT07A, version 3: Update the table location of the budget name for the filter.
• BT07B, version 3: Update the table location of the budget name for the filter.
• BT08, version 3: Update the table location of the budget name for the filter.
• BT08A, version 3: Update the table location of the budget name for the filter.
• BT08B, version 4: Update the table location of the budget name for the filter.
• SU06, version 2: Add columns for the number of active and inactive accounts.
• SU27, version 2: Add filter for batch code.
• SU53, version 4: Remove ownerid from the stored procedure.

• AN01, version 4: Add rollup for the topmost place at the end of the report.
• BL01TOU, version 1: Report to show the time of use use/demand and total cost for a billing period.
• BL05, version 2: Change stored procedure to return null for the approve date when the bill has not yet been approved.
• BL16, version 4: Add join for filtering on a rate.
• BL23, version 4: Add the pay amount value to the output. Modify Excel export data only to include page headers.
• BL23A, version 4: Add the pay amount value to the output.
• CAP07, version 3: Fix stored procedure to have the status where clause defined.
• CAP15, version 2: Modify stored procedure for calculating the CO2 without CAP.
• CAP15A, version 2: Modify stored procedure for calculating the CO2 without CAP.
• CAP15B, version 2: Modify stored procedure for calculating the CO2 without CAP.
• CAP19, version 1: Report for reporting the cost savings and percent savings, energy reduction, and cumulative energy savings.
• CAP19A, version 1: Report for reporting the energy savings and percent savings, energy reduction, and cumulative energy savings.
• CAP21, version 1: Report for reporting the monthly cost savings and percent savings. Also the summarized saving for energy and cost savings.
• IN01, version 4: Correct the account address so it is being displayed.
• NORM09, version 1: New report for showing calendarized place energy usage per area.
• SU34, version 3: Add a place group name/code filter.
• YY10, version 3: Correct stored procedure for returning of multiple buildings. Was causing the report to not run properly.
• YY11, version 4: Correct stored procedure for returning of multiple buildings. Was causing the report to not run properly.
• YY12, version 4: Correct stored procedure for returning of multiple buildings. Was causing the report to not run properly.
• YY13, version 4: Correct stored procedure for returning of multiple buildings. Was causing the report to not run properly.
• YY14, version 5: Fix issue with report crashing when the End Month is February.
• YY15, version 3: Fix issue with report crashing when the End Month is February.

• AN24, version 2: Fix the report to show the most recent ENERGY STAR rating for the correct date.
• BL01A, version 2: Fix incorrect join for serial number.
• BL12, version 4: Modify column order and include cost/global unit to compare between commodities.
• BL12A, version 6: Modify column order and include cost/global unit to compare between commodities.
• BL15, version 4: Fix stored procedure to remove duplicate results when an account is associated with multiple meters.

• AN01PT, version 5: Add join for CostCenterParentChildView.
• AN14PT, version 3: Fix table alias in join. Add join for CostCenterParentChildView.
• AN15PT, version 3: Add join for CostCenterParentChildView.
• AN17PT, version 4: Add join for CostCenterParentChildView.
• AN22CC, no version change: Added note that the counter code must start with "TOTAL". Note added to the .rbi file and to the translate.
• AN25PT, version 3: Fix reports so they no longer fail on queries with place/meter group names. Fix table alias in join. Add join for CostCenterParentChildView.
• AN26PT, version 3: Fix reports so they no longer fail on queries with place/meter group names. Fix table alias in join. Add join for CostCenterParentChildView.
• BL10A, version 4: Fix the use and cost percentages to show correct percentage value instead of showing 100% for each commodity. Fix issue with commodity or meter level filters being defined. Add if condition for adding the meterWhere condition to the sql query.
• BL11A, version 3: Update report header. Fixed sql join for including serial number. Was incorrectly inflating values prior to fix.
• BL33, version 4: Fix issues with joins.
• BL33A, version 3: Fix issues with joins.
• BT01, version 2: Fix the location of the logic for creation of the joins. Previous location could cause a join to not be created. Fix table alias in join.
• BT02, version 2: Fix the location of the logic for creation of the joins. Previous location could cause a join to not be created.
• BT02A, version 2: Fix the location of the logic for creation of the joins. Previous location could cause a join to not be created. Fix table alias in join.
• BT02B, version 2: Fix the location of the logic for creation of the joins. Previous location could cause a join to not be created. Fix condition for including join.
• BT03, version 2: Fix the location of the logic for creation of the joins. Previous location could cause a join to not be created.
• BT03A, version 2: Fix the location of the logic for creation of the joins. Previous location could cause a join to not be created.
• BT03B, version 2: Fix the location of the logic for creation of the joins. Previous location could cause a join to not be created.
• BT04, version 2: Fix the location of the logic for creation of the joins. Previous location could cause a join to not be created.
• BT04A, version 2: Fix the location of the logic for creation of the joins. Previous location could cause a join to not be created.
• BT04B, version 2: Fix the location of the logic for creation of the joins. Previous location could cause a join to not be created.
• BT05, version 3: Fix inflation of actual costs.
• BT06, version 3: Fix inflation of actual costs.
• BT06A, version 3: Fix inflation of actual usage. Add join for CostCenterParentChildView.
• BT06B, version 3: Fix inflation of actual unit cost.
• BT07B, version 2: Fix concatenation of sql inserts which can exceed the length of the variable.
• BT08B, version 3: Fix concatenation of sql inserts which can exceed the length of the variable.
• CAL01, version 4: Align columns for export to Excel format.
• CAL11, version 2: Fix top most cost center join.
• CAL26, version 4: Fix top most cost center join.
• CAP01C, version 4: Fix issues with join alias.
• CAP01E, version 3: Fix the report by adding a temporary table into the stored procedure. This will fix the problem with too many filters.
• CAP08, version 3: Fix alias in topmost cost center join.
• CAP09, version 2: Fix to allow Topmost Cost Center filters.
• CAP13, version 3: Fix table alias in join.
• CAP14, version 5: Add a column to the report for the assignee.
• CAP15A, version 1: Add report showing CAP savings in CO2/metric ton at a building level.
• CAP15B, version 1: Add report showing carbon footprint at a building level.
• CH08, version 3: Fix join for topmost place.
• NORM01, version 4: Align columns for export to excel.
• SU25, version 3: Remove redundant join for when a meter group is defined.
• SU40, version 3: Fix tables in join to remove duplicate table name.
• SU48, version 3: Add topmost place security filter.
• SU48A, version 3: Add topmost place security filter. Fix the location of filters to reference the correct columns for PlaceName and VendorName.
• YY14, version 4: Fix logic for defining the topmost cost center join.

• BL12A, version 5: Fix the usage pie chart to show usage as global use.
• BL23, version 3: Add Pay Amount filter.
• BL23A, version 3: Add Pay Amount filter.
• CAL01, version 3: Remove the start date/end date/days columns since this added confusion.
• CAL04, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
• CAL05, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• CAL09, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer. Fix format of report for decimals.
• CAL10, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer. Fix format of report for decimals.
• CAL14, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
• CAL14A, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• CAL16, version 2: Add UOM to the report. Fix calculations for determining area cost per day and area use per day.
• CAL17, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer. Add topmost cost center name filter.
• CAL18, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
• CAL23, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
• CAL24, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
• CAL25, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
• CAL26, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer. Fix stored procedure to accept long account codes. Fix the 12th month to show the value for the month.
• CAL27, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer. Fix stored procedure to accept long account codes. Fix the 12th month to show the value for the month.
• NORM01, version 3: Removed the start date/end date/days columns since this added confusion. Removed accounting related filters.
• NORM02, version 3: Removed accounting related filters.
• NORM03, version 3: Removed accounting related filters.
• NORM04, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer. Removed accounting related filters.
• NORM05, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer. Removed accounting related filters.
• NORM06A, version 1: Add normalized report similar to YY01A.
• NORM07A, version 1: Add normalized report similar to YY01A.
• SU30, version 2: Fix the display for the Cost Center Name.
• WTHR02, version 6: Fix issue with filters not being recognized.
• YY04, version 3: Fix calculation for determining area cost per day and area use per day.
   

• AN01, version 3: Fix fiscal year logic issue.
• AN02, version 4: Add summary page to the end of the report. Fix fiscal year logic issue.
• AN03, version 3: Fix fiscal year logic issue.
• AN05, version 3: Fix fiscal year logic issue.
• AN06, version 3: Fix fiscal year logic issue.
• AN06A, version 3: Fix fiscal year logic issue.
• AN08, version 4: Fix the x-axis of the charts to show all labels. Fix the precision for the y-axis.
• AN09, version 3: Fix fiscal year logic issue.
• AN10, version 2: Fix usage per area to use floor area at time of the bill.
• AN12, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• BL01B, version 2: Fix report to show the correct demand.
• BL01C, version 2: Fix report to show the correct demand.
• BL02B, version 2: Fix report to show the correct demand.
• BL04, version 3: Fix stored procedure to run without truncating the sql statement.
• BL08, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
• BL08C, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
• BL09, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• BL10A, version 3: Fix pie charts that were cut off by the margins.
• BL11, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
• BL11A, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• BL11B, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• BL15, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
• BL16, version 3: Fix report to print on a landscape. Remove overlap of columns. Fix fields from overlapping in Crystal Report 2008 Viewer.
• BL16A, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
• BL17, version 2: Fix report by adjusting columns to not overlap. Fix fields from overlapping in Crystal Report 2008 Viewer.
• BL18, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• BL19, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• BL20, version 6: Fix fields from overlapping in Crystal Report 2008 Viewer.
• BL21, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
• BL22, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
• BL31, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• BL32, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• BL33, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer. Remove adjustments from the report.
• BL33A, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer. Remove adjustments from the report.
• BL34, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer. Fix column size of temporary table; long vendor names were causing the report to fail.
• BL35, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• BL36, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
• BL37, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• BL38, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• BL39PT, version 5: Fix the billing period to be displayed instead of truncated after the first letter.
• BL40, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• CAP06, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
• CAP10, version 3: Fix report to show usage when there is no cost.
• CAP15, version 1: Created report to show the energy reduction impact through cost avoidance.
• CH01, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• CH02, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• CH03, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• CH04, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• CH05, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• CH06, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• CH07, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• CH08, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• GHG02PT, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
• IN01, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU01, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU01A, version 3: Fix report to use stored procedure instead of inline query. Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU02, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU03, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU04, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU08, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU15, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU25, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU26, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU28, version 2: Improve report by limiting data to a user's topmost place permissions. Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU33, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU34, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU35, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU37, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU38, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU39, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU40, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU41, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU42, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU43, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU44, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU45, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU46, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU48, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer. Fix report's failure to use filter.
• SU48A, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer. Fix report's failure to use filter. SU49, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU50, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU51, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU52, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU54, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU55, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU56, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• SU58, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• WTHR02, version 5: Fix report to return results for running as a shared report. Fix fields from overlapping in Crystal Report 2008 Viewer.
• WTHR03, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• YY02, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
• YY03, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• YY04, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.
• YY05, version 5: Fix fields from overlapping in Crystal Report 2008 Viewer.
• YY05A, version 2: Add filters for meter name and code. Fixed overlap of fields in web reports.
• YY06, version 5: Fix fields from overlapping in Crystal Report 2008 Viewer.
• YY11, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
• YY13, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
• YY14, version 3: Fix fields from overlapping in Crystal Report 2008 Viewer.
• YY15, version 2: Fix fields from overlapping in Crystal Report 2008 Viewer.

• AN01, version 2: Add the fiscal start month filter.
• AN02, version 3: Add the fiscal start month filter.
• AN03, version 2: Display total demand instead of the bill with the highest demand. Add the fiscal start month filter.
• AN06, version 2: Correct issue with the table showing averages instead of totals. Add the fiscal start month filter.
• AN06A, version 2: Correct issue with table showing averages instead of total values. Add the fiscal start month filter.
• AN07, version 3: Change Energy Use per Area to two decimal places.
• BL10, version 2: Add the grand totals to the report.
• BT05, version 2: Fix to supplier charges not being included.
• BT06, version 2: Fix to supplier charges not being included.
• BT06A, version 2: Fix to supplier charges not being included.
• BT06B, version 2: Fix to supplier charges not being included.
• BT07, version 2: Fix to supplier charges not being included.
• BT07A, version 2: Fix to supplier charges not being included.
• BT07B, version 2: Fix to supplier charges not being included.
• BT08, version 2: Fix to supplier charges not being included.
• BT08A, version 2: Fix to supplier charges not being included.
• BT08B, version 2: Fix to supplier charges not being included.
• CAP01C, version 3: Fix to report not running when commodity filter was set.
• CAP11, version 2: Correct Fix to report not running when commodity filter was set.
• SU01A, version 2: Add contract start, end, renewal date filters. Add renewal date to the report display.
• SU48A, version 1: New report. Lists the meters assigned to a rate. If a meter has historical rate assignments, it may be listed multiple times. The report can be filtered so only current rates display.
• YY05, version 4: Fix to inflated values for use and cost.

• AN01PT, version 3: Modify stored procedure to honor topmost place security and place filters.
• AN04, version 5: Research ticket from last month. Modified CREATE table column PLACECODE to be same size as Place. PLACECODE. Remove Grand Total averages from the grid as this report is not defined for providing Grand Total averages.
• AN05, version 2: Modify report to be filterable and printable for fiscal years.
• AN09, version 2: Modify report to be filterable and printable for fiscal years.
• AN13PT, version 2: Modify stored procedure to honor topmost place security and place filters.
• AN14PT, version 2: Modify stored procedure to honor topmost place security and place filters.
• AN15PT, version 2: Modify stored procedure to honor topmost place security and place filters.
• AN17PT, version 3: Modify stored procedure to honor topmost place security and place filters.
• AN18PT, version 2: Modify stored procedure to honor topmost place security and place filters.
• AN20, version 6: Add a filter for filtering by LogicalDevice.
• AN25PT, version 2: Modify stored procedure to honor topmost place security and place filters.
• AN26PT, version 2: Modify stored procedure to honor topmost place security and place filters. Fix join to include cost for bills without usage.
• BL08C, version 2: Rename stored procedure appropriately for BL08C report.
• BL10A, version 2: Change datatype from DATE to DATETIME. This is to support SQLServer 2005.
• BL12A, version 4: Change datatype from DATE to DATETIME. This is to support SQLServer 2005.
• BL14, version 2: Remove the decimal values from the grid to allow more space for the more significant values.
• BL36, version 2: Change the SQL join for the BATCH from an INNER JOIN to a LEFT OUTER JOIN. This will allow clients not using batches to still get results. Update filter displays to show the filter value instead of the length of the filter.
• CAP01B, version 4: Remove explicit DSN from rpt header.
• CAP14, version 4: Show headers for all issues.
• GHG02PT, version 2: Modify stored procedure to honor topmost place security and place filters.
• YY01A, version 2: Change datatype from DATE to DATETIME. This is to support SQLServer 2005.
• YY02A, version 2: Change datatype from DATE to DATETIME. This is to support SQLServer 2005.
• YY17PT, version 2: Modify stored procedure to honor topmost place security and place filters.
• YY18PT, version 2: Modify stored procedure to honor topmost place security and place filters.

• AN20, version 5: Update issue with production total for a place/organization.
• AN22CC, version 5: Enhance report by adding filters for base year and counter type.  Group the report by place/counter type/commodity. For places with multiple counters, the counter name will be listed as "All <counter type> Counters".
• BL04, version 2: Update report to show one record for each account's billing period cost/use. This corrects inflated day values for multiple meters per account.
• BL08C, version 1: New report similar to BL08. This report will show billing periods that do not contain bills at an account/meter level.
• BL10A, version 1: New report similar to BL10. This report will also include the account charges.
• BL12A, version 1: New report similar to BL12. This report will also include the account charges.
• BL16, version 2: Update report to show account level charges.
• BL20, version 5: Update report to allow system defined bill messages to be available in the Bill Message Key filter.
• BL27, version 4: Fix issue with message being truncated on some bill messages.
• BL39PT, version 4: Modify report's stored procedure to correctly summarize by place type when a topmost place is defined for the user or when the topmost place filter is defined. Correct total results for use/area and cost/area.
• IN01, version 2: Add filter for customer code.
• YY01A, version 1: New report for showing comparisons similar to YY01 at the commodity level.
• YY02A, version 1: New report for showing comparisons similar to YY02 at the commodity level.
• YY06, version 4: Correct inflated values when filtering with a topmost place.
• YY12, version 3: Show the filters for the web client report.
• YY16A, version 1: New report to show comparisons at a meter level. Similar to YY16.

• AN02, version 2: Add additional commodity filter options.
• AN20, version 4: Correct issue with production value for a topmost place node filter.
• AN22CC, version 4: Display the base year in the chart. Currently the base year is the year prior to the "Current" year, or the year of interest.
• BL01B, version 1: Shows individual bills for each meter, organized by building. Includes demand/cost/use information. Similar to BL01 but also includes Commodity use/cost. This report is limited to showing the current rate for the account.
• BL01C, version 1: Similar to BL01B but includes G/L code. Shows individual bills for each meter, organized by building. Includes demand/direct cost/use information. Use is expressed in common units. Very similar to BL02.
• BL02B, version 1: Shows individual bills for each meter, organized by building. Use BL23 to export this type of data to Excel. Very similar to BL01. Also shows Local Distribution Company and Supplier use and cost separately.
• BL27, version 3: Make the Begin date visible.
• BL39, version 3: Add Account Period and Batch Number filters. Correct issue with non-accessible topmost place nodes being returned on Place Type of Organization.
• BL39PT, version 3: Add Account Period and Batch Number filters. Remove "divide by 0" error from report of buildings with floor space of "0" sq. ft.
• CAP01B, version 3: Removed accrual, accrual reversed, and void filters.
• CAP01BU, version 2: Removed accrual, accrual reversed, and void filters.
• CAP01C, version 2: Removed accrual, accrual reversed, and void filters.
• CAP01E, version 2: Removed accrual, accrual reversed, and void filters.
• CAP02, version 2: Removed accrual, accrual reversed, and void filters.
• CAP07, version 2: Removed accrual, accrual reversed, and void filters.
• CAP08, version 2: Correct values in Meter Code column from being displayed as false to the correct values of commodity/metercode.  Removed accrual, accrual reversed, and void filters.
• CAP10, version 2: Modified grid to display records on billing period. This will remove multiple records for different bills on the same billing period that have different start and end dates. Removed accrual, accrual reversed, and void filters.
• CAP13, version 2: Removed accrual, accrual reversed, and void filters.
• SU03, version 2: Change column from Bill Cycle to Service Dates.
• WTHR01, version 2: Remove values from dates that don't exist in the respective months.
• WTHR02, version 4: Modify query to allow filtering on Place.
• YY01, version 4: Update report to rollup to MMBTU when multiple commodities are defined in the commodity filter.
• YY02, version 3: Update report to rollup to MMBTU when multiple commodities are defined in the commodity filter. Increase cell width in grand total for cost. Remove comma from base/current year labels near the grand totals.

• AN08, version 3: Increase Energy/Area to be three decimals. Modify the Energy/Area column header to show the same UOM as the energy column.  Also adjust the total value to be reflective of the UOM/area. This was an impact in the Web Reports/ECO.
• AN08A, version 3: Increase Energy/Area to be three decimals.
• AN20, version 3: Updated query to remove inflation of production counts.
• AN22CC, version 3: Modify chart legend to not put a comma (,) in the year value.
• BL11, version 2: Filters out historical serial numbers.
• BL12, version 3: Filter topmost place code missing from displayed filters if defined. Modified Billing Period and Billing Period Year to be displayed too.
• BL15, version 2: Modify the report to show the rate that was assigned to the meter at the time of the bill.
• BL40, version 1: New report to show Usage and Cost from Submeter Readings.
• GHG02, version 1: New report to show GHG Emissions by Place Type. 
• SU55, version 2: Modify query to remove all split accounts from the report.
• YY01, version 3: Modify report column header for global unit rollup to correct when the rollup was not being shown.
• YY05, version 3: Modify report for new procedure to support YY05A.
• YY05A, version 1: New report requested by clients for monthly comparison by meter.
• YY06, version 3: Modify report to return results for filtering with topmost place name/code.

• AN17, version 3: Updated stored procedure. Adjusted logic order of code.
• AN20, version 2: Updated query to remove inflation of cost and use values.
• AN22CC, version 3: Updated chart data and legend (RPT-115).
• BL08, version 2: Renamed title of report. Added Commodity and Gap filters. Added meter level grouping.
• CAP14, version 3: Added Issue No. to the report.
• SU53, version 3: Corrected meter count for meters assigned to inactive accounts and meters assigned to multiple accounts.
• SU59, version 1, new report: New Unit System Report.
• WTHR02, version 3: Modified stored procedure to adjust place from 16 to 32 characters for placecode.
• YY05, version 2: Updated stored procedure. Added cost center view to remove duplication of records.

• AN01PT, version 2: Fix for web report failing.
• AN17PT, version 2: Fix for including historic floor areas in floor area totals.
• AN25PT, version 1, new report: Summarizes a group of buildings at the place type level. Provides monthly usage details for a twelve month period.
• AN26PT, version 1, new report: Summarizes a group of buildings at the place type level. Provides monthly cost details for a twelve month period.
• BL20, version 4: Fix for total being inflated when a bill has multiple messages.
• BL39PT, version 2: Fix for including historic floor areas in floor area totals.
• GHG02PT, version 1, new report: Displays total by place type for usage and equivalent CO2 of greenhouse gas emissions.
• YY14, version 2: Fix for multiple serial numbers on a meter inflating values.
• YY17PT, version 1, new report: Ranks “Place Types” (departments, divisions, regions, etc) from lowest to highest use/area. Compares use and use per area in a base year to a current year.
• YY18PT, version 1, new report: Ranks “Place Types” (departments, divisions, regions, etc) from lowest to highest cost/area. Compares cost and cost per area in a base year to a current year.

• AN01PT, version 1, new report: A version of AN01 that summarizes a group of buildings at the place type level. Displays three years of data, all of which are selectable by the user.
• AN13, version 4: Fix for inflated values
• AN13PT, version 1, new report: Ranks “Place Types” (departments, divisions, regions, etc.) from lowest to highest use/area. Use the "Summary by Place Type" filter to specify the place type. Whereas report AN13 ranks each individual building, AN13PT rolls up (summarizes) all buildings located below the selected place type in the Facility tree, and ranks the summarized place type nodes.
• AN14PT, version 1, new report: Ranks “Place Types” (departments, divisions, regions, etc) from lowest to highest cost/area. Use the "Summary by Place Type" filter to specify the place type. Whereas report AN14 ranks each individual building, AN14PT rolls up (summarizes) all buildings located below the selected place type in the Facility tree, and ranks the summarized place type nodes.
• AN15PT, version 1, new report: Ranks “Place Types” (departments, divisions, regions, etc.) from lowest to highest cost/unit. Use the "Summary by Place Type" filter to specify the place type. Whereas report AN15 ranks each individual building, AN15PT rolls up (summarizes) all buildings located below the selected place type in the Facility tree, and ranks the summarized place type nodes.
• AN17PT, version 1, new report: Ranks “Place Types” (departments, divisions, regions, etc.) from lowest to highest annualized use/area. Use the "Summary by Place Type" filter to specify the place type. Whereas report AN17 ranks each individual building, AN17PT rolls up (summarizes) all buildings located below the selected place type in the Facility tree, and ranks the summarized place type nodes.
• AN18PT, version 1, new report: Ranks “Place Types” (departments, divisions, regions, etc.) from lowest to highest annualized cost/area. Use the "Summary by Place Type" filter to specify the place type.  Whereas report AN18 ranks each individual building, AN18PT rolls up (summarizes) all buildings located below the selected place type in the Facility tree, and ranks the summarized place type nodes.
• BL21, version 2: Fix for overlapping columns in web report
• BL39PT, version 1, new report: Shows a summary of use, demand, cost, and unit cost by place type and commodity.

• AN07, version 2: Add billing period range to the top of the report. Change from hard-coded BTU to user unit of measure
• AN08, version 2: Fix billing period range at the top of the report. Change from hard-coded BTU to user unit of measure
• AN08A, version 2: Fix billing period range at the top of the report. Change from hard-coded BTU to user unit of measure
• AN13, version 3: Add billing period range to the top of the report
• AN14, version 2: Add billing period range to the top of the report
• AN17, version 2: Add billing period range to the top of the report
• AN18, version 2: Add billing period range to the top of the report
• AN19, version 2: Add billing period range to the top of the report
• BL01, version 2: Fix for report displaying duplicates if a vendor has more than one contract
• BL12, version 2: Add billing period range to the top of the report
• BL22, version 2: Change from always using billed demand to using actual demand and then billed demand if actual is not available
• BL23, version 2: Added secondary descending sort by bill end date. Fixed alignement of Excel export
• BL23A, version 2: Added secondary descending sort by bill end date. Fixed alignement of Excel export
• BL33, version 2: Fix for web report not showing filters in report footer
• CAP06, version 2: Fix for incorrect ordering of days
• SU53A, version 1: new version of SU53 with additional metrics
• YY01, version 2: Display the current and base year values instead of generic text. Add demand unit of measure. Fix first month filter
• YY02, version 2: Display the current and base year values instead of generic text. Add usage unit of measure. Fix first month filter
• YY06, version 2: Display the current and base year values instead of generic text. Fix first month filter

• BL07, version 2: Fix for incorrect address fields
• BL20, version 3: Add account name and service address to display
• BL27, version 2: Add account name and service address to display
• BL39: Fix for web report not showing filter selections in report footer
• WTHR02: Fix for incorrect total comparisons

• AN13, version 2: Fix for divide by zero error
• AN22CC, version 2: Fix for report failing with place filter set
• BL16A, version 2: Fix for incorrect total line unit cost
• CAP14, version 2: Added issueID to output of stored procedure
• SU32, version 2: Fix for report never returning results
• YY10 to YY13, version 2: Fix for 4th year column header displaying incorrect year
• YY16, version 2: Fix for report failing when it contains place codes longer than 16 characters

• BL20: Fix for long bill messages, causing the report to fail
• CAP01B: Fix for X axis not labeling every bar
• SU53: Added ownerID restrictions to the query

• AN08: Fix for web report always giving an error
• AN08A: Fix for column heading label displaying global units when a single commodity is selected in the filter
• AN11A: New report. Single year trend, month-by-month line graph and summary table of cost/area per building. Same as AN11, but one page per building.
• BL07: Fix for intermittent duplication of line it
• BL12: Changed billing period filter setting from previous fiscal year to current fiscal year
• BL14: Fix for report displaying in common usage units when "One Of" operator is used on commodity filter
• BL15: Fix for report dropping bills not in batches
• BL31: Changed billing period filter setting from previous fiscal year to current fiscal year
• BL38: Fix for report dropping bills not in batches
• CH09: New report. Checks usage derived from monthly meter readings prior to generating bills with the Calculate Bills Processor.
• SU01: Fix for "Status" column header spilling onto two lines
• SU06, SU08, SU48: Added ownerID restrictions to the query
• YY05: Fix for report returning no results when topmost place or topmost cost center filters are used. Fix for incorrect calculations in all totals.
• YY10: Fix for filters not displaying on web report
• YY10: Changed end year filter setting from previous fiscal year to current fiscal year

• All reports with date filters: Fix for "between" operators now including last day.
• AN02: Fix for the chart's values and unit of measure being different from the table's values and unit of measure
• BL01: Expanded the cost column to allow for more digits
• BT01 to BT04B: Fix for cost center and topmost cost center filters causing inflated values
• CAP01BU: New report; new version of CAP01B that shows avoided usage at the place level (instead of avoided cost)
• SU41: Fix for report always failing with a blue screen

• AN20: Fixed issue of places and commodities starting in the middle of a page instead of on a new page
• BL19: Report now includes all line items whose caption contains "late". Previously the report only included line items with observation type of "latefee" and caption of "late fee".
• BL25: To clear up confusion over which fiscal year the chart was referring to, added a label to the legend that says, "year beginning".
• BL26: To clear up confusion over which fiscal year the chart was referring to, added a label to the legend that says, "year beginning".
• CAP10: Added grand totals for usage values when the commodity filter is set to equals.
• YY14: Fix for duplicate rows displaying when there was greater than one serial number for a meter
• All reports: The "like" and "not like" operating were working like a "begins with operator". They were returning results that match the beginning of the string. Now you can return results that contain the search sequence