Columns and Labels issues

[Mrakulis]

My database is desjgned to collect test resuts in a lab. on each page, my
report displays 4 sets of test results(tests displayed using a sub report).
Now i have labels next to my sub report but are not bound to any specific
field. My problem is that the minute i have more than 4 results, the labels
only display on the first page. how can i set those labels on every page
printed regardless of what info is printed. similar to a header or footer,
but on the left side of the page. your help will be much appreciated.
Thanks
Mark

 

[scott04]

Mark,
If you put your labels in the details section rather than the header, it
should print onto the additional pages.
Scott

 

[Evi]

I've not tried this, but does it work if you use the section's Repeat
Section Property (you'll need to put the labels into a Section rather than a
Page Header but you can use Al Campagnas idea of putting a 'fake' field in
your report with GroupHead:1 so that it gives the same data then group by
this field so that the whole report is within the group)?.

Evi

 

[Mrakulis]

My Labels Aren't in my header. they are under detail. they are next to my tet
subform(which displays the 4 tests). Also, How do i put the labels into a
"section".

 

[Evi]

Are the subreports bound to anything in the main report?
Evi

 

[Mrakulis]

Yes. 1 Pfo(order number) to Many tests. it is filtered and sorted by the PFO

 

[Mrakulis]

Is it possible for you to give me your e-mail address. So i can send you one
of my reports to properly show you what is happening?

 

[Evi]

I've tried it out and I can see what is happening now Mrakulis.
Having the labels bound and in the leftmost subreport would only help if
that was the longest subreport.

