Crystal Reports and varchar(MAX) not printing

20 pts.
Tags:
Crystal Reports
VARCHAR
Vista compatibility
Visual Studio 2005
Hi All, I have a Crystal Reports report (VS2005 version) that prints a number of fields from a SQL table. When I print the report under Windows XP, everything works properly. When I print under Windows Vista on a tablet PC, the report prints, except for the varchar(MAX) field. Does anyone know a way to resolve this? Cheers.
Asked: Last updated:
Related Questions
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

I know that with SQL 2000 servers using the TEXT fields someone the TEXT column would only work correctly if the TEXT column was the last column in the recordset. Try moving the column to the end of the recordset and see if that helps.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Sreekantha86
    I also had this printing problem. I solved this by changing varchar(max) to varchar(8000). varchar(MAX)==varchar(8000). Sreekanth A, Programmer, Ihits Softwares, sreekantha86@gmail.com
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: