Some database fields do not show up in Insert Group

[Former Member]

Windows 7 64-bit, CR2010, VS2010.

Used the report wizard to create a report. Selected three tables Proc, Proj and a cross-reference table (relationship) table called Proc_Proj. Both Proc and Proj contain a field called "Name" nvarchar(max). Links show up fine, and I pick both "Name" fields to show up on the report.

When I get to the "Grouping" page, both "Name" fileds along with some others are missing in the Available Fields box. I have no idea why!

Please help! Thank you.

[former_member11696 · Accepted solution]

Hello,

When you use a NVARCHAR(MAX) field type it tells CR it is 64K long. CR will not use that field type for Groups.

Only option is to change the type to a limited length like NVarChar(50) as an example.

I tested this in CR 2008 and it works the same way, can not choose that field type to group on.

Thank you

Don

[Former Member · Accepted solution]

Thank you Don. It worked fine with nvarchar(500), so I suppose as long as there is a numerical limit to the datafield, it should work without problems.