how to pass information to subreport and main report

I have a infinite campus subreport that i need to pass information to. The information for the report is retrieved using sql. I would like to pass the studentid from the sql command on the main report to my subreport called Comments in crystal reports.

Also, Im trying to pass the current year to main report in the report card. Note: I cant use subprocedures because i dont have the privileges to create anything on the sql server.

Edited by: jeffman2 on Sep 15, 2011 7:48 PM