Skip to Content
0
Former Member
Apr 24, 2009 at 01:23 PM

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

16 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?

(Please note....

Crystal Version - 2008 with SP1

Problem affects 48 reports - e.g. tried and tried to get this to work - wont...

Please DO NOT respond to post in other forums - already have and would just like an answer)

Thanks!