CRYSTLE REPORT STORED PROCEDURE PARAMETERS



We are using Crystle reports 6.0 with VB 6.0, we want to
pass two stored procedure parameters FROMDATE AND TODATE

    R.ReportFileName = "E:\PUBSREP.rpt"
   
    R.StoredProcParam(0) = "01/01/1994"
    R.StoredProcParam(1) = "01/01/1995"
    R.WindowState = crptMaximized
    R.Destination = crptToWindow
   
    R.Action = 1

we are getting error INVALID STORED PROCEDURE PARAMETER

any suggessions please

Thanks
LVL 1
dataplusAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
Dates are input to Crystal in a strange format.  I don't have the code here at home but will put it in a comment in the morning.

In my application the dates also required a time.

I see one problem with your code which may solve the problem.  Stored procedure parameters must include the parameter name.  The syntax is something like this

R.StoredProcParam(0) = "FIELDNAME;FIELDVALUE;A third value"

The third value escapes me in what it is for.  I think it is boolean for whether or not to prompt.

R.StoredProcParam(0) = "@FromDate;'01/01/0100:00:00;false"

The syntax for these varies with the connection method and the database.  What are you using?

good luck
mlmcc
0
 
mlmccCommented:
This is from the Crystal Decisions Knowledge Base.  An excellent source of information on Crystal Reports.

http://support.crystaldecisions.net/library/kbase/articles/c2005624.asp

CrystalReport1.StoredProcParam(1) = "1998-01-01 00:00:00.000"

Dates are YEAR-MONTH-DAY HOURS:MINUTES:SECONDS.MILLISECONDS

good luck
mlmcc
0
 
DRRYAN3Commented:
dataplus

Do you require additional assistance, or can you close this question by
1. accepting an answer
2. leave a message in community support asking that it be PAQ'd or deleted (be sure to reference the question ID)

DRRYAN3
0
 
ComTechCommented:
Question accepted by:

Thank you,
ComTech
Community Support Moderator

 

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.