Solved

CRYSTLE REPORT STORED PROCEDURE PARAMETERS

Posted on 2001-06-11
4
411 Views
Last Modified: 2012-08-14


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
0
Comment
Question by:dataplus
  • 2
4 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 40 total points
Comment Utility
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
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
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
 
LVL 12

Expert Comment

by:DRRYAN3
Comment Utility
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
 

Expert Comment

by:ComTech
Comment Utility
Question accepted by:

Thank you,
ComTech
Community Support Moderator

 

0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This video discusses moving either the default database or any database to a new volume.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now