Prompts - Create a decision prompt and based upon the response provided give other prompts

Hello,  
I will try to be clear on what I would like to do.  Is it possible to have Crystal Reports provide one prompt and based on the response of that prompt, ask the user for other prompts (or at least) have the cursor go to the correct prompt.  For now, what is happening, no matter how I answer, the first (deciding prompt), ithe cursor skips the next prompt and goes to the third prompt in the list of prompts.  The following is at the record level:

if
uppercase ({?Decision Prompt})<>'YES'
then
{EVAL_DATA.UPDATED_ON} >= {@FirstDate}
and
{EVAL_DATA.UPDATED_ON} <= {@SecondDate}
and
{?User ID}={EVAL_DATA.UPDATED_BY}

else

if uppercase ({?Decision Prompt})='YES'

then

{?Class Number}= {EVAL_DATA.NO_SCH}

The decision prompt is Yes or No

If the reply is Yes
I would like the cursor to go to the class number prompt space and ignore the other spaces.

If the reply is No
I would like the cursor to go to the firstdate prompt space, then go to the seconddate prompt space, then go to the UserID prompt space and ignore the prompt for class number.

Or, should I create the one prompt (expecting answer yes or no) and direct it to a sub report?  What can I do please?  Thank you.
mtroutAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

mlmccCommented:
I don't know of a way to use the Crystal prompting and get what you want.

You are basically looking for a cascading prompt but it isn't based on the same field.

The only way I can think to do this is to write your own application to accept parameter values and prompt as you want it to.

mlmcc

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
mlmccCommented:
Unless you have CR2008, you would still have to provide values for all the parameters.

mlmcc
mtroutAuthor Commented:
This is not a bad grade.  This is the best answers based on the information given.  This is just the functionality of of Crystal XI at this time.  Would not know how to write my own application to accept parameters.  I don't think that it's fair to ask how to do this, but I'm sure that this response will be just the right hint for a person who is familiar with APIs.
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.