how to create crystal reports in asp.net & vb.net with
syntax
Answer Posted / howard rothenburg
Try:
Imports CrystalDecisions
Imports CrystalDecisions.CrystalReports
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared
Imports System.IO
Public Class _Default
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
End Sub
Protected Sub LinkButton1_Click(sender As Object, e As EventArgs) Handles LinkButton1.Click
OpenPDF(Request.ApplicationPath + "/Reports/Report.pdf")
End Sub
Private Sub OpenPDF(downloadAsFilename As String)
Dim RptDoc As New ReportDocument()
RptDoc.Load(Server.MapPath(Request.ApplicationPath + "/Reports/myreport.rpt"))
RptDoc.SetDatabaseLogon("user", "password", "server", "database")
Dim stream As New BinaryReader(RptDoc.ExportToStream(CrystalDecisions.[Shared].ExportFormatType.PortableDocFormat))
Response.ClearContent()
Response.ClearHeaders()
Response.ContentType = "application/pdf"
Response.AddHeader("content-disposition", Convert.ToString("attachment; filename=") & downloadAsFilename)
Response.AddHeader("content-length", stream.BaseStream.Length.ToString())
Response.BinaryWrite(stream.ReadBytes(Convert.ToInt32(stream.BaseStream.Length)))
Response.Flush()
Response.Close()
End Sub
End Class
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain option strict?
What is option strict?
Is it necessary to have SQL server installed in your computer in order to create a service based database in vb.net?
What is the differnce between managed code and unmanaged code?
Explain some of the exclusive features which are present in vb?
What is different between web.config and machine.config and where it will be ?
What is the difference between c# and vb.net?
Name some of the keywords used in vb.net?
What are the technology areas that microsoft.net contains?
How can we remove handlers at run time?
What is sorting in vb?
Compare c# and visual basic.net?
What are the differences between c# and visual basic.net?
When do you use virutal keyword?
Explain convert.tostrin?