| :: Creating a new report on the fly :: show all messages | Post a New Message | Post a Reply |
 Re: Creating a new report on the fly | Post a Reply |
from: Washington, DC
AddHiddenSqlFilter method of the report wizard to filter the results for your reports. i.e. You can create one report for every school/teacher and when the user logs in, the
AddHiddenSqlFilter method can be used to filter their report as follows:
Dim strSchoolName
strSchoolName = Session("SchoolName") ' or Request("SchoolName")
objWiz.AddHiddenSqlFilter("Students", "SchoolName='" & strSchoolName & "'")
objWiz.Init(Connection String)
For more information on methods and properties, please check our online manual at the link below:
http://aspwebsolution.com/products/report_wizard/api_wiz.htm
Let me know if this is the solution the problem.
thanx!
-------------------------
Ghost