what is crystal report viewer in asp.net?

Question

kindly explain me about how to use it in my webpage ,, and for what sake should i use it,, thanks in advance

Answer 1

It is report viewer. Usually Output of any applications is report. e.g. Daily sales. Crystal Reports enables you to create such report based upon database query. You can show that in vb applicatin with is viewer.

Answer 2

U will create a Crystal Report Separately,
and attach it to The Web Page using Crystal Report Viewer.



How do I run a Crystal Report using the Crystal Report Viewer?
After creating reports using the lite version of Crystal Reports that comes with .NET or the full version you can display them using the CrystalReportViewer control.

Add CrystalDecisions references to your project and drag the ReportViewer control onto your form. The references may vary but typically include:


CrystalDecisions.CrystalReports.Engine
CrystalDecisions.Shared
CrystalDecisions.Windows.Forms
CrystalDecisions.ReportSource


Loading a report when the report's DataSource is an XML Schema File


This VB.NET snippet assumes your report's DataSource is an XML Schema (XSD) file. For details on using an XML schema as the datasource click here.

Create a DataTable containing the data for the report:


Imports System.Data.OleDb

Dim strConnection As String = "..."
Dim Connection As New OleDbConnection(strConnection)
Dim strSQL As String = "Select * From Customers"
Dim DA As New OleDbDataAdapter(strSQL, Connection)
Dim DS As New DataSet
'
' Create a datatable in your dataset. The datatable's name
' must match that in the schema file used by the report.
'
DA.Fill(DS, "Customers")


Verify the path to the Crystal Report's .RPT file:


Dim strReportPath As String = Application.StartupPath & "\" & strReportName & ".rpt"

If Not IO.File.Exists(strReportPath) Then
Throw (New Exception("Unable to locate report file:" & vbCrLf & strReportPath))
End If


Load the Crystal report's .RPT file and pass in the DataTable:


Dim cr As New ReportDocument

cr.Load(strReportPath)
cr.SetDataSource(DS.Tables("Customers"))


Set the CrystalReportViewer's appearance and set the ReportSource:


CrystalReportViewer.ShowRefreshButton = False
CrystalReportViewer.ShowCloseButton = False
CrystalReportViewer.ShowGroupTreeButton = False

CrystalReportViewer.ReportSource = cr


Loading a report when the report's DataSource is a .NET DLL


This VB.NET code assumes your report's DataSource is a .NET DLL which returns a DataTable. For details on using a DLL as the datasource click here.

Verify the path to the Crystal Report's .RPT file:


Dim strReportPath As String = Application.StartupPath & "\" & strReportName & ".rpt"

If Not IO.File.Exists(strReportPath) Then
Throw (New Exception("Unable to locate report file:" & vbCrLf & strReportPath))
End If


Load the Crystal report's .RPT file:


Dim cr As New ReportDocument
cr.Load(strReportPath)


Set the CrystalReportViewer's appearance and set the ReportSource:


CrystalReportViewer.ShowRefreshButton = False
CrystalReportViewer.ShowCloseButton = False
CrystalReportViewer.ShowGroupTreeButton = False

CrystalReportViewer.ReportSource = cr

Answer 3

you use this active report to generate the reports for result.

this is an application which give result in print format