Skip to Content
0
Former Member
Nov 19, 2009 at 02:34 AM

String[31]

28 Views

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!