[dba-SQLServer]Sending parameters to a report

Susan Zeller szeller at cce.umn.edu
Tue Feb 25 13:03:40 CST 2003


Julie,

Bring up the properties sheet on the report and then in the Input
Parameters property, reference your variable and your field such as:

@Term = Forms!frmWiz!subcrit!txtParam_Term, @May =
Forms!frmWiz!subcrit!txtParam_May

Note that I have two varialbes, @term and @May that my sproc needs so
separate by comma.  Also, the textbox I'm referencing is on a subform so
that's why I have Forms!FormName!SubFormNAme!TextBoxName.

Write a stored procedure to use as the record source of the report.
Note that it's easier to set the recordsource of the report to your
sproc in the on_open of the report.  Then, on the report itself, in the
properties window, put the table name in the recordsource slot.  That
way you can see your field names for report design.

--Susan


-----Original Message-----
From: Julie Reardon-Taylor [mailto:prosoft6 at hotmail.com] 
Sent: Tuesday, February 25, 2003 11:04 AM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer]Sending parameters to a report


Susan,

I am trying to do the same thing right now, referencing a field on a
form as 
a "filter" for my report.  Are you placing the input parameter in the 
report?



Julie Reardon-Taylor
PRO-SOFT OF NY, INC.
www.pro-soft.net




_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.  
http://join.msn.com/?page=features/virus

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list