question

NBoddie-3697 avatar image
0 Votes"
NBoddie-3697 asked TomPhillips-1744 answered

Memo Data Type on the Microsoft Server

I have created a view on the server and its making the data type a memo. I am trying to use this view in Crystal report and it will display with that data type. Can you help with convert this data type to something else?

Here is the query in the view"
SELECT JobNumber, UserText, LEFT(UserText, 100) AS UserTextGroup
FROM dbo.AJ_D40

87908-image.png
87933-image.png


sql-server-generalsql-server-transact-sql
image.png (83.8 KiB)
image.png (5.0 KiB)
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Something else? Could that be anything? Or what do you have in mind? I think it helps if you can be more specific.

0 Votes 0 ·

Is the server you are using access? This forum is a SQL Server related forum, Is the server you are using access? This forum is a SQL Server related forum, mainly to provide support:
87985-image.png
87986-image.png

Click the link to view all products supported by the Microsoft Q&A Forum

Regards
Echo

0 Votes 0 ·
image.png (25.9 KiB)
image.png (16.9 KiB)

If you want to display formatted RTF text, then do not trim it (do not use LEFT) and consider the corresponding fields of reporting tool: https://www.bing.com/search?q=crystal+report+rtf.

0 Votes 0 ·

1 Answer

TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered

This is a Crystal Reports question, not a SQL Server question.

Please see:
https://answers.sap.com/questions/12748250/crystal-report-converting-the-nvarcharmax-datatype.html

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.