Product Name field/column or report OR ProductName field/column

If you want productname column/field or Product Name column/field as Order form have in it sub-grid as shown below

(Note:productname column/field is column/field which shows three values

)

Solution:

Step 01: Make a report through report wizard and add two fields Existing Product and Write-in Product from Order Products/salesorderdetail table in the report.

Step 02: Download report .rdl file

Step 03; Make a report server project in visual studio with the help of sql server data tools in visual studio

Step 04: Add the downloaded report in the project

Step 05: Add column in a Tablix and in the expression write this expression =IIf(Fields!salesorderdetail1_productdescription.Value = "" , Fields!salesorderdetail1_productid.Value, Fields!salesorderdetail1_productdescription.Value)

This will done your requirement.