Splitting the detail section of a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You can create two sub reports that each display differen values
1. Name
2. Location

And the open the subreports within te report
 
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.
 
You can put the subreport on the report header or footer, that way it will
prompt the user to enter the parameter only once.
 
Back
Top