Combining Two Fields

[syncdba]

Is there any way in CRXI I can combine 2 fields.
ID MONTH QUARTER FINAL
-- ------ ------- -----
1 Jan2005 Q1 Q1
Jan2005
2 march 2006 Q2 Q2
March2005
3 July2006 Q4 Q4
July2006
I want FINAL column as Parameter field.

 

[Turkbear]

Hi,
Please explain what you mean by 'combine' and how it relates to using the FINAL column as a parameter ?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[syncdba]

I'm trying to create 1.parameter field which will ask "Quarter or Month"
If Somebdy picks "Quarter" then In next parameter field he will pick "Q1,Q2,Q3 or Q4" But if somebdy picks Month then he has to pick "Jan2005,feb 2005.." from 2nd parameter.Table is using has
ID Month Quarter FINAL
-- ----- ------- -----
1 Jan2005 Q1 Q1
Jan2005
2 march 2006 Q2 Q2
March2005
3 July2006 Q4 Q4
July2006
So,FINAL column has Quarter Column Value then Month Column value. FINAL Column will be used as parameter field.
I'm not sure if its possible.
In Simple I'm trying to create parameter fields.
Parameter1 will have 2 things to pick(Quarter or Month)
& then the o/p of parameter2 will depend on parameter1.
I hope this info will help u.

 

[syncdba]

OR is there any way I can create something similar to list of values (which are used for Dynamic prompt) for Staic Prompts or May be any formula