Review Report fixed field position

J

Jgtl

I want to print a report. Depending on how many records I print a
field that I want to be on the same place in the report moves up or
down. Is there a way to do this. (property "Top" does not do the job).
 
T

Tom van Stiphout

On Sat, 15 Nov 2008 01:24:45 -0800 (PST), Jgtl

But then it potentially overlaps existing records. Is that REALLY what
you want?

-Tom.
Microsoft Access MVP
 
J

Jgtl

On Sat, 15 Nov 2008 01:24:45 -0800 (PST), Jgtl


But then it potentially overlaps existing records. Is that REALLY what
you want?

-Tom.
Microsoft Access MVP
Click to expand...

No, but it is an application where players in a soccer team are
registered on a form with a preformatted lay out. There are max 11
players on the "play list" and 0 to 5 players who are substitutes. So
no records are overwritten. There is one field that is to be written
on the same spot on the form (the captain of the team (the name of the
captain can vary)). I hope this is clear to you now. Thanks for
responding!

Jos
 
L

Larry Linson

The Detail Section of the Report prints as many times as there are Records,
so you cannot fix the position of a particular Record on the page. If you
want the Captain's record to print first, then you need to add a sort field
prior to whatever field you are using that sorts on an indicator (Yes/No is
a good field type) for Captain. Report sorting is specified in the Report's
"Sorting and Grouping Properties".

Alternatively, if you want another entry just with the Captain's name, you
could put the Control to display it in either the Page Header or Page
Footer, which are in the same location on each page.

You really need to be simple and straightforward with what you need, or we
won't be able to assist. "Needs to be in the same fixed location" does not
fully describe the data needed nor does it locate the position.

Larry Linson
Microsoft Office Access MVP
 
J

Jgtl

Thanks for responding. This is how it looks like:

GCTV34O Player 1
GCVR31F Player 2
GDYJ37D Player 3
GFJG85U Player 4
LWBC09C Player 5
LWBC13D Player 6
LWBC14E Player 7
LXVQ468 Player 8
LXVQ48A Player 9
MCNK208 Player 10
FYJY14M Player 11

FYJY17P Substitute 1
FZQH07R Substitute 2
GCQT22M Substitute 3
GHDT88A Substitute 4


Captain

Number of substitutes can vary. That's why the captain field moves up
and down. All is in the detail section.

Captain field:
W 11,026cm
H 0,979cm
T 5,7cm
L 0cm
 
L

Larry Linson

There is no reasonable way to fix the position of a detail record on a
report page, when it is preceded by a varying number of other detail
records.

One solution that I can see to your printing this information on the
preprinted form and having the information in the correct positions would be
to use Queries to create the following four Queries... one Query for Team
which you would use for Record Source of the main report, a second, related
Query of Players, a third, related Query of Substitues, and a fourth,
related Query of Captains (one per team).

Then size the Detail Section to the height of your preprinted form, and on
it place three Subreport Controls with their Can Grow/Can Shrink properties
set to "NO". In the first of these, embed a Report of Players, in the
second, embed a Report of Substitutes, and in the third, embed a Report of
Captain. Synchronize the Main Report and eah Subreport Control with
LinkChildFields and LinkMasterFields of Team identifier.

It's some detail work, but I think that can accomplish exactly what you
want.

Larry Linson
Microsoft Office Access MVP
 
J

Jgtl

There is no reasonable way to fix the position of a detail record on a
report page, when it is preceded by a varying number of other detail
records.

One solution that I can see to your printing this information on the
preprinted form and having the information in the correct positions wouldbe
to use Queries to create the following four Queries... one Query for Team
which you would use for Record Source of the main report, a second, related
Query of Players, a third, related Query of Substitues, and a fourth,
related Query of Captains (one per team).

Then size the Detail Section to the height of your preprinted form, and on
it place three Subreport Controls with their Can Grow/Can Shrink properties
set to "NO". In the first of these, embed a Report of Players, in the
second, embed a Report of Substitutes, and in the third, embed a Report of
Captain.  Synchronize the Main Report and eah Subreport Control with
LinkChildFields and LinkMasterFields of Team identifier.

It's some detail work, but I think that can accomplish exactly what you
want.

 Larry Linson
 Microsoft Office Access MVP









- Tekst uit oorspronkelijk bericht weergeven -
Click to expand...

Thank you very much! I will try what you suggest.
 
Top