I have two question regarding crystal reports which i am viewing through 

*.asp page



1) I am trying to create a formula field and this is what i wrote:  ( i 

wanted to display X on the report if that column is equal is "yes" ..or s 

if it's suspended...and so  forth..the code i wrote below ..doesn't 

display anything on the report..any idea ..why??)



dim m as String

If {tblFile.Nego_AIP_Inprocess} ="Yes" Then 

    m="X"

ElseIf {tblFile.Nego_AIP_Inprocess}="Suspended" Then 

    m="S"

ElseIf {tblFile.Nego_AIP_Inprocess}="Withdrawn" Then

    m="W"

Else  {tblFile.Nego_AIP_Inprocess}="No"	Then 

    m=""

End If





2 question:

i have a report which is landscape. I am displaying 18 fields on it.

13 fields fit perfectly on landscape. the rest 5 fields i just want to 

display on the bottom of the report which will only dipslay if these 

(fields 14 is not empty) fields are not empty...and there is a header for 

these 5 fields...is there a way to display that only when field 14 is not  

blank.....is there a way to do that? 



can you please help me and let me know if there is any solution for my 

probelm...thanksssss so much in advanceeeeeeeeeeee



regards,

Sukhi