Hi,
Could anyone please explain how exactly does Dynamic Cascading work ? My requirement is I have a report where it should fiter some data from Field A when a parameter is selected as "Y". If the parameter is selected as "N" then no data selection should be based on Field A. I added 2 parameters {Choice} (Boolean, has True or False values) and {Edition Code} (dynamic parameter pointing to Field Edition.code). In the record selection criteria I added this code :
If {?Choice} = True Then
{Edition.code} = {?Edition Code}

However, when I refresh my report the Edition Code parameter always shows up in the parameter window & compells me to enter a value even if I choose {Choice} as False. How do i resolve this problem ? Please help.