question

DavidLopez-4362 avatar image
0 Votes"
DavidLopez-4362 asked DavidLopez-4362 commented

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

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-generalsql-server-reporting-services
report-data.pdf (121.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered DavidLopez-4362 commented

Hi @DavidLopez-4362 ,
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.


01.jpg (30.2 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Not quite what I need, though it is a good idea. This report allows the engineer to select test results based on a shop order. Different shop orders have different inspections. If the shop order has the mercury inspections, then I need to be able to add the group headers as mentioned in my request. That's what makes this request so tricky. I have to identify when that mercury inspection is present and add the headers at that point.

0 Votes 0 ·