A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

subreport between each entry on the report



 
 
Thread Tools Display Modes
  #1  
Old October 16th, 2007, 07:54 PM posted to microsoft.public.access.reports
Radhika
external usenet poster
 
Posts: 107
Default subreport between each entry on the report

I have created a report that has entries 1,2,3 and 4. I want to add a
subreport which has 2 more entries. However, when i try to do so, the entries
for the subreport show up in between those on the report. This is not what i
want. I want the subreport entries to show up below those of the main report.
How do i do this.

Radhika
  #2  
Old October 16th, 2007, 08:17 PM posted to microsoft.public.access.reports
John Spencer
external usenet poster
 
Posts: 7,815
Default subreport between each entry on the report

Put the subreport in the report footer.
or
Put the subreport in a group footer that is printed after your details



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"Radhika" wrote in message
...
I have created a report that has entries 1,2,3 and 4. I want to add a
subreport which has 2 more entries. However, when i try to do so, the
entries
for the subreport show up in between those on the report. This is not what
i
want. I want the subreport entries to show up below those of the main
report.
How do i do this.

Radhika



  #3  
Old October 16th, 2007, 08:40 PM posted to microsoft.public.access.reports
Radhika
external usenet poster
 
Posts: 107
Default subreport between each entry on the report

Thanks! I Put the subreport in the report footer, but it only shows me one
entry as opposed to two..i tried changing the size of the detail section, but
that did not work. Is there any way i can fix this?

Radhika

"John Spencer" wrote:

Put the subreport in the report footer.
or
Put the subreport in a group footer that is printed after your details



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"Radhika" wrote in message
...
I have created a report that has entries 1,2,3 and 4. I want to add a
subreport which has 2 more entries. However, when i try to do so, the
entries
for the subreport show up in between those on the report. This is not what
i
want. I want the subreport entries to show up below those of the main
report.
How do i do this.

Radhika




  #4  
Old October 16th, 2007, 08:50 PM posted to microsoft.public.access.reports
John Spencer
external usenet poster
 
Posts: 7,815
Default subreport between each entry on the report

Is the sub report linked to the main report via the detail fields? Is so,
you need to make a change to the sub report so it is not linked via the
field limiting it to the current record and you will probably need to change
the subreports underlying query.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"Radhika" wrote in message
...
Thanks! I Put the subreport in the report footer, but it only shows me one
entry as opposed to two..i tried changing the size of the detail section,
but
that did not work. Is there any way i can fix this?

Radhika

"John Spencer" wrote:

Put the subreport in the report footer.
or
Put the subreport in a group footer that is printed after your details



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"Radhika" wrote in message
...
I have created a report that has entries 1,2,3 and 4. I want to add a
subreport which has 2 more entries. However, when i try to do so, the
entries
for the subreport show up in between those on the report. This is not
what
i
want. I want the subreport entries to show up below those of the main
report.
How do i do this.

Radhika






  #5  
Old October 16th, 2007, 10:35 PM posted to microsoft.public.access.reports
Radhika
external usenet poster
 
Posts: 107
Default subreport between each entry on the report

Thankyou! That was very helpful.

"John Spencer" wrote:

Is the sub report linked to the main report via the detail fields? Is so,
you need to make a change to the sub report so it is not linked via the
field limiting it to the current record and you will probably need to change
the subreports underlying query.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"Radhika" wrote in message
...
Thanks! I Put the subreport in the report footer, but it only shows me one
entry as opposed to two..i tried changing the size of the detail section,
but
that did not work. Is there any way i can fix this?

Radhika

"John Spencer" wrote:

Put the subreport in the report footer.
or
Put the subreport in a group footer that is printed after your details



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"Radhika" wrote in message
...
I have created a report that has entries 1,2,3 and 4. I want to add a
subreport which has 2 more entries. However, when i try to do so, the
entries
for the subreport show up in between those on the report. This is not
what
i
want. I want the subreport entries to show up below those of the main
report.
How do i do this.

Radhika






 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:05 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.