Children's profile report

A

anthony

We run a nursery school. As part of the children's profiles, we print
a report showing photographs of the children's
activities split into the various areas of learning eg physical
development (PD), creative development (CD) etc. The
sub-report, which contains the photographs, is a snaking report giving
us six photographs per page. The photographs are all named by the date
and time they were taken eg 200803110912 (ie taken at 12 minutes past
nine on the 11th March 2008). This allows them to be presented in the
order in which they were taken. The relevant table also has a sort
order field which mostly mirrors the filename but can be adjusted if
non-sequential photos need to be presented next to each other.

We now have a requirement in one of the areas of learning (knowledge
and understanding of the world - KUW) to insert into the report a
series of pre-selected photographs which illustrate a particular
week's project, along with a heading and explanation of the project.
The heading and explanation need to be full width so can't be included
in the snaking sub-report but the photographs associated with the
project do need to snake

In other words, the existing report has to be adjusted in some way to
allow the snaking photos in the KUW section to be interrupted, at the
right date, by a full width section of text (heading and explanation),
followed by snaking photos just of the project, followed by the rest
of the child's KUW photos, until the date of the next project when the
situation repeats itself. It's the process of how to interrupt the
current report, bung in the project report and then continue with the
original report that is causing me difficulties. Any pointers please?
 
A

anthony

We run a nursery school. As part of the children's profiles, we print
a report showing photographs of the children's
activities split into the various areas of learning eg physical
development (PD), creative development (CD) etc. The
sub-report, which contains the photographs, is a snaking report giving
us six photographs per page. The photographs are all named by the date
and time they were taken eg 200803110912 (ie taken at 12 minutes past
nine on the 11th March 2008). This allows them to be presented in the
order in which they were taken. The relevant table also has a sort
order field which mostly mirrors the filename but can be adjusted if
non-sequential photos need to be presented next to each other.

We now have a requirement in one of the areas of learning (knowledge
and understanding of the world - KUW) to insert into the report a
series of pre-selected photographs which illustrate a particular
week's project, along with a heading and explanation of the project.
The heading and explanation need to be full width so can't be included
in the snaking sub-report but the photographs associated with the
project do need to snake

In other words, the existing report has to be adjusted in some way to
allow the snaking photos in the KUW section to be interrupted, at the
right date, by a full width section of text (heading and explanation),
followed by snaking photos just of the project, followed by the rest
of the child's KUW photos, until the date of the next project when the
situation repeats itself. It's the process of how to interrupt the
current report, bung in the project report and then continue with the
original report that is causing me difficulties. Any pointers please?
Click to expand...

Anyone care to advise on this please?
 
E

Evi

anthony said:
Anyone care to advise on this please?
Click to expand...

The term 'snaking report' discouraged me from attempting to answer this. Do
you think you could simplify your explanation of what you want and omit the
bits that aren't relevant to your question? More people might have a go at
it then.

Evi
 
A

anthony

Hi Evi

What I mean by "snaking" is a report in two columns where the data, in
this case images, goes across, then down. What's the generally
accepted term for this? I tried to simplify my original post but I
either end up with much the same explanation or a version that doesn't
explain in sufficient detail what I'm trying to achieve

Best - Anthony
 
E

Evi

It sounds as if you saying that you want the subreport which contains the
photos to be multicolumn but it isn't appearing that way?

Or is it that you have your report grouped by say project and you want the
this subreport to go into a new column when you reach the end of that
project?

You may have to use Rich Text in your reply so that you can type the layout
you want to see.

eg
Date - project Name

Photo1 - Photo2 - Photo3
Photo4 - Photo5 - Photo6

Evi
 
A

anthony

OK, that's an idea. Let me illustrate. The existing report works well
(I will use "AOL" for "Area Of Learning") eg

Child
AOL1
Photo1 Photo2
Photo3 Photo4
AOL2
Photo5 Photo6
Photo7 Photo8
etc

Note: Child and AOL are in the main report (and are full width) and
the photos are in the sub-report (and are in two columns)

Now, what I need is to identify a particular photo by its date (dates
are implicit in the naming convention I use for the photos), suspend
the two column subreport, insert the project report (which itself
consists of a main and sub report) and then continue the original eg

Child
AOL1
Photo1 Photo2
Photo3 Photo4
AOL2
Photo5 Photo6
Photo7 Photo8
<----- Details of project centred on A4 page ----->
ProjectPhoto1 ProjectPhoto2
ProjectPhoto3 ProjectPhoto4
<----- Summary details of project centred ----->
Photo9 Photo10
Photo10 Photo11
etc