Can you put the subreports and the labels into a Header rather than the
Details section? Then you could set the Repeat Section Property to Yes.
(It's on the Format tab of the Properties box)

Evi


but I'm wondering if there is anything built into later versions

 

[Evi]

Better make it clear. I don't mean the Page Header, I mean in a Header
created for the purpose. If you want to keep it seperate from your actual
order number header then create a field in your report's query with the same
value as the Order Number
MyHead:[PFO]. Put this field in the sorting/Grouping box directly under the
PFO, choose to give it a Header and put the Subreports and Labels in there.
You need a Header because the Header section has this Repeat Section
property.
Evi

 

[Mrakulis]

I just Tried that now. but it still only putting the labels on the first page.

I've got a rough idea why it's. doing that. in the menu where i've set the
columns i've set it to 4. then it goes across then down. so it thinks that
the labels are only needed for the first set.

I noticed that the "Repeat Section" function was for the whole header and
not for individual Fields within it.

I really appreciate your help. Thanks

Better make it clear. I don't mean the Page Header, I mean in a Header
created for the purpose. If you want to keep it seperate from your actual
order number header then create a field in your report's query with the same
value as the Order Number
MyHead:[PFO]. Put this field in the sorting/Grouping box directly under the
PFO, choose to give it a Header and put the Subreports and Labels in there.
You need a Header because the Header section has this Repeat Section
property.
Evi

I've tried it out and I can see what is happening now Mrakulis.
Having the labels bound and in the leftmost subreport would only help if
that was the longest subreport.

Can you put the subreports and the labels into a Header rather than the
Details section? Then you could set the Repeat Section Property to Yes.
(It's on the Format tab of the Properties box)

Evi


but I'm wondering if there is anything built into later versions
to

 

[Evi]

The MyHead header need contain nothing except the subreport and the labels.,

So is it the subreport that is set to have 4 columns going Across then Down
or the Main Report? Rather than posting anything to me,it would be ideal if
you could post a simplified version of your db containing dummy data (to
protect your own) onto a web page so that lots of people could take a look.
Then maybe one of the really clever people can come up with a solution.
Evi

I just Tried that now. but it still only putting the labels on the first page.

I've got a rough idea why it's. doing that. in the menu where i've set the
columns i've set it to 4. then it goes across then down. so it thinks that
the labels are only needed for the first set.

I noticed that the "Repeat Section" function was for the whole header and
not for individual Fields within it.

I really appreciate your help. Thanks

Better make it clear. I don't mean the Page Header, I mean in a Header
created for the purpose. If you want to keep it seperate from your actual
order number header then create a field in your report's query with the same
value as the Order Number
MyHead:[PFO]. Put this field in the sorting/Grouping box directly under the
PFO, choose to give it a Header and put the Subreports and Labels in there.
You need a Header because the Header section has this Repeat Section
property.
Evi

I've tried it out and I can see what is happening now Mrakulis.
Having the labels bound and in the leftmost subreport would only help if
that was the longest subreport.

Can you put the subreports and the labels into a Header rather than the
Details section? Then you could set the Repeat Section Property to Yes.
(It's on the Format tab of the Properties box)

Evi


but I'm wondering if there is anything built into later versions
Is it possible for you to give me your e-mail address. So i can send you
one
of my reports to properly show you what is happening?

:

Are the subreports bound to anything in the main report?
Evi

My Labels Aren't in my header. they are under detail. they are

next
to

my
tet
subform(which displays the 4 tests). Also, How do i put the labels
into a
"section".

:

I've not tried this, but does it work if you use the section's
Repeat
Section Property (you'll need to put the labels into a Section
rather
than a
Page Header but you can use Al Campagnas idea of putting a 'fake'
field
in
your report with GroupHead:1 so that it gives the same data then
group
by
this field so that the whole report is within the group)?.

Evi

My database is desjgned to collect test resuts in a lab. on each
page,
my
report displays 4 sets of test results(tests displayed using

a
sub

report).
Now i have labels next to my sub report but are not bound to any
specific
field. My problem is that the minute i have more than 4 results,
the
labels
only display on the first page. how can i set those labels on
every
page
printed regardless of what info is printed. similar to a

header
or

footer,
but on the left side of the page. your help will be much
appreciated.
Thanks
Mark

 

[Mrakulis]

It is the sub-report that is set to 4 columns.

I have no problem posting a db with dummy data. but i am unsure of how to do
so.
i also prefer to rather create a different db emulating the same problem
considering my db is 27mb and also contains file that I cannot distribute.

The MyHead header need contain nothing except the subreport and the labels.,

So is it the subreport that is set to have 4 columns going Across then Down
or the Main Report? Rather than posting anything to me,it would be ideal if
you could post a simplified version of your db containing dummy data (to
protect your own) onto a web page so that lots of people could take a look.
Then maybe one of the really clever people can come up with a solution.
Evi

I just Tried that now. but it still only putting the labels on the first page.

I've got a rough idea why it's. doing that. in the menu where i've set the
columns i've set it to 4. then it goes across then down. so it thinks that
the labels are only needed for the first set.

I noticed that the "Repeat Section" function was for the whole header and
not for individual Fields within it.

I really appreciate your help. Thanks

Better make it clear. I don't mean the Page Header, I mean in a Header
created for the purpose. If you want to keep it seperate from your actual
order number header then create a field in your report's query with the same
value as the Order Number
MyHead:[PFO]. Put this field in the sorting/Grouping box directly under the
PFO, choose to give it a Header and put the Subreports and Labels in there.
You need a Header because the Header section has this Repeat Section
property.
Evi


I've tried it out and I can see what is happening now Mrakulis.
Having the labels bound and in the leftmost subreport would only help if
that was the longest subreport.

Can you put the subreports and the labels into a Header rather than the
Details section? Then you could set the Repeat Section Property to Yes.
(It's on the Format tab of the Properties box)

Evi


but I'm wondering if there is anything built into later versions
Is it possible for you to give me your e-mail address. So i can send you
one
of my reports to properly show you what is happening?

:

Are the subreports bound to anything in the main report?
Evi

My Labels Aren't in my header. they are under detail. they are next
to
my
tet
subform(which displays the 4 tests). Also, How do i put the labels
into a
"section".

:

I've not tried this, but does it work if you use the section's
Repeat
Section Property (you'll need to put the labels into a Section
rather
than a
Page Header but you can use Al Campagnas idea of putting a 'fake'
field
in
your report with GroupHead:1 so that it gives the same data then
group
by
this field so that the whole report is within the group)?.

Evi

My database is desjgned to collect test resuts in a lab. on each
page,
my
report displays 4 sets of test results(tests displayed using a
sub
report).
Now i have labels next to my sub report but are not bound to any
specific
field. My problem is that the minute i have more than 4 results,
the
labels
only display on the first page. how can i set those labels on
every
page
printed regardless of what info is printed. similar to a header
or
footer,
but on the left side of the page. your help will be much
appreciated.
Thanks
Mark