input parameter

[wd1153]

Hi, I am trying to use a stored procedure with input
parameters for a report in ADP. Since the parameters are
only known at run time, i tried to set
the 'inputparameter' at the run time in VB code. But it
appears that ADP did not take into consideration of it
when show the report. Anyway to work around it? thanks a
lot.

 

[Gary Miller]

I would highly recommend thinking out your question in a bit
more detail. You need to be able to read it yourself and be
confident that a stranger would understand all the
complexities and have all the details needed to provide a
solution. This post is so vague that I think people may be
skipping by it.

Repost with a little more detail.

Regards,
--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[wd1153]

Sorry that i did not make myself clear.
Basically, in Report_Open sub, I am trying to set:


Private Sub Report_Open(Cancel As Integer)
Me.RecordSource="stored_procedure_Name"
Me.InputParameters= " @Para= " & strpara
'strpara is a long string delimited by comma,and
'is declared as global which had been
'defined in other modual
End Sub

When I run it, it runs into error as the "@Para" is
required at server side by the stored procedure, which
means the adp never pass the input parameter to the
server.
I could pass sql string as RecordSource, but the store
procedure takes care a lot of other things on SQL server;
plus, the comma delimited string of the parameter could be
as long as over 2000 chars. The store prcedure will parse
through the string and return according recordset.
I wish I am making sense here. thanks alot