Crystal Report Problems

[Michael Persaud]

hello,

i am having problems with loading a crystal report in asp.net, below is the
code, the error message.

for shorts the following is bugging
st = oRpt.FormatEngi ne.ExportToStre am(req)
please help,
its been 2 days now and i cant figure this

Thanks
MP

code
=============== ===============

Dim str As String = "'0','2','7 '"
CrystalReportVi ewer1.ReportSou rce = Server.MapPath( "admin_print.rp t")
If Not Me.IsPostBack Then
Dim Ods As DataSet
Try
oRpt = New ReportDocument
oRpt.Load(Serve r.MapPath("admi n_print.rpt"))
'Ods = dg.DataSource
Ods = getData(str)
'Response.Write (Ods.Tables.Cou nt.ToString)
oRpt.SetDataSou rce(Ods)
Call ExportToPDF() ' this inititiates the next sub where it fails
Catch oException As Exception
'Throw oException
Response.Write( oException.ToSt ring)
Finally
oRpt.Dispose()
'Ods.Dispose()
'Ods.Clear()
End Try
End If

Private Sub ExportToPDF()
Dim tblCurrent As CrystalDecision s.CrystalReport s.Engine.Table
Dim tliCurrent As CrystalDecision s.Shared.TableL ogOnInfo
For Each tblCurrent In oRpt.Database.T ables
tliCurrent = tblCurrent.LogO nInfo
With tliCurrent.Conn ectionInfo
'get log in info from web.config
..ServerName = ConfigurationSe ttings.AppSetti ngs("SQLServer" )
..DatabaseName = ConfigurationSe ttings.AppSetti ngs("Database")
..UserID = ConfigurationSe ttings.AppSetti ngs("UserId")
..Password = ConfigurationSe ttings.AppSetti ngs("Password")
End With
'apply the log in info
tblCurrent.Appl yLogOnInfo(tliC urrent)
Next tblCurrent

Dim crExportOptions As ExportOptions
Dim st As System.IO.Strea m
crExportOptions = oRpt.ExportOpti ons
With crExportOptions
..FormatOptions = New PdfRtfWordForma tOptions
..ExportFormatT ype = ExportFormatTyp e.PortableDocFo rmat
End With
Dim req As ExportRequestCo ntext = New ExportRequestCo ntext
req.ExportInfo = crExportOptions
st = oRpt.FormatEngi ne.ExportToStre am(req)
Response.ClearC ontent()
Response.ClearH eaders()
Response.Conten tType = "applicatio n/pdf"
Dim b(st.Length) As Byte
st.Read(b, 0, st.Length)
Response.Binary Write(b)
End Sub
===============
error stack
=============== =============== =====
Logon failed.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: CrystalDecision s.CrystalReport s.Engine.LogOnE xception:
Logon failed.

[skg]

Looks like your reports are failing to LogIn into the database. Check your
Report to see what userid and password they are using to logon into the
database.

"Michael Persaud" <mi************ **@hotmail.com> wrote in message
news:e3******** ******@TK2MSFTN GP09.phx.gbl...

hello,

i am having problems with loading a crystal report in asp.net, below is
the
code, the error message.

for shorts the following is bugging
st = oRpt.FormatEngi ne.ExportToStre am(req)
please help,
its been 2 days now and i cant figure this

Thanks
MP

code
=============== ===============

Dim str As String = "'0','2','7 '"
CrystalReportVi ewer1.ReportSou rce = Server.MapPath( "admin_print.rp t")
If Not Me.IsPostBack Then
Dim Ods As DataSet
Try
oRpt = New ReportDocument
oRpt.Load(Serve r.MapPath("admi n_print.rpt"))
'Ods = dg.DataSource
Ods = getData(str)
'Response.Write (Ods.Tables.Cou nt.ToString)
oRpt.SetDataSou rce(Ods)
Call ExportToPDF() ' this inititiates the next sub where it fails
Catch oException As Exception
'Throw oException
Response.Write( oException.ToSt ring)
Finally
oRpt.Dispose()
'Ods.Dispose()
'Ods.Clear()
End Try
End If

Private Sub ExportToPDF()
Dim tblCurrent As CrystalDecision s.CrystalReport s.Engine.Table
Dim tliCurrent As CrystalDecision s.Shared.TableL ogOnInfo
For Each tblCurrent In oRpt.Database.T ables
tliCurrent = tblCurrent.LogO nInfo
With tliCurrent.Conn ectionInfo
'get log in info from web.config
.ServerName = ConfigurationSe ttings.AppSetti ngs("SQLServer" )
.DatabaseName = ConfigurationSe ttings.AppSetti ngs("Database")
.UserID = ConfigurationSe ttings.AppSetti ngs("UserId")
.Password = ConfigurationSe ttings.AppSetti ngs("Password")
End With
'apply the log in info
tblCurrent.Appl yLogOnInfo(tliC urrent)
Next tblCurrent

