Solved

Crystal Report Parameter Values

Posted on 2014-04-02
9
1,401 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:codedigger
  • 5
  • 4
9 Comments
 
LVL 100

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:codedigger
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 100

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
 

Author Comment

by:codedigger
ID: 39973552
I'm exploring what CR Server offers in that regard, I'll write you back on what I find.
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 

Author Comment

by:codedigger
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 100

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:codedigger
ID: 39976127
Have you ever called a Crystal Report from command line? and if so, were you able to supply its parameters?
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 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:codedigger
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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 …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

706 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

18 Experts available now in Live!

Get 1:1 Help Now