AspWebSolution Forums » Products » ASP Report Wizard v2

index | search | no replies | posting guidelines | help

» »

:: Creating a new report on the fly :: (2)

Oct 21 2005, 11:04 AM

Creating a new report on the fly

jrshelton

since: Oct 21, 2005
from: Abingdon, VA Hello. We are currently using the Reporting tool with our online course registration application. With this application teachers can enroll their students for various classes within our network. To use the application a registration process, where username and password are assigned, is required. We use the reporting tool for teachers to login to an administration area and see a detailed report of their students information. Currently we are having to create each school's report manually. Each of these reports are basically the same, except the WHERE clause will be the associated School or Course name. I was wondering if there is any way to create the report automatically when they register to use the enrollment application.

An example of the generic SQL statement would be: SELECT StudentFirstName, StudentLastName FROM Schools WHERE SchoolName = "This School'

'This School' would be the item that is dynamic according to the users registration.

Oct 21 2005, 3:45 PM

Re: Creating a new report on the fly

Post a Reply

ghost

from: Washington, DC I'm not sure I've completely understood your question but I think you can use the 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

Pages: (1) [1]