TOPIC: NVARCHAR(MAX) fields not displaying in V1.7

NVARCHAR(MAX) fields not displaying in V1.7 02 Apr 2014 10:09 #1553

  • BNGC
  • BNGC's Avatar
  • Offline
Dear Logicity

We are having an issue with V1.7.0018 not displaying cerstain text fields correctly from a SQL database.

The source database has a 'note' field that is an nvarchar(max). In Crystal V10, Crystal doesn't interupt the type correctly and displays the type as a char(255). But the preview in Crystal still displays the field correctly. It also displays correctly in V1.6 of Logicity. In V1.7.0018 however, the field is blank and not displayed.

Is this a known issue or a bug?

We do have a workaround. If you create a formula which takes the leftmost 255 characters e.g. left({OrderNotes.NoteText},255), then the field displays in 1.7.0018 correctly.

So I guess something changed between 1.6 and 1.7 that has caused the issue with the field not displaying?

Many thanks
Trevor
Last Edit: 02 Apr 2014 10:10 by BNGC. Reason: Subject edit
The administrator has disabled public write access.