inncoggnitto
Programmer
is there a workaround for crystal rpts 8.5 inability to retieve data from large varchar2 fields in a formula. we have a text description field 2000 characters long and i need to get it into a report. the problem is that i need to use a formula because i only need the data if another field contains the value "NO ADDRESS". this large field is used to store a text description on how to find a location if it does not have an address, (i.e., a water well in the country). the information is part of a subreport.
we have used this via the sql editor to retrieve the data before.
SUBSTR(LOC.ACCESS_DESC_TXT,1,250)
but this report contains several subreports and other items that would make it difficult to code it all with the sql editor.
we have used this via the sql editor to retrieve the data before.
SUBSTR(LOC.ACCESS_DESC_TXT,1,250)
but this report contains several subreports and other items that would make it difficult to code it all with the sql editor.