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: August 22, 2008  10:17 AM
UPDATED: October 26, 2010  4:08 AM

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following