Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Report, Record Selection Formula truncates

Status
Not open for further replies.

bhfmc

IS-IT--Management
Jun 18, 2003
29
US
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} <> &quot;PA&quot; AND
{SPRADDR.SPRADDR_ATYP_CODE} <> &quot;GU&quot; AND
{SPRADDR.SPRADDR_SEQNO} = 1.00 AND
----- After truncation: -----
{WLV12HEPC.VAWORDID} = 'MAJ-MIN' AND
{SARADAP.SARADAP_MAJR_CODE_1} = {WLV12HEPC.DEFVALU} AND
{WLV12HEPC.ATRBT02} = &quot;6”
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top