Hi,
I'm using 2 static prompts with lovs for
City Initials
---------- ----------
ALL Cities All Initials
Campbell AW
Cupertino BB
Fremont MU
Los Altos IL
Los Gatos PL
Milpitas
Morgan Hill
Mountain View
Palo Alto
San jose
Santa Clara
Saratoga
Sunnyvale
In record selection formula I have
--------------------------------
if {?my parameter 3} = 'All Initials'
then
1=1
else
{Command_2.initials} = {?My Parameter 3} and
(if {?my Parameter 2} = 'All Cities'
then
1=1
else
{command_7.city} = {?my Parameter 2} )..
My problem is that when I select City="campbell" with Initials= "All Initials"
It gives me "all cities" with "all intials" but I want all initials in Campbell city which has 2 initials 'Mu' & 'IL'.
But It works fine for reverse order like.
If I do City="allcities" any Initials="MU"
I gives me only 3 cities which have initials "MU"
Its working one way.Help wanted...
I'm using 2 static prompts with lovs for
City Initials
---------- ----------
ALL Cities All Initials
Campbell AW
Cupertino BB
Fremont MU
Los Altos IL
Los Gatos PL
Milpitas
Morgan Hill
Mountain View
Palo Alto
San jose
Santa Clara
Saratoga
Sunnyvale
In record selection formula I have
--------------------------------
if {?my parameter 3} = 'All Initials'
then
1=1
else
{Command_2.initials} = {?My Parameter 3} and
(if {?my Parameter 2} = 'All Cities'
then
1=1
else
{command_7.city} = {?my Parameter 2} )..
My problem is that when I select City="campbell" with Initials= "All Initials"
It gives me "all cities" with "all intials" but I want all initials in Campbell city which has 2 initials 'Mu' & 'IL'.
But It works fine for reverse order like.
If I do City="allcities" any Initials="MU"
I gives me only 3 cities which have initials "MU"
Its working one way.Help wanted...