SmartViewerHTML works, SmartViewerActiveX doesn't.

[StevenJ]

I have a simple report that displays output from a stored procedure via an ASP page. I am developing the web application using Visual Interdev v6 SP2 on a Win2K SP2 Server box w/SQL 2K SP1.

The report displays correctly if I use the SmartViewerHTMLPage.asp or the SmartViewerHTMLFrame.asp include file in my ASP page.

However, if I use the SmartViewerActiveXPage.asp include, the ActiveX control loads and instantiates, I can see and manipulate the controls, it displays 1 of 1 in the page location at the top, but the actual report display area in the control is dark grey - no lines from the report are displayed within.

I've tried all of the suggestions that I could find in the Crystal knowledge base regarding the use of the ActiveX viewer, and have gone through the Crystal Web Viewer ActiveX troubleshooting guide without success. I've also tried to scan this forum and the database forum without finding a solution, hence this post.

Hoping you can shed some light,

Thank you!

Steven J. Ackerman
ACS, Sarasota, FL

http://www.acscontrol.com

steve@acscontrol.com
sja@gte.net
(941)377-5775
(941)378-4226 FAX

 

[StevenJ]

Found the problem. This one had Crystal support stumped.

Here's a Knowledge base article that describes the problem with VI and how to fix it:

http://support.microsoft.com/support/kb/articles/Q297/9/95.ASP

Basically, you can't use the Crystal ActiveX viewer with VI in debugging mode, because of extra data that IIS inserts into the HTTP stream to the client. This also affects anything that depends upon an unadulterated Response.BinaryWrite stream. Too bad !

--
Steven J. Ackerman, Consultant
ACS, Sarasota, FL

http://www.acscontrol.com

steve@acscontrol.com
sja@gte.net