Reporting with sub forms

Reporting with sub forms

Hi there,

I'm trying to create a report, within Zoho Creator, that pulls through data from a sub form.  However I want 2-3 fields from the sub form to show in separate columns in the report output, rather than in one.

Is this possible with Inner Joins or an easier method ?

The main form is called Service/Claim Request, the Sub Form is called Product Details and the fields I want to pull through from the Product details report are:
      Product Type
      Serial Number
      Asset Number

Appreciate any help

Kind Regards

MattP