suppose there are 15 countries like (US, UK, ENGLAND,INDIA,JAPAN.......)i want

suppose there are 15 countries like (US, UK,
ENGLAND,INDIA,JAPAN.......)i want a value prompt in the
report and this value prompt should contain groups like
group1(US,UK,ENG), group2(INDIA,US,UK), group3
(ENG,JAPAN,INDIA)and in the value prompt the values should
be group1,group2,group3 how can we do this?

Question Posted / vijay

4 Answers
7889 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

suppose there are 15 countries like (US, UK, ENGLAND,INDIA,JAPAN.......)i want a value prompt in t..

Answer / abhay puranik

Create a query,drag the Country column,Drag data item from
the tool,name this as Group,Now in the expression
corresponding to this data item,write if(geography contains
('','','') then 'Group1' elseif(Country contains('','',''))
then 'Group2'......And use this query for the query
property of value prompt and use Group as column diplayed
under value prompt.Now,in filter for the main page use if
(Group='Group1') then (Country in ('','','')) else
if.....save report and run.

Is This Answer Correct ?

4 Yes

2 No

suppose there are 15 countries like (US, UK, ENGLAND,INDIA,JAPAN.......)i want a value prompt in t..

Answer / poorna chandra reddy

Create a data item and in that writ condition like below

if(country in (' US,UK,ENG' , ' INDIA,US,UK'))
then ('Group1')
else if (country in (‘INDIA’,’US’,’UK’)
then ('Group2')
else ('Group3')

Then create value prompt and assign this data item to the
value prompt.

Is This Answer Correct ?

3 Yes

1 No

suppose there are 15 countries like (US, UK, ENGLAND,INDIA,JAPAN.......)i want a value prompt in t..

Answer / balanandam

Abhay ur concept is write, but there is other way to implement this ....

using static choice property in the properties pan u can put the values like Group1, Group2....
and modify the default sql as

if query.country in (?parameter?='Group1')then (Country in ('','','')) else
else if.....then...
else if....then...
else query.country='parameter';

i think this will clear more
save report and run.

Is This Answer Correct ?

1 Yes

2 No

suppose there are 15 countries like (US, UK, ENGLAND,INDIA,JAPAN.......)i want a value prompt in t..

Answer / dhanu

create country prompt with 2 dynamic prompt value dispay
value WESTERN_COUNTRIES>use vale (1)ASIAN_COUNTRIES (2)

u can add more static values if u want.

in report query put filter

write a if statement or case
if (?country?)=1
then country in (USA,UK)
else country in (INDIA, CHINA)

case when ?country? =1
then query.country in (us,uk)
when ?country?=2
then query.country in(INDIA,srilanka)
end

Is This Answer Correct ?

0 Yes

1 No

Post New Answer