SSRS Report design for multiple occurrences in a field.

(0) Share

Report

Posted on by Rob1

Hello all,

I have created an SSRS report using fetch XML which will appear on the Order Entity.

When a user creates an order, they can add individual Machines from a custom entity named Machine. The Order form allows them to select multiple Machines (1 - 40) for the order.

In the screen shot below, I am pulling over the Field with Display Name Serial Number and field name of Machine_new_name. As there can be multiple machines in an order, I would like to have an individual report created for each individual instance of Machine_new_name.

I have tried grouping which groups the Serial Numbers of the Machines on the report, but as I mentioned, it would be great if report with the header and all fields on the report can be on a new report based on each individual Machine_new_name.

Thanks in advance!

Rob

Screen shot of SSRS report in Visual