Optional Parameters Crystal XI Rev2

[jlr123]

I have two fields that I want users to be able to select either one. Need help to set up.
Fields are: {SO_SalesOrderHistoryDetail.SalesOrderNo} = {?SO#} or {SO_SalesOrderHistoryHeader.OrderDate} = {?Sales Order Date}

Thanks for your assistance.

 

[Charliy]

(if isnull({?SO#} then ({SO_SalesOrderHistoryHeader.OrderDate} = {?Sales Order Date})
else ({SO_SalesOrderHistoryDetail.SalesOrderNo} = {?SO#}))

 

[jlr123]

This does not allow me to enter a Sales Order No.
Thanks.

 

[Charliy]

(if isnull({?SO#} then ({SO_SalesOrderHistoryHeader.OrderDate} = {?Sales Order Date})
else
if isnull({?Sales Order Date})) then ({SO_SalesOrderHistoryDetail.SalesOrderNo} = {?SO#})
else ({SO_SalesOrderHistoryDetail.SalesOrderNo} = {?SO#} and {SO_SalesOrderHistoryHeader.OrderDate} = {?Sales Order Date}) )

This let's you enter either parameter or both.

 

[jlr123]

This is the parameter and it still does not work. I still have to put something in both ranges.

(if isnull({?SO#}) then ({SO_SalesOrderHistoryHeader.OrderDate} = {?OrderDate})
else
if isnull({?OrderDate}) then ({SO_SalesOrderHistoryDetail.SalesOrderNo} = {?SO#})
else ({SO_SalesOrderHistoryDetail.SalesOrderNo} = {?SO#} and
{SO_SalesOrderHistoryHeader.OrderDate} = {?OrderDate}))

 

[pmax9999]

I think the problem you are encountering is that Optional Parameters did not become available until CR2008 (I have XI and they certainly aren't available in that version).

Without the ability to mark a parameter as Optional, the only parameter types you can avoid entering data into are Strings (empty strings are still strings).

The only option you have would be to set the default {?SO#} parameter to something like 0, and the default {?OrderDate} parameter to something like 1/1/1900, and provide instructions to end users to leave the defaults unchanged if they want them ignored.

Your record selection formula would then look like this:

(
	{?SO#} = 0 or
	(
		{?SO#} <> 0 and
		{SO_SalesOrderHistoryDetail.SalesOrderNo} = {?SO#}
	)
)
and 
(
	{?OrderDate} = Date(1900,1,1) or
	(
		{?OrderDate} <> Date(1900,1,1) and
		{SO_SalesOrderHistoryHeader.OrderDate} = {?OrderDate}
	)
)

Hope this helps.

Cheers
Pete

 

[jlr123]

This works but the SO # was a string and I had to set to 'z' default. thanks for your assistance!