VB 2008, Crystal that comes with.

I've got 3 tables.

Customers, software, hardware.

Software and hareware both have the exact same fields, they are seprate tables only for organization purposes.

Software and Hardware are related to customers via inner joins.

I've a group name: Customer ID
2 detail areas: one for hardware, one for software.

When i run the report what im looking for are all hardware items together in their detail area, followed by all software items.

hardware item 1
hardware item 2
hardware item 3
hardware item 4

software item 1
software item 2
software item 3
software item 4
etc

What im currently getting looks like this:

Hardware item 1
software item 1
hardware item 1
software item 2
hardware item 1
software item 3
hardware item 1
software item 4

hardware item 2
software item 1
hardware item 2
software item 2
etc

I know if i put the hardware and software tables into subreports and bring them in via links this will work. I'm trying to find a way to keep this all in one report though. Previously when using MS Access I would write a query that had a union statement in it. The crystal database expert doesnt appear to support that.

Any help please?