how to create crystal reports in asp.net & vb.net with
syntax
Answer Posted / ranjith reddy
First create crystal report.In the interface of report i.e
aspx form to display report,add report document as
Toolbox-->Components-->ReportDocument.
Call the sub routine CreatePDF to display report.
rptProduct is the name of crystal report and docProd is the
name of report document.
Imports System.Data
Imports System.Data.SqlClient
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared
Imports System.IO
'This call is required by the Web Form Designer.
Private Sub InitializeComponent()
'start - This code should be pasted under #Region
Private Sub itializeComponent()
'rptProduct is the name of crystal report.
Me.docProd = New rptProduct
'
'docProd
'
Me.docProd.PrintOptions.PaperOrientation =
CrystalDecisions.Shared.PaperOrientation.DefaultPaperOrientation
Me.docProd.PrintOptions.PaperSize =
CrystalDecisions.Shared.PaperSize.DefaultPaperSize
Me.docProd.PrintOptions.PaperSource =
CrystalDecisions.Shared.PaperSource.Upper
Me.docProd.PrintOptions.PrinterDuplex =
CrystalDecisions.Shared.PrinterDuplex.Default
'Ends here
'Declaration of report document
Protected WithEvents docProd As rptProduct
Private Sub CreatePDF()
Dim objDS As New DataSet
Dim dfdoFile As New
CrystalDecisions.Shared.DiskFileDestinationOptions
Dim strServerPath As String
Dim szFileName As String
'Create dataset as per requirement
docProd.SetDataSource(objDS.Tables(0))
szFileName = Session.SessionID & ".pdf"
' rptDailyCalls.pdf
strServerPath = MapPath("~") & "\Report\"
' Here the pdf file will be saved.
File.Delete(strServerPath & "\" &
szFileName) ' Delete file first
dfdoFile.DiskFileName = strServerPath & "\" &
szFileName
With docProd
.ExportOptions.ExportDestinationType =
CrystalDecisions.Shared.ExportDestinationType.DiskFile
.ExportOptions.ExportFormatType =
CrystalDecisions.Shared.ExportFormatType.PortableDocFormat
.ExportOptions.DestinationOptions = dfdoFile
.Export()
End With
'URL of the pdf file
Response.Redirect("http://localhost/WebApplication1/" &
szFileName ,Flase)
End Sub
| Is This Answer Correct ? | 7 Yes | 6 No |
Post New Answer View All Answers
Explain the use of console application?
i have two class that contain's two methods as same name in derived class i have to call these two methods what will happen at run time ?
What is the main purpose of garbage collector?
Explain about the ruby interface generator?
Explain option strict?
Explain the difference between an xml "fragment" and an xml "document."
What are the advantages of vb.net and c#?
What is the purpose of objects present in asp.net?
described weak typing?
what is difference between namespace and assembly?
What is break mode? What are the options to step through code?
Which dll is used for microsoft .net run time?
What is different between web.config and machine.config and where it will be ?
How to run a dos command in vb.net?
What are all the parts of .net framework?