Solved

Crystal Report Parameter Values

Posted on 2014-04-02
9
1,405 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 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: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 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
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 

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

Gigs: Get Your Project Delivered by an Expert

Select from 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

Suggested Solutions

Title # Comments Views Activity
[NotSupportedException: Not supported within subreports.] 2 70
Speed Up Crystal Report 5 54
Bulk Update Crystal Reports 2013 SP5 Data Source 2 47
Mask on Parameter CR2008 28 51
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 …
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

776 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