Johnson Controls Metasys Advanced Reporting System (ARS) Custom Reports
ReportingGuru builds custom reports for Johnson Controls Metasys Advanced Reporting System (ARS), the optional reporting feature of the Extended Application and Data Server (ADX). Metasys ARS runs on Microsoft SQL Server and helps facility managers, compliance officers, and energy teams review building automation system configuration and performance across hospitals, universities, data centers, and commercial properties. With over 21 years of experience, we build custom ARS reports that go beyond the standard templates — configuration audits, energy tracking, and compliance dashboards tailored to your facility.
Fill out the form to speak with a Crystal Developer for a Free Analysis.
Johnson Controls Metasys Advanced Reporting System (ARS) Custom Reports
Metasys ARS is a standard capability of Metasys ADX and ODS servers running on supported SQL Server software. Its optional add-on, Energy Essentials, includes several pre-built report types — [according to Johnson Controls’ own documentation], these include a “Big Picture Energy” report (a single high-level view of normalized source energy use), a “Consumption” report (detailed usage by energy type), and an “Electrical Energy” report (usage, peak demand, and power factor).
Where custom reporting comes in: these built-in reports are useful starting points, but they don’t combine ARS data with other building or financial systems, don’t match lender or board-level formatting requirements, and don’t deliver automatically on a
schedule. That’s where custom report development connects Metasys ARS to a broader
reporting picture.
eRPs we work with
ReportingGuru works with almost every ERP and database out there. We are database developers, so we know how to find the data in any database/ERP. If there is a database, we can build reports.
EXCELLENT
Based on 26 reviews
Posted on Google![]()
Terese LindgrenTrustindex verifies that the original source of the review is Google.
I’m a Sage 300 RE user and needed a custom report for our annual Workers’ Compensation audit. Reporting Guru delivered exactly what I needed quickly and at a very reasonable price. Aaron and Kim were fantastic to work with — knowledgeable, responsive, and efficient. I’ll definitely use them again for future report modifications. They’ve saved me a huge amount of time! Highly recommend! ⭐⭐⭐⭐⭐Posted on Google![]()
Joseph ThomasTrustindex verifies that the original source of the review is Google.
Reporting Guru did an outstanding job helping our company access live data in QuickBooks Online. Their team was knowledgeable, responsive, and efficient—getting us exactly what we needed without any hassle. The solution they delivered has saved us time and improved the way we monitor our financials. Highly recommend!Posted on Google![]()
Patrick BurnsTrustindex verifies that the original source of the review is Google.
I have been utilizing Reportingguru's services for the past five years, relying on them for a wide range of tasks including SSRS reporting, SQL server optimization, and application support. They consistently deliver prompt, effective solutions to meet my needs. Collaborating with Aaron's team has provided us with a dynamic development resource, allowing us to access expert support without the need for a full-time in-house staff. I highly recommend their services.Posted on Google![]()
Jason BaughTrustindex verifies that the original source of the review is Google.
Reporting Guru has done an outstanding job on all our Vista reports. Prior to Reporting Guru, we used Viewpoint and it would take months for reports to be completed. The report programmers are very helpful and make great suggestions throughout the development. Thank you Aaron and your team!Posted on Google![]()
Patrick DunnTrustindex verifies that the original source of the review is Google.
I recently had the pleasure of working with Reporting Guru, and I am thoroughly impressed with their exceptional services. From the outset, their team demonstrated a high level of professionalism and expertise, ensuring that every detail was meticulously handled. The quality produced by them is unparalleled. What sets them apart is their commitment to customer satisfaction. They are incredibly responsive and attentive to our requirements, always going above and beyond to deliver on time. Their innovative approach and use of advanced technology ensure that we receive accurate and up-to-date information. I highly recommend them to any organization in need of reliable and high-quality services. Their dedication to excellence and customer-centric approach make them a standout choice in the industry.Posted on Google![]()
Robert SutherlandTrustindex verifies that the original source of the review is Google.
I have been working with the team at Reporting Guru for about 4 months. I am the ‘IT guy’ for a small company and I am overwhelmed with work. Although I have some ability to create and modify SSRS reports I am not proficient or fast. I found Reporting Guru with a google search and after reviewing their contract, I decided they were worth a try. I have been really impressed. The team is very professional, their project task tool is easy to use to follow the work and interact with the team members. The reports they modified not only look good but are better designed than the original Epicor ones. I started with just a few reports to ‘test’ their proficiency but now I am giving them all the report development so that I can concentrate on other areas of the business.Posted on Google![]()
Priyanka ManjunathTrustindex verifies that the original source of the review is Google.
ReportingGuru has been a great company to work with for custom reporting needs. The team is responsive and knowledgeable of our WMS and have been providing prompt assistance whenever needed. I did have some urgent report requests along the way and ReportingGuru's team was quick in addressing and providing solutions. They have played a pivotal role in creating some of the complex reports for our customers and for in-house use. I highly recommend them.Posted on Google![]()
Keith NortonTrustindex verifies that the original source of the review is Google.
Reporting Guru is fantastic, very easy to work with. They have helped our company quite a bit over the past few years with writing complex reports for our EPM software.
We Understand Building Automation Data, Not Just Report Writing
Metasys ARS reporting requires both technical and communication skills — translating building automation data (HVAC, lighting, energy, security) into reports facility managers and compliance officers actually use. Our team is 100% US-based, and we ask the questions that matter: does this report need to combine ARS data with other building systems? Does it need to run on a schedule for compliance audits?
Same-Day Responses, No Exceptions
We give same-day responses on every Metasys ARS reporting request.
We Speak Building Automation, Not Just SQL
Knowing SQL Server is one thing. Knowing how Metasys ADX, ODS, and Energy Essentials
data relate to each other is another.
Built for Facilities Running Metasys ARS
Configuration Audit Reports
Reviewing system configuration and performance against standards.
Energy Consumption Dashboards
Custom reports combining Energy Essentials data with facility-wide energy goals.
Compliance Reporting
Scheduled compliance dashboards for hospitals, universities, and regulated facilities.
Multi-Building Consolidated Reports
Combining ARS data across multiple facilities or campuses into one report.
You can expect the following:
- ReportingGuru understands your business requirements
- ReportingGuru helps make sense of your data with analysis
- ReportingGuru helps build report and dashboard specifications if necessary
- ReportingGuru sets up the reporting architecture and optimizes if necessary
- ReportingGuru writes the complex database reports and dashboards
- ReportingGuru does the database programming if necessary
- ReportingGuru builds reports to exact specifications
- ReportingGuru integrates multiple applications or locations together if necessary
- Use ReportingGuru On Demand - As Needed
- No weekly or monthly hourly minimums - we only bill for the hours we work
- No up front cost. We don't expect any prepayments for our work.
You Can Feel Confident That The Job Is Being Done Right Because of...
- Our Project Management System
- Daily Updates
- Strict Adherence To Project Roadmap & Timelines
- Customer QA & Acceptance Of Each Report
We're So Easy to Work With
We’re here to make your life easier. This means that we’ll tailor our services to your particular circumstances. For example, you don’t need an existing reporting system. If you have one, that’s great, but we’ll be happy to look at your needs and then design a system which is suitable. As well, we may recommend software platforms, but we’ll never try to sell them to you.
We actually know some programs which are free. We’re happy to share all of the knowledge and wisdom that we’ve gathered through the years with you and your team.
We specialize in report writing and database development and integration. We know how to extract information from every popular program out there. We’re also able to develop or integrate databases, with a mind to helping out clients reduce workloads at their workplaces.
For example, if you currently have staff members entering the same information in different databases, you’re wasting valuable time and money. When we create a database for you or perform software integration, your team members will only need to add information once!

