how to simulate subreport of a subreport 1

[kken]

I created a report (report1) that would get data based on 1 student. This report had subreports for the 1 to many relationships such as last login and max score.
Then I tried to create a report (report2) to run through all students. I used the previous report (report1) as a subreport. Everything works great except for the subreports in that report.
Is there any way to get data based on 1 activity which may be one of 20 records in the subreport or put another way a subreport of a subreport.


Thank you ken

 

[balves]

Aren't you making things complicated?

Your main report gets all of the students. In the detail section, where you display each student, you have sub-reports that show the other data for that student.

 

[kenhamady]

Take your original report, run it for all students (not just one) and group it by student ID. Then put the subreports into the Group footer. So they run for each student. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[kken]

Hi: kenhamady and balves
Thank you both for your reply. I know it is little complicated balves, but I do not think there is an easy way to do it.
Gouping is something I had not thought of probably because I don't do it much. ken When you say Take your original report, run it for all students (not just one), do you mean do not use it as a subreport. I usally have a subreport for my 1 to many relationships.
The main report runs through each student. The first subreport gets info on one 1 to many relationship. The second subreport gets information on another 1 to many relation ship. Having the info line up propperly is one problem. The second is I need the max for each activity not each course. Without a subreport it wants to give the max for the course.

 

[kenhamady]

Forget report2. Run Report1 for all students, but group it by student. Then put the subreport in the Group footer so that it runs for each student separately.

Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[kken]

Hey ken:
Just wanted to drop a line to let you know the grouping is working really well. I haven't got all the bugs out yet but close.


Thank You