Record selection formula

[nikol]

I have a report with record selection formula"
if {?my Parameter} = 'All Cities'
then
1=1
else
{command.name} = {?my Parameter} "
& a dynamic parameter list of cities as
AllCities
SJ
SFO
SC
SA ...
This report has grouping on gender like Female 5
Male 7 according to cities. When I refresh my report & select "allcities" it gives me nothing but works fine if I select particular city like SJ or SC.
I have wriiten
{
select uid, list_id,
case
when (uid=11 or uid=12 or uid=13 or
uid=14 or uid=15 or uid=16 or uid=17 or uid=18 or uid=19
or uid=20 or uid=21 or uid=23 or uid=24 or uid=26) then 'All Cities'
end name
from picklist_values
where list_id=2
}
SQL query to get "allcities "row .
I have selected "name" column for subreport links.

Is there any way to write new record selection formula
which will give total number of clients in "allcities"
grouped by gender LIKE

INTAKE 18 FEMALE 8
MALE 10 (In ALL CITIES)

 

[TheBlondOne]

Have you tried removing the gap between All Cities in your record selection or was this a typo?

if {?my Parameter} = 'AllCities' then true else etc...

-Steve


"if at first you don't succeed, sky diving is not for you"!!! )