All of our services are designed to lower your operating costs. When you use our company on an as-needed basis, you won't need to hire a full-time report developer to work at your place of business. Instead, you'll be able to get reports and related services when you need them and just pay as you go! It'll be way cheaper and you'll get reports which are custom and which are created by report developers who know everything about your particular software platform.
Talk To An Expert Today
As you can see, there’s no downside to hiring our company. You’ll get your reports and other services that you want, such as database integration, and you’ll pay less than you would if you had the same tasks performed by a full-time staff member at your workplace.
As well, you’ll access expertise from our team, as well as great communication.
We know that report creation is an iterative process and this is why our team members go out of their way to build strong bonds with clients. They talk and share information with them regularly, in a streamlined and efficient way.
To discuss your needs with us, just call or email (or fill out our convenient online form, on the right side of this Web page) in order to access caring advice from app and ERP report experts. We look forward to showing you just how affordable and accurate our reports and related services really are!

Common Questions
1. What is Metasys Advanced Reporting System (ARS)?
Metasys ARS is an optional reporting feature of Johnson Controls’ Extended Application and Data Server (ADX), running on Microsoft SQL Server, that lets authorized users run reports reviewing Metasys system configuration and performance.
2. What is Energy Essentials in Metasys ARS?
Energy Essentials is an ARS add-on with pre-built energy reports, including Big Picture Energy, Consumption, and Electrical Energy reports.
3. Do you build custom reports beyond the standard Metasys ARS templates?
Yes — combining ARS data with other building systems, formatted for compliance or board reporting, and delivered automatically on a schedule.
4. How much does it cost to hire a Metasys ARS reporting expert?
ReportingGuru works on an as-needed basis with no minimums, no retainers, and no up-front cost.
5. What facilities typically use Metasys ARS?
Hospitals, universities, data centers, and commercial properties using Johnson Controls’ Metasys Building Automation System.
6. How long does it take to build a custom Metasys ARS report?
A straightforward report is usually a few days; complex multi-facility reports can take one to two weeks.
7. Do we need to upgrade Metasys to get custom ARS reports?
No — custom reports connect to your existing Metasys ARS/SQL Server data without modifying your system.
8. Can you build compliance dashboards for Metasys ARS?
Yes — scheduled compliance and energy dashboards tailored to your facility’s requirements.