i am new to crystal reports using 2008 version. In the page header,i have to display the text "Quaterly" if my parameter PERIOD starts with Q ( i.e., Q12008) and should display "Monthly" if it starts with any other alphabet than Q (i.e., JAN_2008). How do I create a formula for this.
I created a formula and then in the formula tried adding
if [?]P_PERIOD(1)="Q" then "Quaterly" else "Monthly"
where P_PERIOD is the input parameter
it is throwing an error saying
number,currency,amount,boolean,date-time or string is expected here
I dont know how to code this formula.
Please guide me.
Thanks,
Kiran