View Full Version : pass form parameter to Sp to Run the the report


naina
04-26-2010, 12:51 PM
I have a parameter form to populate the report, report control source "Stored procedure", Form has 3 control and one click event as well as as Set on form’s AND Report's Input parameter property is @UID=Forms!RPM_Audit_Trail!CboUser,@SDate=Forms!RP M_Audit_Trail!TxtSdate,@EDate=Forms!RPM_Audit_Trai l!txtEdate
And My Stored procedure is

CREATE PROCEDURE dbo.Sp_UserActivity

@UID INT , @SDate Datetime , @EDate Datetime

AS SELECT dbo.AuditTrailT.AuditiD, dbo.UserT.FullName + ' [ ' + dbo.UserT.LoginName + '] - ' + dbo.DepartMentT.DepartMent AS UserDetails,

dbo.AuditTrailT.EventDate, dbo.ATrailEventT.EventType, dbo.AuditTrailT.ObjectiD

FROM dbo.DepartMentT RIGHT OUTER JOIN

dbo.UserT ON dbo.DepartMentT.DepartMentiD = dbo.UserT.DepartMent RIGHT OUTER JOIN

dbo.AuditTrailT ON dbo.UserT.UseriD = dbo.AuditTrailT.UseriD LEFT OUTER JOIN

dbo.ATrailEventT ON dbo.AuditTrailT.EventObject = dbo.ATrailEventT.EventID

WHERE UserT.Userid=@UID AND dbo.AuditTrailT.EventDate BETWEEN @Sdate AND @EDate

GO
Here is the form's click event

Private Sub BtnPrint_Click()
DoCmd.Close
DoCmd.OutputTo acOutputReport, "rptaudittrail", "Snapshot Format", "D:\MyADPProject\App\Reports\rptaudittrail.snp", True
End Sub Problem is when Click the click_event it prompts access default parameter form" enter parameter value". Would you please anyone suggest me , what's wrong with the above scenario or What's missing there . . .(Application Based on A2003 ADP with Sql 2000 Server)