Home > IT Answers > Business Intelligence > Crystal Reports and varchar(MAX) not printing
Markchimes
20 pts.
 Crystal Reports and varchar(MAX) not printing
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.

Software/Hardware used:
ASKED: August 22, 2008  10:17 AM
UPDATED: October 26, 2010  4:08 AM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  September 28, 2008  6:09 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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

Sreekantha86
 10 pts.