spk-logo-tm-2023
0%
1-888-310-4540 (main) / 1-888-707-6150 (support) info@spkaa.com
Select Page

How to rename column headers in your PTC Integrity Custom Reports

windchill features best plm software
Written by SPK Blog Post
Published on June 4, 2015

In the Metrics, Metrics, Metrics series of articles I wrote about PTC Integrity Lifecycle Manager, I talked about how you can use metrics information gathered from fields on your report to build custom reports, charts and dashboards. Now that the main series is complete, I will follow up with some articles that will describe some simple tricks and tips you can use to make the objects you create more effective, informative and more pleasing to the eye.

One of the things I noticed early on was that when I was creating my first custom reports in PTC Integrity Lifecycle Manger, was that sometimes the fields I wanted to use in my reports had long and sometimes unwieldy names, especially when you are trying to put them in a PTC Integrity Lifecycle Manager custom report.

In Metrics, Metrics, Metrics: Part 2, I built a simple back trace report that looked something like this:

Simple_Back_Trace_report

By default in PTC Integrity Lifecycle Manager custom reports, the field name becomes the column header.  But say you don’t want your column headers to be that wordy, well there is a way around that.  You can use a simple computation to retrieve the value you are looking for, and label the column anything you want.  For example when you get to the Item fields dialog on the Report wizard, simply select the Add button within the Computed fields box:

Item_Fields

This will open the Add Expression dialog, from there you just fill in the Expression Name, which will be your new column header, then use the getFieldValue computation to retrieve the information you are looking for.  Depending on whether or not you are retrieving a numeric value, you can choose to include a display pattern or not.  In this case I have created a new version of the Document Short Title for my report:

Add_Expression

When I am done, I select OK, and reposition my new computation where I had the original “Document Short Title” column, which I have deleted of course:

Item_Fields2

After I have replaced all the columns with my new computations, the Item Fields panel of the Report Wizard will look something like this:

Item_Fields3

Once you are done here you can save your report, and see how it’s been updated:

Simple_Back_Trace_report2

I hope that you will find this to be a handy little trick to assist you in your future report writing efforts.  Often times a little trick like this can make the difference between a report that is professional, readable and well received and one that isn’t. In future blog articles, I may add a few more little tips and tricks that will help with your report writing in PTC Integrity Lifecycle Manager.

Next Steps:

Latest White Papers

A Guide to Ensuring CAD Success in Virtual Environments

A Guide to Ensuring CAD Success in Virtual Environments

As the shift to cloud-based CAD increases, businesses are searching for the perfect virtual CAD tool. Discover all about SPK vCAD as well as other virtual CAD options for collaborative design on this eBook.What You Will Learn In this eBook, you will discover: Future...

Related Resources

Fast Answers, Fewer Meetings: Building a Smart Knowledge Culture

Fast Answers, Fewer Meetings: Building a Smart Knowledge Culture

If your day feels like a relay race between status calls and Slack pings, you’re not alone.  Most teams still default to “let’s meet” when they can’t find an answer quickly.  However, the cost of this is real. Slow decisions, fragmented knowledge, and “do-overs”...

Making the Leap from IBM Rational DOORS to Modern ALM Solutions

Making the Leap from IBM Rational DOORS to Modern ALM Solutions

For years, IBM Rational DOORS has been a cornerstone for requirements management in highly regulated industries. Unfortunately, as development practices evolve, DOORS has not evolved with them. One of the biggest challenges with this is that there’s no direct upgrade...

The Role of Managed Services in Scaling Engineering Projects

The Role of Managed Services in Scaling Engineering Projects

Introductions Hi everybody. I'm Michael Roberts, Vice President of Sales and Marketing here at SPK and Associates. And today we're discussing a topic that's shaping the future of product development and engineering. And that's the role of managed services and managed...