report followed by report

[gc3]

I'm learning - so bear with me.
I am trying to create a report (using the wizard) that will print every record from query and then print a single record from a table.(but eventually all records from that table on seperate pages)

I am putting the first query in the detail section. i then visually see all of the records in the printed report.

but i then add a subreport, in the detail section, to get a record from a table. the result is only 1 record from the first query followed by a record from the table.

any suggestions?

 

[GShen]

You are probably better off making them both sub reports on 1 Main report. Have the main report be unbound. (eg. no query). Then have the 2 subreports do as they may.

Remember when... everything worked and there was a reason for it?

 

[gc3]

thank you for the help so far! - Tried your suggestion. It works except in the second sub report i want each row (or record) to be on it's own page (with the entire first report repeated on every page.


it would display as follows
subreport 1 ----
record 1
record 2

subreport 2 ----
record 1
NEW PAGE
subreport 1 ----
record 1
record 2

subreport 2 ----
record 2
NEW PAGE
etc.

i tried the page break in the second sub report and it breaks each page as should, when viewing the the subreport. but when i create the unbound main report with the 2 subreports it no longer page breaks. it just adds a space and continues printing the second subreport. it also does not repeat the first sub report on the next page.

 

[GShen]

Sorry, now you have me a little confused. Can you please give me an example of how YOU WANT IT look ? Is the following what you want ?

Report 1 (All)
New Page 1 record (report 2)
New Page Report 1 (All)
New Page next record (report 2)
New Page Report 1 (All)
New Page next record (report 2)
etc.

IF that is the case, put the 2nd report as a sub report on the 1st sub report.

So you will have a main report. Within it, you 1st subreport in which everything will print, within this sub report add your 2nd sub report.

If I am misunderstanding you, then give me an example, please.

Remember when... everything worked and there was a reason for it?

 

[gc3]

your example is close

Report 1 (all)
1 record (report 2)
new page
Report 1 (all)
next record (report 2)
new page
Report 1 (all)
next record (report 2)
new page

The key is getting Report 1 (all) and next record (report 2) to be on the same page

let me know if this helps or if you want me to provide the actual info of each report

 

[GShen]

Ok, sort of back to square 1.

You want.
report 1
report 2 1st record.

Report 1 (On NEW PAGE)
report 2 2nd record.

etc.

What query is driving the 2nd report to print only 1 record at a time and to print the next record ? So if you have 10 records, you want 10 pages (assuming the 1st report is 1 page and the record from the subreport fits on the same page).



Remember when... everything worked and there was a reason for it?

 

[gc3]

your print/display summary is correct.
there is no query for the report 2. it is being suplied by a table. i could make a query from the table - but it would be all records anyway.

thanks for the help so far! appreciated.

 

[gc3]

got cutoff here -
the plan is to have the 2 nd report determine the number of pages (ie - 10 records=10 pages.) i do not know how/why i would need a query that would poduce one record per page. i think then i would need a lot of reports.

background info
the first query pulls records of kids that scored in the top 3 places. (1st, 2nd, 3rd) this may change to be top five and there are often ties for various placements. - you may have two 1st places, etc. so to say only one 1st, 2nd 3rd will not be ok. Query 1 pulls all of the correct results. (I like to call this the 'winners summary query')

the next step is to show on each page the winners summary query followed by each record (or student) with their results. Every record needs to be printed regardless of their place on their own page. so students can not see the results of the non-winning records.

thanks again.

 

[GShen]

gc3<
I have read your post again.

Not sure what the following means:
1) i do not know how/why i would need a query that would poduce one record per page.
2) Every record needs to be printed regardless of their place on their own page. so students can not see the results of the non-winning records.

I am starting to think the report is not your problem but the way you are retrieving your records. We may be trying to solve the wrong problem. Can you give me some data and show my EXACTLY what you are trying to do.

From what I see, the Summary Report is driven by a query. This report will be static for every student. You then want to print out every student (1 per page) on how they did indivually,with the winners summary for each one. You don't want each student to see how every other student did but himself except for seeing the Winners Summary. Is that correct ?

If that is correct, then why don't you attach the summary report as a subreport to the student report. I think you are doing it backwards.




Remember when... everything worked and there was a reason for it?

 

[gc3]

GShen,
I have done as you suggested - and it is working!!! - after a lot of tweaking, etc.
Appreciate all of the help!!!
I have other issues - but will try and search down already posted stuff before i start asking qustions again.
thanks again.
i also learned that I can put a subreport above the 'main report' stuff in the detail section. learnign this has helped out. i always assumed that the sub report had to go further down the page from the detail 'main report.'

thanks
gc3