Parameter/Default Values 1

[LizRCD]

Crystal 10 & SQL 8

I am creating two parameters in a report. The first is a customer name. The second is a order name.

I select the table and then the field within that table and I get all my customer names returned. But when I go to my order name field within the same table, Crystal returns a limited amount of order names.

Thanks for your help.

 

[synapsevampire]

It does have a default limitation, and keep in mind that it isn't dynamic in CR 10 and below, so once populated it won't be updated until you repeat the process.

Here's how to increase it:

http://support.businessobjects.com/library/kbase/articles/c2014948.asp

-k

 

[kskid]

Some sample data and expected output would provide a little more insight into the problem. What's in your record selection or formula that uses the parameters?

On the surface, the output is dependent on how you have the record selection set.

{table.customername} = {?customername} and
{table.ordername) = {?ordername}

This assumes that the order name is directly related to the customer name. Whereas

{table.customername} = {?customername} or
{table.ordername) = {?ordername}

gets me every row that has either value.

Cheers,
-LW