Multiple parameters 1

[shannonlp]

This is a really easy question – I apologize in advance. I’m in crunch and can’t remember how to handle this:

I have a report that I need to set up multiple parameters. I need to set up the parameters so that the user can decide which parameter they want to use.

For example, the report will have a parameter for account, sales rep, product and state. When they refresh the report, they will see all the available parameters but they will likely only want to run it for one. They might want to run it for sales rep and disregard the rest.

How can I set this up to run so that the remaining parameters can be ignored/left blank?

Thanks for any help,
Shannon

Crystal XI

 

[Turkbear]

Hi,
Set Default valuse for each parameter ( usually ALL for Text and 0 for numbers) and use your record selection formula to test and use as needed, like:

(
(If {?param1} = 'ALL' Then
True
Else
{table.sometextfield} = {param1})
)
AND
(
(If {?param2} = 0 Then
True
Else
{table.somenumberfield} = {param2})
)

Repeat as needed...






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[shannonlp]

Thanks - do I need to set the default for each of my parameters fo ALL?

 

[Turkbear]

Hi,
Crystal ( especially the later versions) hates blank parameters - Use a default ( ALL or 0 ) to avoid problems
and unwanted prompting.



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[shannonlp]

Thanks again - I will save this so I never have to post this question again.

Shannon