Same data showing in PDF when i am exporing from crystal report viewer. I am using .net 2003 and inbuilt crystal report and i am using asp.net with
vb.net for my web page creation.
it works fine without exporting. The problem arises only with the exporting.
my code is
this following code generates crystal report
Dim crReportDocument As New ReportDocument
Dim crtableLogoninfos As New TableLogOnInfos
Dim crtableLogoninfo As New TableLogOnInfo
Dim crConnectionInfo As New ConnectionInfo
Dim CrTables As Tables
Dim CrTable As Table
Dim TableCounter
Dim Fname As String
crReportDocument.Load(Server.MapPath("No Wise Report.rpt"))
CrTables = crReportDocument.Database.Tables
For Each CrTable In CrTables
With crConnectionInfo
.ServerName = ConfigurationSettings.AppSettings("servername")
.DatabaseName = "service"
.UserID = "sa"
.Password = ""
End With
Next
CrystalReportViewer1.ReportSource = crReportDocument
If Request("call_no") <> "" Then
CrystalReportViewer1.SelectionFormula = "{call_booking.call_no} = " & CInt(Request("call_no")) & ""
Else
CrystalReportViewer1.SelectionFormula = "{call_report.report_no} = '" & Request("report_no") & "'"
End If
CrystalReportViewer1.RefreshReport()
this following code is to export pdf
Fname = "c:\" & Session.SessionID.ToString & ".pdf"
crDiskFileDestinationOptions = New DiskFileDestinationOptions
crDiskFileDestinationOptions.DiskFileName = Fname
crExportOptions = crReportDocument.ExportOptions
With crExportOptions
.DestinationOptions = crDiskFileDestinationOptions
.ExportDestinationType = ExportDestinationType.DiskFile
.ExportFormatType = ExportFormatType.PortableDocFormat
End With
crReportDocument.Export()
crReportDocument.Export()
crReportDocument.Close()
Response.ClearContent()
Response.ClearHeaders()
Response.ContentType = "application/pdf"
Response.WriteFile(Fname)
Response.Flush()
Response.Close()
System.IO.File.Delete(Fname)
please i want the solution soon. thank u
Same data showing in PDF
