Cascading Input Paramters ?

[ricolame]

Hi folks,

Would need so advice on this : I have created an input parameter that do conditionally grouping say, by Part and by Warehouse

Supposed user choose group by Part, I need to have another cascading input parameter that prompts user to enter a part id or say type ALL and it will list just that part, or all the parts in it respectively.

Similarly if the user choose warehouse, then it will prompt
for warehouseid. User has the option to enter just a particular warehouseid or type ALL to list all the warehouses.

Is this possible ? Any quick guidance on this ? Thanks so much!

 

[IdoMillet]

Not possible without a front-end application of your design.

Cheers,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[lbass]

You can approximate this by creating the three parameters, {?Type} (Part or Warehouse), {?Part} with all possible values entered as options and the word "All", and {?Warehouse} with all possible values entered as options and the word "All".

In the record selection formula you would use something like:

if {?type} = 'part' then
(
if {?Part} <> "All" then
{table.partID} = {?Part} else
if {?Part} = "All" then true
) else
if {?type} = 'warehouse' then
(
if {?warehouse} <> "All" then
{table.warehouse} = {?warehouse} else
if {?warehouse} = "All" then true
)

-LB