I returned a crosstab query from SQL Server with
SELECT 'No. of Transactions' [SummaryName], COUNT(Transaction) 'Jan'
UNION
SELECT '% Error' [SummaryName], COUNT(Error) 'Jan'
UNION
SELECT 'This is a dummy test value for test purpose' [SummaryName], COUNT(RowID) 'Jan'
But in Crystal reports the first column is interpreted as String[31], so the long lines are getting truncated..
Help!