How to add a group header to a specific data criterium and not to the whole data set.

David Lopez 1 Reputation point
2021-08-10T15:30:29.293+00:00

I have researched how to get the result that I want and I have made some headway, I just need some help on the finishing touch. We provide our quality engineer with production data that is sent to the customer. But, like all customers, they want it in a specific format. Our quality engineer can spend hours on manipulating this raw data. With Report Builder, I have reduced that time to minutes, at most, an hour. I just want to add one final touch that will take all the formatting requirements from the engineer and then they can focus on the last data item that is not available in our database.

In our process, we build a cord and assign it a serial number. This cord requires a fitting on each end and those fittings get assigned a child serial number. There are some 30 inspections that are performed either on the entire assembly or just the fittings. The customer wants a report that shows inspection results by serial number. They are not interested in seeing the child serial numbers. To make the customer report, I have taken a three-step approach. The first step was to pull the raw data. Table: SQL SERVER - Raw Data (Sample views of data: 121761-report-data.pdf)

The second step was to strip the child serial numbers and add two additional columns for the data for fitting A and fitting B. I also combined an integer column and a char column that showed the inspection results for the parent serial number. Table: SQL SERVER - Manipulated Data

In Report Builder, I took the manipulated data query and created a table that displayed the inspections across the top as column headers. I managed to group the data results of fittings A and B under their respective inspections. And, this is as far as I have been able to get. Table: Report Builder

The final touch, if it can be managed, is to add two more group headers to a specific set of inspections only. There are two inspections that require mercury and the customer wants those identified and grouped together. So, I need a group header for the In-Process mercury test and a group header for the Final mercury test and finally, a group header for both mercury tests. At this point, it really is just aesthetics, but if I can do this for the engineer, as well, then all the better. Table: Report Builder Final Touch

I have gone into Column Groups in Report Builder, but I have not been able to set the header on just the inspection that I want without affecting the whole layout of the table. Any help would be greatly appreciated.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,854 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,818 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,566 Reputation points
    2021-08-11T01:54:06.34+00:00

    Hi @David Lopez ,
    If you need to develop a report in a specific format, you can choose to use list.
    Assuming that it’s just to display the header beautifully, you could add a text box at the top and fit it.
    122117-01.jpg
    Best Regards,
    Joy


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.