How to skip parameter prompt in crystal viewer when parameters are optionsl

Posted on 2010-03-25
Medium Priority
Last Modified: 2012-05-09
we have an application calling crystal reports
teh same report can be called from 2 different options in teh application.
option one call the reort by passing param1 and param2
option 2 call teh same report by pasing param 2 and param3

as param1 and param3 are optional, we do not wnt crystal viewer to prompt teh user to enetr theses parameters.
is tehre a way we can do this?
Question by:zrod

Expert Comment

ID: 28544492
Yes but you would need to create a new report, don't know if your willing to do that or not. If you create & use any parameters in a report, you must pass some type of value for those parameters even if they are padded/blank values or the prompt will be displayed. I would suggest just that, passing some type of blank value or a wild card character to be used in those places.

As to design a new report, a way I now prefer. In your front end application design a typed dataset that fits all your table structures for the report. When creating the report(s) design it based on the typed dataset rather then connecting it to a database. Then in the front end you can fill the dataset any way you want and filter it by the user choices and then just pass the filled dataset to the report as its datasource. No parameters needed in the report, it only uses whatever data you pass to it.

LVL 77

Expert Comment

ID: 28544566
If you are using CR2008 then you can use optional parameters.
If it is an earlier version then you have to provide all parameter values.

You would simulate an optional parameter by providing a specific known value  to mean ' no value' and then using a formula field to test for and handle the known value.  Can't be any more specific because i don't know what you are using your parameters for.

Author Comment

ID: 28554532
i am using CR2008, So we are in teh case of optional parameters.
However in this case, if i run a report without passing all optional paraemeters, can i skip the prompt to enter these
[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

LVL 101

Expert Comment

ID: 28583448
HOw are you running the report?

Earlier versions had a flag you could set to stop prompting for the parameters.


Author Comment

ID: 28599944
the reports are launched from the application,  
this flag seems interesting to consider.
can you help having some documentation on how to set it.
LVL 101

Accepted Solution

mlmcc earned 2000 total points
ID: 28603038
As I recall it was

rptObj.EnableParameterPrompting = False


Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Question has a verified solution.

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

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 …
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
If you are looking for an automated solution for backup single or multiple Office 365 user mailboxes to Outlook data file, then you can use Kernel Office 365 Backup & Restore tool. Go through the video to check out the steps to backup single or mult…
Suggested Courses

599 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