Milti Column Subreport

C

cgsanders7

I have a problem and I can't figure out a way around it. I am printing a
report with a multi column subreport. I want the detail information to be
printed on each new page that the subreport goes onto. Here is an example of
what I'm trying to do-

Detail Section Multi Column Subreport in Detail Section
Tag SDV-2201 SDV-2202 SDV-2203
Service Loading Lean Ocean
Fluid Natural Natural Natural

The detail section information won't print on a new page, only the multi
column subreport will. If there is anyway around this please let me know. I
don't know if this makes sense or not. Thank you in advance.
 
M

Marshall Barton

cgsanders7 said:
I have a problem and I can't figure out a way around it. I am printing a
report with a multi column subreport. I want the detail information to be
printed on each new page that the subreport goes onto. Here is an example of
what I'm trying to do-

Detail Section Multi Column Subreport in Detail Section
Tag SDV-2201 SDV-2202 SDV-2203
Service Loading Lean Ocean
Fluid Natural Natural Natural

The detail section information won't print on a new page, only the multi
column subreport will.


Here's an article on that issue:
http://support.microsoft.com/kb/210044/en-us
 
C

cgsanders7 via AccessMonster.com

Marshall said:
I have a problem and I can't figure out a way around it. I am printing a
report with a multi column subreport. I want the detail information to be
[quoted text clipped - 8 lines]
The detail section information won't print on a new page, only the multi
column subreport will.

Here's an article on that issue:
http://support.microsoft.com/kb/210044/en-us
For some reason when I try this it's not working out. The labels just print
over and over. I make adjustments and then both print. I know I'm doing
something wrong, but I'm not sure what.
 
M

Marshall Barton

cgsanders7 said:
Marshall said:
I have a problem and I can't figure out a way around it. I am printing a
report with a multi column subreport. I want the detail information to be
[quoted text clipped - 8 lines]
The detail section information won't print on a new page, only the multi
column subreport will.

Here's an article on that issue:
http://support.microsoft.com/kb/210044/en-us
For some reason when I try this it's not working out. The labels just print
over and over. I make adjustments and then both print. I know I'm doing
something wrong, but I'm not sure what.


The labels must fit within the same column width as the
data. I don't think that's the problem you're having now,
but keep it in mind.

I think the problem is in your code. If you'll post a
Copy/Paste of the procedure, maybe someone will be able to
figure it out.
 
C

cgsanders7 via AccessMonster.com

Thanks for your help, it was a problem with the page was layed out for 8
inches because of the page header, so I had to change the way the if
statement was done.

If Me.Left < Me.Width
Then had to be changed to
If Me.Left < 2800 Then
This fixed the problem. Thanks again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top