Pipeline inspection software improves compliance reporting by turning inspection data into reports you can filter, reuse, and automate. That way, exceptions and delinquencies surface before they turn into compliance problems.
For example, a delinquency report can be set up to email the person responsible, then escalate to management as the deadline gets closer.
American Innovations' Pipeline Compliance System (PCS) includes a reporting engine that lets you build reusable report templates, customize the information you see, filter data based on specific conditions, and automate recurring reports. These capabilities help you and your team spend less time rebuilding reports and more time using the information those reports provide.
Based on our Virtual Brew: This article builds on the strategies covered in “Optimize PCS Report Configuration to Streamline Enterprise-Wide Compliance Reporting.” The Virtual Brew takes a deeper look at PCS report configuration, filtering, customization, standardization, and automation.
Here are six ways to get more from your pipeline inspection software and build a more efficient reporting process:
| Reporting Strategy | How PCS Handles It |
| 1. Choose the Right Report | Column reports, paper forms, graphs, and summary reports, plus standard templates for exceptions, delinquencies, and completed survey work. |
| 2. Customize Your Reports Around Your Workflow | Pick and arrange the fields each audience uses, and set paper size, orientation, and font scaling for readable PDFs. |
| 3. Use Filters to Focus Your Data | Ad hoc filters for one-time questions, and permanent filters with clear captions for reports you run again. |
| 4. Combine AND and OR Filters for Complex Questions | Grouped conditions that power exception and delinquency reports checking several criteria at once. |
| 5. Use Dynamic Dates for Recurring Inspection Reports | Date ranges like the current year that update on their own, so recurring reports never need new dates. |
| 6. Standardize and Automate Recurring Reports | Public custom reports give every team the same format, and email notifications send results to a distribution list as deadlines approach. |
1. Choose the Right Report
Good reporting starts with knowing what you need to learn from your data.
PCS includes several report types that give you different ways to view pipeline inspection and compliance information. Standard templates also provide a starting point for common questions, such as identifying exceptions, finding delinquencies, and reviewing completed survey work.
Column Reports
Column reports organize information into rows and columns, similar to a traditional data table. You can export the results as a PDF or CSV file.
This format works well when you need to review a detailed list of facilities, inspections, or other records or share the data outside the system.
Paper Forms
Paper form reports present information in a format that resembles a traditional inspection form.
You can drag and drop fields, apply color coding, and include pictures. This gives your field and office teams a familiar way to review inspection information while still working with data stored in the system.
Graphs
Graphs help you see changes and trends in your inspection data.
For example, you can graph rectifier readings over time to identify changes that could indicate ground bed depletion. You can also compare survey information by distance, including CIS, DCVG, annual, and periodic data, to get a broader view of cathodic protection system health.
Summary Reports
Summary reports give you a higher-level view of your data.
They help you count facilities, review inspection status, measure compliance against criteria, and calculate percentages. From there you can drill into the underlying records when you need more detail.
2. Customize Your Reports Around Your Workflow
A report becomes more useful when it presents the right information in the right order.
PCS lets you customize report layouts by selecting the fields you want to display and arranging them based on your workflow. You can build a report around the information your team actually uses instead of reviewing unnecessary fields every time.
For example, a report used by an inspector may need different information from a report used by a manager reviewing compliance across multiple regions.
Think about the questions each audience needs to answer, then build the report around those questions.
Make Your PDF Reports Easier to Read
Paper settings also affect how your report looks when you export it to PDF.
For reports with many columns, PCS supports different paper sizes and orientations. Tabloid paper, at 11 × 17 inches, provides more room than standard letter-size paper. Landscape orientation adds horizontal space for wide reports.
PCS also scales the text automatically based on your layout, paper size, and orientation, within the minimum and maximum font sizes you set. In the paper size estimate, any field that will wrap onto the next page shows up in red, so you can adjust the layout before you run the report.
3. Use Filters to Focus Your Data
Filters are where most of your reporting flexibility comes from.
A report can contain a large amount of information. Filters let you narrow those results to the records that meet specific conditions.
PCS supports both ad hoc filters and permanent filters.
Use Ad Hoc Filters for One-Time Needs
An ad hoc filter works well when you need to answer a specific question once.
For example, you might want to review a particular group of facilities or pull up records that meet a specific condition. Apply the filter, run the report, and move on without changing the report's permanent configuration.
Use Permanent Filters for Repeatable Reporting
Permanent filters make more sense when you repeatedly use the same criteria.
You can define the field, operator, and value that control the filter. You can also give the filter a more intuitive caption.
For example, a filter based on Facility Currently Active = Yes could display as Currently Active Facilities Only.
Clear labels make reports easier for other users to understand. They also reduce confusion when a report contains multiple conditions or more complicated logic.
Permanent filters are what make a report reusable and ready to automate.
4. Combine AND and OR Filters for Complex Questions
Some inspection questions require more than one condition.
PCS lets you combine AND and OR filters to create more specific reporting criteria.
An AND filter requires all conditions to match. For example, a delinquency report could identify facilities that are:
- Currently active AND
- Delinquent
An OR filter works differently. It lets a record qualify when it meets one condition or another. For example, an exception report could identify facilities with:
- Low test point readings OR
- Shorted casings OR
- Delinquent inspections
You can also combine groups of AND and OR conditions when you need more complex logic. PCS exception reports use this type of logic, and you can apply similar filtering concepts to other report types, including inspection and delinquency reports.
When building a complex filter, start with the question you want the report to answer. Break that question into the conditions that must be true and the conditions that could be true. Then build the filter around that logic.
5. Use Dynamic Dates for Recurring Inspection Reports
Date filters can create extra maintenance when you hard-code specific dates into a report.
Consider a report that needs to show inspections completed during a calendar year. A fixed filter might use January 1 and December 31 as the boundaries. When the year changes, someone has to update the dates.
PCS supports dynamic date ranges that eliminate that manual step.
Instead of entering a specific year, you can configure a filter to use the beginning and end of the current year. When the calendar year changes, the report automatically uses the new date range.
You can also compare one date field to another or add days, months, or years to a date.
Dynamic dates matter most for reports you reuse month after month or year after year. They also make automated reporting work, because the report keeps using the right date range without anyone updating it.
6. Standardize and Automate Recurring Reports
Once you have a report that works, save the configuration so your team can reuse it.
PCS lets you create custom reports that combine your layouts, permanent filters, sorting, themes, and print options. The system saves those settings together, so you can run the report without rebuilding the configuration each time.
Saved reports also make it easier to standardize reporting across your organization.
Create Consistent Reports Across Teams
PCS supports both public and private custom reports.
A private report remains available to the user who created it. A public report becomes available to everyone with access to that PCS database, while administrators control changes to the report.
An administrator could create a standardized annual inspection report, make it public, and ask teams across different regions to use the same report.
That gives everyone a consistent format instead of each user building their own version of the same report.
Keep Your Report Environment Organized
Standardization also requires some ongoing maintenance.
PCS administrators can use Themes Management to review layouts and remove unused configurations. They can also make useful reports created by individual users available to the broader organization.
Cleaning up unused layouts means fewer options to sort through when you build a report.
Automate Reports with Email Notifications
PCS can also automate public column reports through email notifications.
The system can automatically run a report, attach the results to an email, and send it to a distribution list. Recipients do not need to be PCS users as long as they have a valid email address.
You can also use business rules to determine when the system sends a report.
For example, a delinquency report could notify one person when a deadline falls within 90 days. At 30 days, the system could send the report to that person and their manager. At one week, it could escalate the notification to additional management.
PCS also takes the configured user hierarchy into account when running reports, so users receive the information they are configured to access.
Get More From Your Pipeline Inspection Data
If you rebuild the same reports every month, start with one. Set a permanent filter, add dynamic dates, and schedule it to email the people who need it.
PCS gives you the tools to build those reporting workflows and reuse them across your organization. Explore PCS, our pipeline compliance software.
American Innovations Help Center
Product Documents (Legacy Manuals)
RMA (Repair & Evaluation Return)
DVM Calibration
Product Training
Customer Service