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!