Skip to Content
0
Former Member
Apr 24, 2009 at 12:49 PM

Why cant I group by large fields, and why dont these print properly?

18 Views

I have a number of Crystal Reports fed by my database which has a table in it that stores Paths (to given files and locations). In SQL Server this path column is set to nvarchar(MAX).

However, whenever I try to use this column in reports 2 things appear strange...

1.) I can never group on this field (which I need badly to do) - it just never shows up in the Group Expert.

2.) Whenever I use this field in a report and set the field to "Can Grow", it never prints anything beyond about 450 characters (and yes, we have some paths that go much longer than that) - in other words, although the "Can Grow" setting seems to work as the field will grow - it never prints anything beyond about 450 characters.

What is happening with this? Any ideas anyone?

Thanks!