Hey Parvez,
Add a Crystal Reports Viewer object onto the aspx page
and use the following code to open the existing rpt
file. Let me know if you need any further assitance.
Shannon
'CR variables
Dim crReportDocument As Object
Dim crDatabase As Database
Dim crTables As Tables
Dim crTable As Table
Dim crTableLogOnInfo As TableLogOnInfo
Dim crConnectionInfo As ConnectionInfo
crReportDocument = New ReportDocument
CType(crReportDocument,
ReportDocument).Load(Server.MapPath("..\..") &
"\RptFiles\" & "PDMTechReview.rpt")
crReportDocument.SetParameterValue(0,
ParamVar1)
crReportDocument.SetParameterValue(1,
ParamVar2)
crConnectionInfo = New ConnectionInfo
With crConnectionInfo
.ServerName =
System.Configuration.ConfigurationSettings.AppSettings("rptDBServer")
'"SQL1"
.DatabaseName =
System.Configuration.ConfigurationSettings.AppSettings("rptDBName")
'"pdmdata"
.UserID =
System.Configuration.ConfigurationSettings.AppSettings("rptDBUId")
'"pdmdata"
.Password =
System.Configuration.ConfigurationSettings.AppSettings("rptDBPwd")
'"w3badm1n"
End With
'Get the tables collection from the report
object
crDatabase = crReportDocument.Database
crTables = crDatabase.Tables
'Apply the logon information to each table
in the collection
For Each crTable In crTables
crTableLogOnInfo = crTable.LogOnInfo
crTableLogOnInfo.ConnectionInfo =
crConnectionInfo
crTable.ApplyLogOnInfo(crTableLogOnInfo)
Next
'Once the connection to the database has
been established for
'each table in the report, the report
object can be bound to the viewer
'using the reportsource property of the
viewer to display the report.
CrystalReportViewer1.ReportSource =
crReportDocument
--- Parvez Khan <[EMAIL PROTECTED]> wrote:
> Hi friends,
>
> I want to show crystal report in PDF format without
> saving it either on SERVER or on CLIENT machine.
>
> Can anyone help me also send me the code for that
>
> Thanks in Advance
> Parvez
>
> [Non-text portions of this message have been
> removed]
>
>
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
