Report Question

[Jim Williams]

I have put together a 'progress' report in my training management db
that I've been working that works like a dream. When they open the
report it asks for which student they want to create the report for,
and then it creates the report. Great for its purpose. Now I'm trying
to think of the big picture - what if we need to print for X number of
students at once.

I can't seem to wrap my head around the way I'd create progress reports
for, oh say, anyone who has returned a test in the past X days.

For some reason, I can get it to do it on one page, but I'd like it to
repeat the same style report for each student. Perhaps I'm looking at
it the wrong way. Any thoughts?

Have a great weekend!

Jim

 

[Jeff Boyce]

Jim

Think of the report generator as a template. If you feed it a single
record, it prints that record (this is like your single student).

But if you feed it a list of students' information, and you tell it to use
one page per record, you'll get multiple report pages, one per student.
You'll need to tell the report definition to start a new page after each
record.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jim Williams]

I can definately see that. Perhaps I'm doing this wrong. What I have
done is created a query that pulls all of the information that I need
for the report... (name, contact info, courses taken, when the course
test was returned to us, and the score) then using the Wizard, I told
it to give me a count of [score] and the average of [score].

I tried just taking the prompt for Employee ID out, but that then put
all of the scores for all students on the first student. Oops.

I also tried telling it to force a new page after the [emp_id] footer
section in my alternate layout (I copied the individual report as a
base to start after the wizard idea didn't work right).

I'm relatively new with Access - I wasn't much of a DB person, but I
stepped up to help get this off the ground.

Again, thanks for any help...

-Jim

 

[Jeff Boyce]

Basing your report on a query, good step!

In the report design mode, click on the Detail band (the word Detail and the
band should highlight). Right-click on this highlighted band, select
Properties.

Find the "Force New Page" property and look at the choices. I'll guess
you'll pick "After Section". This should start a new page with the next
group of Detail info.

If you have put the student info into a different band (i.e., not "Detail"),
do the above for THAT band instead.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I can definately see that. Perhaps I'm doing this wrong. What I have
done is created a query that pulls all of the information that I need
for the report... (name, contact info, courses taken, when the course
test was returned to us, and the score) then using the Wizard, I told
it to give me a count of [score] and the average of [score].

I tried just taking the prompt for Employee ID out, but that then put
all of the scores for all students on the first student. Oops.

I also tried telling it to force a new page after the [emp_id] footer
section in my alternate layout (I copied the individual report as a
base to start after the wizard idea didn't work right).

I'm relatively new with Access - I wasn't much of a DB person, but I
stepped up to help get this off the ground.

Again, thanks for any help...

-Jim

Jim

Think of the report generator as a template. If you feed it a single
record, it prints that record (this is like your single student).

But if you feed it a list of students' information, and you tell it to
use
one page per record, you'll get multiple report pages, one per student.
You'll need to tell the report definition to start a new page after each
record.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jim Williams]

Got it! Now I understand. You have to tell it to force the new page
*above* where the data is located. Now it works exactly the way I want
it to.

Between this newsgroup, Access 2000: The Complete Reference (I'm the
last PC in the department who doesn't have Access 2003), and mvps.org -
I've put out a product that my boss is EXTREMELY impressed with. I'm
sure that there are all sorts of things that I could do better, but for
my first real dive into databases, I'm pretty stoked. As a matter of
fact, its got me thinking 'what else can I put into a db'...

Thanks for your help, I'm no longer pacing the floor tring to noodle
this one out.

-j