Create a list of records

[Chris_]

Hi,

I'm looking to create a report which will create a single record for each employee and within that which equipment they have.

The data at the moment is like this.

Joe Blogs - Car
Joe Blogs - Medical
Joe Blogs - Fuel

If I restructure to have it like this;

Joe Blogs

Car
Medical
Fuel


It looks like this

Joe Blogs

Car

-

Joe Blogs

Medical

-

Joe Blogs

Fuel

I understand why this is happening, but not being successful in working around it.  Any suggestions?

Thanks, Chris.

[andy_mason_84]

If you have a list report

Column 1 - Employee
Column 2 - Equipment

Highlight column 1 and click the section button, will this give you the desired effect?

[Chris_]

Hi Andy,

Thank you - what you have suggested works well, however I don't think I was very clear in my original post.

My intention is to create in effect a letter template which would look something like this.

Employee Name : <Emp Name>
Operating Unit : <Op Unit>

Assigned Equipment
<List of Equipment>

The sectioning works well for the individiauls name and a list of the equipment they have - however when I start adding tables and fields to get something like the example/format above it isn't coming out as well as I'd hoped.

Is there a better way I could do this?

Regards, Chris.

[andy_mason_84]

Chris,

Can you show me what your report comes out like and an example of how you want it ...

From what you say below,  You want something pretty simple like the attached example, I have used different fields but functionality?

Supplier : <Supplier Name>
Company : <Company Name>

List of Products Supplied
<List of Products>

[bi4u2]

Chris, it sounds like you need to create a repeater table. An a master-detail link between the Employee and the Equipment they have?

[mtirpude]

Hi,

Is that the way you want (Please find attached snapshot)?
Please find the sample xml code as well.

Regards,
Manish Tirpude

[mtirpude]

Please find the sample code attached as well.

Regards,
Manish Tirpude