Link an element to another report

[newer]

Hi all,
I'm so new about this product, and recently, I'm working on a project that buils reports for students and get stuck at this point. Please help. The idea is that if a report a displays all student ID, and courses, then in that report, I want to give the user option to click on any student ID to go to a report that contains information about that selected student. How do I do that?
Here is an example:
Report 1: Student and Course
Student ID Courses
********** *******
000001 MIS
000002 MIS
000003 CIS

Say, if some one wants to know information of student ID 000001, he/she just clicks on that ID then it display a report (report 2) about this student and only that student.

Report2: Student Info
Student ID Courses PercentFinish Score
000001 MIS 50% 70

That's the idea. Please help.
Thank so much

 

[kenhamady]

You may want to try drill down or an On-Demand Subreport, linked to the student ID.

Drill down will work for a simple report. If you group on Student ID and hide the details, when you double click on the Student ID in the header it will drill down and show just those details.

If you need a more sophisticated report to appear you should read the help on subreports so that you understand the relationship between subreport and container report. Here is how you create a linked on-demand subreport.

1) Create the container report, which is the primary report.

2) Create a separate report that looks like the report you want to appear on a double click.

3) In the second report create a prompt so the report asks for a student ID, and only selects that student. This is a "parameter field".

4) Open the container and use "Insert Subreport" to import a copy of the second report into a section of the container that appears once per student (Student Group header/footer or details).

5) Last, use the "subreport links" to link the container field "Student ID" to the parameter field in the subreport.


If you are really new you should spend a few minutes reading the help on all of the topics that I have mentioned here in quotes. [sig]<p>Ken Hamady-

http://www.kenhamady.com<br><a

href=

http://www.kenhamady.com/>Crystal

Reports Training by Ken Hamady</a><br>[/sig]