Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cascading parameter and report selection

Status
Not open for further replies.

RCCRookie

Technical User
Jul 3, 2007
29
US
Crysta XI; SQL 2000 DB
I have a cascading Country, State, City parameter and haven't been able to figure out how to account for instances when there is no state or city. My selection formula follows:
{SUPPLIER_MNT_V.COUNTRY} = {?Country/State/City - COUNTRY} and
{SUPPLIER_MNT_V.STATE} = {?Country/State/City - STATE} and
{SUPPLIER_MNT_V.CITY} = {?Country/State/City - CITY}
I tried to include isnull before {SUPPLIER_MNT_V.STATE},{SUPPLIER_MNT_V.CITY} but that didn't work. If I run the parameter without a state or city I get the following error message:
Prompting failed with the following error message:'List of Values failure:fail to get values.[Cause of error: Type mismatch]'. Error source: prompt.dll Error code:0x8004380D

I'd appreciate if someone could point out the obvious (except to me) flaws in my plan.
 
In XI, you must have a value for each parameter, and I don't think there is a way to allow null or blank values in a cascading parameter.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top