crystal report logon error

[vipindev.s]

hi all
i am not much expert in asp.net.
i am using crystal rpt for report generation. is any other report
generation method is available???

i use push method to creat report, and it is working fine, when i
export that report to pdf or xls it generate an error like Logon
failure.

CrystalDecisions.CrystalReports.Engine.LogOnExcept ion: Logon failed.

i use the follwing code for genearting report

Sub BindReport()

Dim myConnection As New SqlClient.SqlConnection

myConnection.ConnectionString = "Password=sa;Persist Security
Info=True;User ID=sa;Initial Catalog=pubs;Data Source=USER"

Dim MyCommand As New SqlClient.SqlCommand

MyCommand.Connection = myConnection

MyCommand.CommandText = "Select * from Stores"

MyCommand.CommandType = CommandType.Text

Dim MyDA As New SqlClient.SqlDataAdapter

MyDA.SelectCommand = MyCommand

Dim myDS As New Dataset1

'This is our DataSet created at Design Time

MyDA.Fill(myDS, "Stores")

'You have to use the same name as that of your Dataset that you
created during design time

Dim oRpt As New CrystalReport1

' This is the Crystal Report file created at Design Time

CType(oRpt.ReportDefinition.Sections(1).ReportObje cts(1),
CrystalDecisions.CrystalReports.Engine.TextObject) .Color =
Color.CadetBlue
CType(oRpt.ReportDefinition.Sections(1).ReportObje cts(1),
CrystalDecisions.CrystalReports.Engine.TextObject) .Top = 1
oRpt.SetDataSource(myDS)

' Set the SetDataSource property of the Report to the Dataset

CrystalReportViewer1.ReportSource = oRpt
End Sub

for exporting to pdf i use the following cod on a buton click.
it generate a error at last line " myReport.Export()"

Dim myReport As CrystalReport1 = New CrystalReport1
Dim DiskOpts As
CrystalDecisions.Shared.DiskFileDestinationOptions = New
CrystalDecisions.Shared.DiskFileDestinationOptions
myReport.ExportOptions.ExportDestinationType =
CrystalDecisions.[Shared].ExportDestinationType.DiskFile
myReport.ExportOptions.ExportFormatType =
CrystalDecisions.[Shared].ExportFormatType.PortableDocFormat
DiskOpts.DiskFileName = "c:\Output.pdf"
myReport.ExportOptions.DestinationOptions = DiskOpts

how i solve it
any reply is appriciated
thanks in advance
with regards
vipin

[Praveen]

It seems ur missing to set the Datasource property of the report during
post back.
ie we need to again fill the dataset and assign it to the report before
exporting.

Praveen P