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

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?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.

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.
zrodAuthor Commented:
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
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

HOw are you running the report?

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

zrodAuthor Commented:
the reports are launched from the application,  
this flag seems interesting to consider.
can you help having some documentation on how to set it.
As I recall it was

rptObj.EnableParameterPrompting = False


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.