My Crystal Report, Prospective Students by Major v5, truncates the Special Field, Record Selection Formula or “Rec Slct Formula:” after “…1.00 AND”. Why? Are there too many characters?
----- Before truncation: -----
{SARADAP.SARADAP_TERM_CODE_ENTRY} = {?Entry Term} AND
{SPRTELE.SPRTELE_TELE_CODE} IN "HOME""MA" AND
{SPRTELE.SPRTELE_SEQNO} = 1.00 AND
{SPRADDR.SPRADDR_ATYP_CODE} <> "PA" AND
{SPRADDR.SPRADDR_ATYP_CODE} <> "GU" AND
{SPRADDR.SPRADDR_SEQNO} = 1.00 AND
----- After truncation: -----
{WLV12HEPC.VAWORDID} = 'MAJ-MIN' AND
{SARADAP.SARADAP_MAJR_CODE_1} = {WLV12HEPC.DEFVALU} AND
{WLV12HEPC.ATRBT02} = "6”
----- Before truncation: -----
{SARADAP.SARADAP_TERM_CODE_ENTRY} = {?Entry Term} AND
{SPRTELE.SPRTELE_TELE_CODE} IN "HOME""MA" AND
{SPRTELE.SPRTELE_SEQNO} = 1.00 AND
{SPRADDR.SPRADDR_ATYP_CODE} <> "PA" AND
{SPRADDR.SPRADDR_ATYP_CODE} <> "GU" AND
{SPRADDR.SPRADDR_SEQNO} = 1.00 AND
----- After truncation: -----
{WLV12HEPC.VAWORDID} = 'MAJ-MIN' AND
{SARADAP.SARADAP_MAJR_CODE_1} = {WLV12HEPC.DEFVALU} AND
{WLV12HEPC.ATRBT02} = "6”