Pass Parameter to Crystal.....

I would like to pass parameter into crystal report without prompting to user.I mean from frontend(e.g. Clarify)if user select 1 option out of 3.With that option i want to pass some value as "Concise report" or " Detail Report" to crystal report.And i want to print it at particular place in my report depends on user's selection.How do i do that ?

Thanks for your time in advance.

I am eagerly waiting for your reply.

Thanks,
bhavesh55
bhavesh55Asked:
Who is Participating?
 
SergeDymkovCommented:
Or you can use Crystal Report OCX that comes with VB (so it doesn't matter what version of CR you have). Let's say I have a report which based on a Stored Procedure. This Stored Procedure has one parameter:

    With CrystalReport1
        .Connect = "DSN = MyDSN;UID = UserName;PWD = Password;DSQ = DatabaseName"
        .RetrieveStoredProcParams
        .StoredProcParam(0) = "2"
        .Action = 1
    End With


Note that I pass 2 as a string. Cyrstal Reports will expect all parameters as a string, although it knows their real data types.
0
 
RKMAGICMANCommented:
What version of crystal are you using?
I have the answer but I may only be valid for crystal 7.
0
 
renga_tCommented:
Use "ParameterPromptingEnabled" property of the object "CRPEAuto.Report" and set the value to false for not prompting for parameters.
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.