Splitting the detail section of a report

M

MichaelAngelo

Hi there,
I need to know if is it possible to split the detail section of report.
I want the data to appear as follows
Name Age
Alice 10
Bob 12

Location
Hamilton
Oakland
If I place the location field in the detail section the data appears as

Alice 10
Hamilton
Bob 12
Oakland.
I don't want this in the report .I want the data to appear as two separate
sections but in the detail section.Could someone please please help me.
 
O

Ofer

You can create two sub reports that each display differen values
1. Name
2. Location

And the open the subreports within te report
 
M

MichaelAngelo

Hi I treid using a subreport but the problem is that when the report is run
it prompts me to enter the job number.The subreport is based on a query that
prompts you enter a job number.The subreport displays the correct information
when it is by itself but if I put it onto the detail secotion of the main
'parent ' it asks for a job number about 10 times.I don't know why this is.If
you have any suggestions that would be cool otherwise thanks for the reply
anyway cheers.
 
O

Ofer

You can put the subreport on the report header or footer, that way it will
prompt the user to enter the parameter only once.
 
Top