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