I'm having difficulty coming up with a way to insert the project
report

It's worth saying that the project report will always be inserted
first thing on a Monday ie after Friday's photos but before Monday's
so it might be that I need to further group all photos into individual
weeks eg week1, week2 etc to assist with this. I'm really not sure
 
E

Evi

This really is an argument for top-posting. I've appended your first message
to the bottom of this one so that people can see all the facts which are
concealed in it. (some of us have to clean up our folders now and again and
not everyone wants to trawl through Google to find the original post).
Are you saying that you need a way to turn your PhotographName text field
back into a date and time field so that you can group by weeknumber and put
another subreport in the Week number footer or can you already do that?


Evi





OK, that's an idea. Let me illustrate. The existing report works well
(I will use "AOL" for "Area Of Learning") eg

Child
AOL1
Photo1 Photo2
Photo3 Photo4
AOL2
Photo5 Photo6
Photo7 Photo8
etc

Note: Child and AOL are in the main report (and are full width) and
the photos are in the sub-report (and are in two columns)

Now, what I need is to identify a particular photo by its date (dates
are implicit in the naming convention I use for the photos), suspend
the two column subreport, insert the project report (which itself
consists of a main and sub report) and then continue the original eg

Child
AOL1
Photo1 Photo2
Photo3 Photo4
AOL2
Photo5 Photo6
Photo7 Photo8
<----- Details of project centred on A4 page ----->
ProjectPhoto1 ProjectPhoto2
ProjectPhoto3 ProjectPhoto4
<----- Summary details of project centred ----->
Photo9 Photo10
Photo10 Photo11
etc

I'm having difficulty coming up with a way to insert the project
report

It's worth saying that the project report will always be inserted
first thing on a Monday ie after Friday's photos but before Monday's
so it might be that I need to further group all photos into individual
weeks eg week1, week2 etc to assist with this. I'm really not sure
Click to expand...

Original Email:
We run a nursery school. As part of the children's profiles, we print
a report showing photographs of the children's
activities split into the various areas of learning eg physical
development (PD), creative development (CD) etc. The
sub-report, which contains the photographs, is a snaking report giving
us six photographs per page. The photographs are all named by the date
and time they were taken eg 200803110912 (ie taken at 12 minutes past
nine on the 11th March 2008). This allows them to be presented in the
order in which they were taken. The relevant table also has a sort
order field which mostly mirrors the filename but can be adjusted if
non-sequential photos need to be presented next to each other.

We now have a requirement in one of the areas of learning (knowledge
and understanding of the world - KUW) to insert into the report a
series of pre-selected photographs which illustrate a particular
week's project, along with a heading and explanation of the project.
The heading and explanation need to be full width so can't be included
in the snaking sub-report but the photographs associated with the
project do need to snake

In other words, the existing report has to be adjusted in some way to
allow the snaking photos in the KUW section to be interrupted, at the
right date, by a full width section of text (heading and explanation),
followed by snaking photos just of the project, followed by the rest
of the child's KUW photos, until the date of the next project when the
situation repeats itself. It's the process of how to interrupt the
current report, bung in the project report and then continue with the
original report that is causing me difficulties. Any pointers please?
 
L

Larry Linson

"Snaking columns" is a commonly-used description; it's how you used to find
it in Help.

Page Setup is where it's specified. And, you may need to experiment with
the "Same as Detail" check box.

Depending on your needs, you might wish to put the pictures in a Subreport
with snaking columns (but, if so, make certain they are "Across Then Down".

Larry Linson
Microsoft Office Access MVP
 
A

anthony

I think, Evi, that I'm leaning towards adding a week field to the
photo table so that I can group on week. I will remove the KUW area of
learning from the existing report but otherwise leave the existing
report alone. I will then append the KUW report to it. The KUW report
will contain two sub-reports, the first for the project photos and the
second for all the other photos. It's not a problem for the project
photos always to come at the beginning of a week. With my limited
experience, I can't see any other way of doing this

I do appreciate your help
 
E

Evi

Are you OK changing the photoname back to a date? You need the functions
Val, Mid, Left & DateSerial.

Evi
 

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

Similar Threads

Use a variable in a ShapeRange.Increment 0
Inserting large picture files in reports problem 0
Report Group Footer DLookUp 0
Access 2002 change report header text 0
Creating Network Diagram using a Chart SW integration 0
Running Reports - Access 2003 1
Multiple Projects using a Resource Pool 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top