I hope I can get help.  A little background: work for a school where students that are sent by their Companies need to sign a sheet to show attendance.  We have already over 100 Companies.  The students come at diff schedule to diff classes.  We have the possibility of 50 classes/schedule combination.

 

some co send us 60 students, others 20 students, others 1 or 2.

 

Classes last 6 weeks = 30 signatures per student.

 

Using Access, VB & Crystal I created a signing sheet for @ co for @ schedule for @ class.  Nice, but wasting too much paper for those co that only have 1 student in the class as I would need 6 sheets for that one student.

 

I want Crystal to reprint my report in the same page as many times as it fits.  ie:

 

classroom:  A-1                    level: I

teacher: Mr Jones                start date: Jan 05/09              

Time: 8 - 10                         end date:  Feb 13/09

                                                                         Week 1 Signatures

Signatures for ABC Company        Day1                                   ..... Day 5

Ms Jones            

Ms Joneses 

-------------------------------------------------------------------------------------------

Now I want that repeated

-------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------

And I want it repeated again if it fits in the 8 1/2 by 11 pages.

 

 

Please tell that it can be done...and please tell me how

 

thanks

Me-Keys

 

Group1 by Course.  Put course information in the group header section.

Group2 by Company.  Put company information in the group header section.

Put names in Details section.

 

If you want a line between companies, put a line in the Company group footer section.

 

If you want to print multiple courses at the same time, go to the Section Expert for the Course group footer and check "New Page After" then click on the button to the right of the check-box and type: "Not OnLastRecord"  (without the quotes - this prevents a blank page at the end of the print.)

 

-Dell

 

But I am still not clear.

 

I have been able to get the report to run, but not able to duplicate or triplicate (if such word exists) the exact same data on the same page.

 

I want to print the same headers info and details info as many times as it fits on the page. 

 

Can this be done by Crystal ?

 

Thanks

 

 

if }condition} then

true

else

false

 

 

I hope this is what you wanted.

 

 

Do not forget to mark it answered if it is.

 

You'll have to set up a running count of the details records (reset for every group) and then figure out how that record count relates to how many subreports you need.  For example, it may be that if you have 3 attendees you can fit 3 sets on a page but if you have 4 you can only fit 2.  Once you have that figured out, you can suppress the appropriate sections based on the number of records.  For example, assuming the running count is named {#RecordCount} and using my example above, the suppress formula for the second sub report (the third copy of the data) would be something like:

 

{#RecordCount} > 3

 

-Dell

 

Dell, I think you understand what I need.  uff!, its hard to explain. 

 

I tried your solution.  I created my main repot and a sub repot.  Just one to test, and insertted the sub into one of the group footers.

 

It brings in my sub rep, but it prints ALL the data for ALL the Companies, not just the one that it printed first at the top of the page (from the main report).  And I never saw it return to the main report :(

 

I am not sure if there is a way to pass a filter to the sub report so I get the exact same data just for that company, and then come back to the main report to continue with the next Company and then go off again to the sub-report.

 

Any idea?..Do you follow?

Could be I missed something.

 

thanks

 

Right-click on the subreport and select "Subreport Links".  In the top part of the screen, select  the Course id from the main report (or whatever field you're grouping on for the course) and in the bottom select the corresponding field in the subreport.  Do the same for the company identifier.  This will automatically set up a record filter in the subreport so that you should only get the data for the course/company combination from the main report.

 

-Dell

 

-Dell