?
Solved

Crystal Report Parameter Values

Posted on 2014-04-02
9
Medium Priority
?
1,429 Views
Last Modified: 2014-04-15
I have a crystal report that I need to pass the values to its parameter programmatically, what's the best / most-optimal way to do that?
Thx
0
Comment
Question by:Roberto Madro R.
  • 5
  • 4
9 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 39973257
I don't think there is really a "best" way to do that.

The best way to handle this, in my opinion, is to build the report to use a dataset and have the application open the dataset and pass the data to the report.  This is known as the push method.

If you pass the parameters to the report it is using the pull method which has many more pitfalls.

Here is an example of using the push method
http://www.emoreau.com/Entries/Articles/2006/09/Feeding-Crystal-Reports-from-your-application.aspx

If you need to pass the parameters
What version of Crystal?
What method are you using to open the report?
What language are you using for the application?

Perhaps the easiest method is to just call the report and let Crystal prompt using the default parameter screen

mlmcc
0
 

Author Comment

by:Roberto Madro R.
ID: 39973525
Great to hear from you mlmcc, I'm using Crystal 11.5 and I publish these reports to a crystal report server and they're accessed by users via our intranet (website-like access), as for what application I need to embed this report in, I can do asp or c#, but I need to know how to embed an existing report and supply its parameter with values when it's run or is scheduled to run.

Thanks for the link as well, (although old) a very interesting walkthrough.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 39973541
Even though it is a bit old, it is still accurate on how to do it.

If you are publishing through CR Server why the need for an application?

mlmcc
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:Roberto Madro R.
ID: 39973552
I'm exploring what CR Server offers in that regard, I'll write you back on what I find.
0
 

Author Comment

by:Roberto Madro R.
ID: 39973593
On the CR Server, under the "Process" tab, you have the option to set a DEFINED VALUE for the parameters, from there, every time the report runs it'll take these values into account, but the issue is, and in my case here, the parameters I have are date parameters and I need to supply them with dates, example (currentdate -5 to currentdate -1), something like that.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 39973611
Unfortunately, as far as I know, you can't do that.  I know with the BOE product you can't.  CR Server is a scaled down version of it.

We got around that issue by coding those kind of date ranges into the report.

If you want flexibility to use a range like that by default and also allow the user to input a range of their own you could set the default value for the dates to be 1/1/1900 then test for that value in the selection.

Something like

If {?StartDate} = Date(1900,1,1) then
    {DateField} >= CurrentDate - 5  AND {DateField} <= CurrentDate -1
Else
    {DateField} >= {?StartDate} and {DateField} <= {?EndDate}

mlmcc
0
 

Author Comment

by:Roberto Madro R.
ID: 39976127
Have you ever called a Crystal Report from command line? and if so, were you able to supply its parameters?
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 39976295
Crystal Reports doesn't have a command line option.

There are third-party tools that allow you to call them from the command line and pass parameters.  Kenn Hamady maintains a good list and includes a review

http://www.kenhamady.com/bookmarks.html

mlmcc
0
 

Author Closing Comment

by:Roberto Madro R.
ID: 40001918
Great tools and resources website, and although I know Ken Hamady, the links you provided were of great help. The request for automating that report has changed, but the fact that I'm aware of this resource now is great.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses

809 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