Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tad
Starting Member
31 Posts |
 Posted - 2002-08-21 : 14:18:01
|
| When I run the report I'm always prompted for the parameters of the stored procedure. The gSite_no and gUser variables are global and set when the user logs into the app.There is a master report with three sub reports. The open events are all the same except the sectionname parameter is different for each. On sub reports, I can't change the recordsource during it's open event. Private Sub Report_Open(Cancel As Integer) Call MyScreen.FormatMilitaryDate(Me.RESULT_DATE) Me.InputParameters = "@pSite_No = " & gSite_No & " , @pUser_ID = " & gUser & ", @pSectionName = 'MASTER'" Me.RecordSource = "dbo.spLIMS_LotResultReport"End SubNeed suggestions.Thanks. |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-08-22 : 00:42:21
|
| Apparently the stored procedure aren't getting the parameters. You may want to post this on a MS Access site. Most people here don't use Access much. |
 |
|
|
|
|
|
How do I use the reports inputParameter