Dim crExportOptions As ExportOptions
Dim st As System.IO.Strea m
crExportOptions = oRpt.ExportOpti ons
With crExportOptions
.FormatOptions = New PdfRtfWordForma tOptions
.ExportFormatTy pe = ExportFormatTyp e.PortableDocFo rmat
End With
Dim req As ExportRequestCo ntext = New ExportRequestCo ntext
req.ExportInfo = crExportOptions
st = oRpt.FormatEngi ne.ExportToStre am(req)
Response.ClearC ontent()
Response.ClearH eaders()
Response.Conten tType = "applicatio n/pdf"
Dim b(st.Length) As Byte
st.Read(b, 0, st.Length)
Response.Binary Write(b)
End Sub
===============
error stack
=============== =============== =====
Logon failed.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: CrystalDecision s.CrystalReport s.Engine.LogOnE xception:
Logon failed.

[Michael Persaud]

hello,

thanks

i am using the sa and that password

plus i have a connection string that is creating the dataset and i traced
that to be a workable item

every other call works so why does this one fail?

thanks
MP


"skg" <sk*@yahoo.co m> wrote in message
news:#v******** ******@TK2MSFTN GP14.phx.gbl...

Looks like your reports are failing to LogIn into the database. Check your
Report to see what userid and password they are using to logon into the
database.

"Michael Persaud" <mi************ **@hotmail.com> wrote in message
news:e3******** ******@TK2MSFTN GP09.phx.gbl...

hello,

i am having problems with loading a crystal report in asp.net, below is
the
code, the error message.

for shorts the following is bugging
st = oRpt.FormatEngi ne.ExportToStre am(req)
please help,
its been 2 days now and i cant figure this

Thanks
MP

code
=============== ===============

Dim str As String = "'0','2','7 '"
CrystalReportVi ewer1.ReportSou rce = Server.MapPath( "admin_print.rp t")
If Not Me.IsPostBack Then
Dim Ods As DataSet
Try
oRpt = New ReportDocument
oRpt.Load(Serve r.MapPath("admi n_print.rpt"))
'Ods = dg.DataSource
Ods = getData(str)
'Response.Write (Ods.Tables.Cou nt.ToString)
oRpt.SetDataSou rce(Ods)
Call ExportToPDF() ' this inititiates the next sub where it fails
Catch oException As Exception
'Throw oException
Response.Write( oException.ToSt ring)
Finally
oRpt.Dispose()
'Ods.Dispose()
'Ods.Clear()
End Try
End If

Private Sub ExportToPDF()
Dim tblCurrent As CrystalDecision s.CrystalReport s.Engine.Table
Dim tliCurrent As CrystalDecision s.Shared.TableL ogOnInfo
For Each tblCurrent In oRpt.Database.T ables
tliCurrent = tblCurrent.LogO nInfo
With tliCurrent.Conn ectionInfo
'get log in info from web.config
.ServerName = ConfigurationSe ttings.AppSetti ngs("SQLServer" )
.DatabaseName = ConfigurationSe ttings.AppSetti ngs("Database")
.UserID = ConfigurationSe ttings.AppSetti ngs("UserId")
.Password = ConfigurationSe ttings.AppSetti ngs("Password")
End With
'apply the log in info
tblCurrent.Appl yLogOnInfo(tliC urrent)
Next tblCurrent

Dim crExportOptions As ExportOptions
Dim st As System.IO.Strea m
crExportOptions = oRpt.ExportOpti ons
With crExportOptions
.FormatOptions = New PdfRtfWordForma tOptions
.ExportFormatTy pe = ExportFormatTyp e.PortableDocFo rmat
End With
Dim req As ExportRequestCo ntext = New ExportRequestCo ntext
req.ExportInfo = crExportOptions
st = oRpt.FormatEngi ne.ExportToStre am(req)
Response.ClearC ontent()
Response.ClearH eaders()
Response.Conten tType = "applicatio n/pdf"
Dim b(st.Length) As Byte
st.Read(b, 0, st.Length)
Response.Binary Write(b)
End Sub
===============
error stack
=============== =============== =====
Logon failed.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: CrystalDecision s.CrystalReport s.Engine.LogOnE xception: Logon failed.