We have Crystal report based off stored proc from sql server. When queried in sql editor results are showing fine however when we use this SP in crystal designer most of the fields are truncated to String[1].
We have BOXI3.1 SP3
Marfi 
(BOB member since 2006-12-18)
hi,
did u check the format field in the crystal rpeort designer,
also set the formatting to “can grow” option this shuld solve your Issue.
bosupportdev (BOB member since 2009-11-16)
Actually this is solved. There was an if statement and only one result set of the condition had a correct datatype definition.
Marfi (BOB member since 2006-12-18)