Post a Crystal Report on the web

[Chandarrs]

Hi, Can anyone give me a help tip how to post a Crystal Report on the web. Your Help is appriciated.,

Thanks.,

[scuzymoto]

Look into a product called the crystal RAS server. It comes free with Crystal Reports Developer edition. It makes posting a report on a website really easy for a small handful of viewers.

If you want it to be viewed by large amounts of people however they make you pay out the nose for the enterprise edition that is capable of serving up reports to the web.

[Chandarrs]

Thanks scuzymoto for your reply.,
If I just want to post a report on web which is devloped already, Cystal enterprise does all or do I still need to web app using HTML/VB.net.
If you have any samples or documentation on this please forward them to me. I appriciate your help.

Thanks again.,

[scuzymoto]

The sample I have uses this code to display the report in a page called pageviewer.asp. The reportname is passed from a link in another page using the following URL. http:\\myweb\mypage\pageviewer.asp?reportname=sample.rpt . Im pretty sure that the objects its using are installed by the RAS server installation on your webserver which allows it to display reports like this. Since crystal reports was recently purchased by Business Objects the products that do this might have changed. Ive never used these methods in real life, just playing around on my own computer.

<%@ Language=VBScript CodePage=65001 ENABLESESSIONSTATE = False %>
<% Option Explicit
' Note - the CodePage=65001 is needed to display Unicode text correctly in the viewer 
' 	 if Session is null for ProcessHttpRequest
Dim objectFactory
Set objectFactory = CreateObject("CrystalReports.ObjectFactory.2")

Response.ExpiresAbsolute = Now() - 1
	
Dim viewer
Set viewer = objectFactory.CreateObject("CrystalReports.CrystalReportViewer")  
viewer.Name = "page"
viewer.IsOwnForm = true	  
viewer.IsOwnPage = true

Dim theReportName
theReportName = Request.Form("ReportName")
if theReportName = "" then theReportName = Request.QueryString("ReportName")
viewer.URI = "pageViewer.asp?ReportName=" + Server.URLEncode(theReportName)

viewer.ReportSource = theReportName
viewer.ProcessHttpRequest Request, Response, Null

%>

[Chandarrs]

Thanks scuzymoto, I tried the following way.,
I installed Crystal enterprise and published the reports using Publish wizard and opened the report thru internet explorer on the same system. It worked, But when I try to open the report from other systems it gives this error "The Crystal ActiveX Viewer is Unable to create it's resource objects". I believe it's trying to install activeX viewer, unable. Any idea why?

[ARPRINCE]

If you are using Visual Studio with Crystal Reports for the web, try this one

Or just take your pick from here

[Chandarrs]

ARPRINCE, I am not using visual studio.net or any other applications with the reports. Those are all just designed in crystal using odbc connection and published on our web server using Crystal Enterprise publish wizard. I can view the report on the same server and other systems with crystal reports on them. But, When I try to view the report on system with NO crystal reports then it's giving the error "The Crystal ActiveX Viewer is unable to create it's resource objects". I don't think that needs web app to resolve that.
It something wirh Crystal ActiveX viewer settings I believe.,

[ARPRINCE]

Try this one or better yet, try Crystal's (Business Decisions) support page for more options.

[Chandarrs]

I have created virtual directory and pointed to the crystal view directory. It worked.
but, Now it's not prompting for parameters. I previewing the report with the default parameters defined in the report. When I was running the report thru crystal it used to prompt even though they have default values.
Is there anything I have to set on/off to get the prompting?? I appriciate youe help on this