Milti Column Subreport

  • Thread starter Thread starter cgsanders7
  • Start date Start date
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.
 
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.
Click to expand...


Here's an article on that issue:
http://support.microsoft.com/kb/210044/en-us
 
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
Click to expand...
[quoted text clipped - 8 lines]
The detail section information won't print on a new page, only the multi
column subreport will.
Click to expand...

Here's an article on that issue:
http://support.microsoft.com/kb/210044/en-us
Click to expand...
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.
 
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
Click to expand...
[quoted text clipped - 8 lines]
The detail section information won't print on a new page, only the multi
column subreport will.
Click to expand...

Here's an article on that issue:
http://support.microsoft.com/kb/210044/en-us
Click to expand...
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.
Click to expand...


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.
 
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.
 
Back
Top