If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Splitting the detail section of a report
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. -- Much help appreciated thank you so much for your ideas |
#2
|
|||
|
|||
You can create two sub reports that each display differen values
1. Name 2. Location And the open the subreports within te report -- I hope that helped Good luck "MichaelAngelo" wrote: 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. -- Much help appreciated thank you so much for your ideas |
#3
|
|||
|
|||
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. -- Much help appreciated thank you so much for your ideas "Ofer" wrote: You can create two sub reports that each display differen values 1. Name 2. Location And the open the subreports within te report -- I hope that helped Good luck "MichaelAngelo" wrote: 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. -- Much help appreciated thank you so much for your ideas |
#4
|
|||
|
|||
You can put the subreport on the report header or footer, that way it will
prompt the user to enter the parameter only once. -- I hope that helped Good luck "MichaelAngelo" wrote: 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. -- Much help appreciated thank you so much for your ideas "Ofer" wrote: You can create two sub reports that each display differen values 1. Name 2. Location And the open the subreports within te report -- I hope that helped Good luck "MichaelAngelo" wrote: 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. -- Much help appreciated thank you so much for your ideas |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
To Sharkbyte and all: Calculate a total values in group level | Ally | General Discussion | 6 | June 13th, 2005 08:16 PM |
creating a text box control in hte detail section of the report | test | New Users | 0 | February 2nd, 2005 04:37 PM |
header of main report and detail (subreports) splitting | jenn | Setting Up & Running Reports | 0 | December 30th, 2004 04:40 PM |
Help!! I'm running around in circles! | CathyA | New Users | 19 | December 12th, 2004 07:50 PM |
Making the detail section of a report a set size (regardless of the Number of entries) | John Ortt | Setting Up & Running Reports | 2 | July 21st, 2004 02:41 PM |