Database Newbie - Need helps with Access report format

[Tawcan]

Hi, I'm working on editing an existing database where I need to change the current report layout.

Basically, the database contains bunch records of students such as grades, and which courses they took. Right now I'm working on a report called "APR Report." The repot separates the student data into years and present them on separate pages.

What I want to do now, is to create a new report. On this report there will be bunch boxes. Each box will be linked to the different pages of on the APR Report.

I'm pretty new to MS Access. After reading some manuals and play around in Access it seems that I can do this by using the subreport function. The problem I face right now can be described by the following picture:

Does anyone know how I could get the report to look like what I want? Do I need to go into VB code to do this?

Furthermore, does anyone know how I can change the ratios of the sub-reports so everything can fit on one page? (Assuming that's possible)

Thanx for the helps. Much appreciated.

 

[llkhoutx]

Make each "page" a subreport.

 

[Tawcan]

Make each "page" a subreport.

How do I do that? Please explain.

 

[llkhoutx]

Creater easg page as a separate report. Create a blank report and open in the design veiw, then drag the appropriate page (sub)reports onto it from the database window.

 

[Tawcan]

Thanx for the helps so far. Really appreciate it

Right now the main report is 4 pages or 5 pages (ie 4 years or 5 years). They're separated by a year header. How could I make this main report into 4/5 separte reports?

 

[Tawcan]

Oh a few more things to mention. The main report is not necessary 4 pages. Basically you type a student number and their record would show up. The number of pages is dependent on how many years the student has finished. So sometimes the main report can be as little as 1 page, or as many as 6 pages.

So from you suggestion this is my impression of what I need to do:

1. Create reports that contain different pages of the main report

2. Create a new report and have bunch sub reports on this new report.

3. Link each sub report to the different pages of the main report.

Kinda stuck on step 1 lol~

Is there a way to have just 1 main report but on step 2 you could tell the sub report to open up certain page of the report specifically?


Thanx.

 

[Tawcan]

Help?

 

[KevinM]

Keep the report simple.

If it's to show a Student's progress for each year then use simple report grouping by student and then by year data.

It's no good using a subreport for each year as Students' years will vary from 1-4/5. You will end up with several blank gaps on the report where students of lesser years have no data.

 

[Tawcan]

It's ok to have blank spaces though.

I can't really modify the way the report is arranged now. Basically I need to modify the database so everything shows up on 1 page...

So there's no way I can tell each subreport to link to a certain page on the main report?

Logically all the modification make sense...but doing it is another thing.


Also...another question.

I'm trying to create a report that will show all the "failed courses." I think I need to code in VB to have some sort of database to look through the existing student data table. If the grade is less than 50 or not equal to 'P' the courses get dumped onto the report.

I'm not 100% sure how to do this though. Do I need to create a new table in the process so all the fail courses are listed on this table?

 

[Tawcan]

Hmmm is it possible to use filter to filter out the pages and then display them separately?