<html>
<body>
I have a problem with a report in an AXP/SQL2K database.<br><br>
I have a button on a customer form which is supposed to open up a report
with just the current customers information on it. In the
OpenReport statement I send the inputParameters via the OpenArgs to the
report and then in the report's Open event set me.InputParameters =
me.OpenArgs.<br>
The main report sproc then uses the InputParameters to select the
correct record (theoretically).<br><br>
But I must be missing something because even though the inputparameter
property is being updated, the sproc is not using the information to
retrieve the correct data. Here is the main parts of the sproc
-<br><br>
<font face="Tahoma">ALTER PROCEDURE sprptAccounts<br><br>
<x-tab> </x-tab>(<br>
<x-tab> </x-tab><x-tab> </x-tab>@txtCustID
int,<br>
<x-tab> </x-tab><x-tab> </x-tab>@StatementNumber
int<br>
<x-tab> </x-tab>)<br><br>
AS<br>
<x-tab> </x-tab> SET
NOCOUNT ON <br>
<x-tab> </x-tab> <br>
<x-tab> </x-tab>SELECT
tblCustomers.CustomerID, tblCustStatement.StatementID, <br>
<x-tab> </x-tab><x-tab> </x-tab>case<br>
<x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab>when
[Residential]=1<br>
<x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab>then
[CSurname] + [C1stName]<br>
<x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab>else
[TradingName]<br>
<x-tab> </x-tab><x-tab> </x-tab>end<br>
<x-tab> </x-tab><x-tab> </x-tab>AS
SortName, tblCustStatement.SMName, tblCustStatement.SMAddress1,
tblCustStatement.SMAddress2, <br>
<x-tab> </x-tab><x-tab> </x-tab>tblCustStatement.SMSuburb,
tblCustStatement.SMCity, tblCustStatement.SMPostCode,
tblCustStatement.SAccountNo, <br>
<x-tab> </x-tab><x-tab> </x-tab>case<br>
<x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab>when
Not ([PrevStatementDate] is null)<br>
<x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab>then
DateAdd("d",1,[PrevStatementDate])<br>
<x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab>else
[PrevStatementDate]<br>
<x-tab> </x-tab><x-tab> </x-tab>end<br>
<x-tab> </x-tab><x-tab> </x-tab>AS
StatFirstDate, tblCustStatement.StatementDate,
tblCustStatement.StatementNumber, tblCustStatement.CurrentMth, <br>
<x-tab> </x-tab><x-tab> </x-tab>[OneMonth]+[TwoMonths]+[ThreeMonths]
AS Overdue, tblCustStatement.OneMonth, tblCustStatement.TwoMonths, <br>
<x-tab> </x-tab><x-tab> </x-tab>tblCustStatement.ThreeMonths,
tblCustStatement.ComBondBal, tblCustStatement.Processed,
tblCustomers.AccStatus, tblCustomers.AccFreq,
tblCustStatement.DDRegistered<br>
<x-tab> </x-tab>FROM
tblCustomers INNER JOIN tblCustStatement ON tblCustomers.CustomerID =
tblCustStatement.CustIDNo<br>
<x-tab> </x-tab>WHERE
(tblCustomers.CustomerID = @txtCustID) and
(tblCustStatement.StatementNumber = @StatementNumber)<br><br>
<br>
</font>The call to open the report is -<br>
DoCmd.OpenReport "rptAccounts", acViewPreview, , , ,
"@CustID int = " & txtCustIDNo & ",
@StatementNumber int = " & txtStatementNumber<br><br>
An example of the openarg sent is -<br>
@CustID int = 773500661, @StatementNumber int = 11<br><br>
The report's Open event is<br><br>
Private Sub Report_Open(Cancel As Integer)<br><br>
Me.InputParameters = Me.OpenArgs<br><br>
End Sub<br><br>
Am I going about this all wrong? <br>
<x-sigsep><p></x-sigsep>
Regards<br><br>
David Emerson<br>
DALYN Software Ltd<br>
25b Cunliffe St, Johnsonville<br>
Wellington, New Zealand<br>
Ph/Fax (877) 456-1205</body>
</html>