The text, ntext, and image data types cannot be used in an ORDER BY clause

W

warway

A report views fine to screen but when sent to printer the follwoing error
appears.

The text, ntext, and image data types cannot be used in an ORDER BY clause.

Why to screen and not to print?

Any ideas?

TIA
Warway
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
sort on form 1
Trying to Cast Ntext as nvarchar in order to use Group BY 5
Drop and re-recreate views 4
Exporting query or report to Excel results in Text field data loss 8
Blank Field Problem with a NText (Memo) type of field 2
Office 2007 Apps - Printing all graphics mirrored - Text Normal 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0

Top