Click here to Skip to main content
Click here to Skip to main content

Displaying , Exporting and Printing Crystal Reports in ASP.NET

, 14 Mar 2005 CPOL
Rate this:
Please Sign up or sign in to vote.
Displaying , exporting and printing crystal reports in ASP.NET with source code.


The main purpose of this document is to display the report without any error. I was bugged by the "Logon Failed Error" for several days, and now I finally have a code that displays report without any error. The code also Exports the report into .pdf, .xls, .rtf and .doc formats. It also prints the report directly to the printer.

Using the code

Unzip the crCodes.Zip and then run the crCode.vbproj project file.

--- OR ----

Just insert the Webform1.aspx file into your existing project, then copy the crystalreport2.rpt file into your project, and start using the code.

The entire source code of Webform1.aspx.vb is as follows. Simply design the form as shown in the image and place the Crystal Report Viewer control, and leave the name of controls to default:

Imports CrystalDecisions.Shared
Imports System.IO

Public Class WebForm1
    Inherits System.Web.UI.Page

    Dim crReportDocument As CrystalReport2 = New CrystalReport2

    Protected WithEvents DropDownList1 As System.Web.UI.WebControls.DropDownList
    Protected WithEvents Button1 As System.Web.UI.WebControls.Button
    Protected WithEvents Label1 As System.Web.UI.WebControls.Label
    Protected WithEvents CrystalReportViewer1 As _
    Protected WithEvents Button2 As System.Web.UI.WebControls.Button

#Region " Web Form Designer Generated Code "
    'This call is required by the Web Form Designer.
    Private Sub InitializeComponent()

    End Sub

    'NOTE: The following placeholder declaration is required 
    'by the Web Form Designer.
    'Do not delete or move it.
    Private designerPlaceholderDeclaration As System.Object

    Private Sub Page_Init(ByVal sender As System.Object,_ 
                        ByVal e As System.EventArgs) Handles MyBase.Init
        'CODEGEN: This method call is required by the Web Form Designer
        'Do not modify it using the code editor.

        ' this is the most IMPORTANT line of code
        ' if this line is not writen the 
        ' " LOGON FAILED" error starts displaying
                                    "password", "sql-server", "database")

        ' the Above line works even if only username 
        ' and password is supplied as below

                                 "password") ', "sql-server", "database")

        ' this will hide the group tree
        CrystalReportViewer1.DisplayGroupTree = False

        CrystalReportViewer1.ReportSource = crReportDocument

        ' IF REPORT Uses Parameter's
        ' Pass Paramaters As Follows
        crReportDocument.SetParameterValue("city", "Mumbai")

        ' city = Parameter Name
        ' Mumbai = Parameter Value

        ' :-) thats ALL your Report Will Be displayed 
        ' now Without Logon Failed Error

        With DropDownList1.Items
            .Add("Rich Text (RTF)")
            .Add("Portable Document (PDF)")
            .Add("MS Word (DOC)")
            .Add("MS Excel (XLS)")
        End With
    End Sub

#End Region

    Private Sub Page_Load(ByVal sender As System.Object,_ 
                ByVal e As System.EventArgs) Handles MyBase.Load
        'Put user code to initialize the page here
    End Sub

    Sub ExportReport()

        Dim oStream As New MemoryStream ' // using System.IO

        'this contains the value of the selected export format.
        Select Case DropDownList1.SelectedItem.Text 

            Case "Rich Text (RTF)"

                oStream = crReportDocument.ExportToStream(_
                Response.Buffer = True
                Response.ContentType = "application/rtf"

            Case "Portable Document (PDF)"

                oStream = crReportDocument.ExportToStream(_
                Response.Buffer = True
                Response.ContentType = "application/pdf"

            Case "MS Word (DOC)"

                oStream = crReportDocument.ExportToStream(_
                Response.Buffer = True
                Response.ContentType = "application/doc"

            Case "MS Excel (XLS)"

                oStream = crReportDocument.ExportToStream(_
                Response.Buffer = True
                Response.ContentType = "application/"
        End Select 'export format
        Catch err As Exception
            Response.Write("< BR >")
        End Try
    End Sub

    Private Sub Button2_Click(ByVal sender As System.Object, _
                          ByVal e As System.EventArgs) Handles Button2.Click
    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, _
                          ByVal e As System.EventArgs) Handles Button1.Click
        crReportDocument.SetDatabaseLogon("USER", _
                                "PASSWORD", "SQL-SERVER", "DATABASE")
        crReportDocument.PrintToPrinter(1, False, 0, 0)
    End Sub
End Class

Why is the "Logon Failed Error" generated

The "Logon Failed" error is generated basically because, when the report is being displayed it tries to log on to the database server. Even though you have selected the server while designing, the report still needs the server name while displaying or exporting or printing.

The code line that removes the error is:

crReportDocument.SetDatabaseLogon("USER", "PASSWORD", "SQL-SERVER", "DATABASE")

Or can also be used as:

crReportDocument.SetDatabaseLogon("USER", "PASSWORD")


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Web Developer
India India
No Biography provided

Comments and Discussions

GeneralMy vote of 1 Pinmemberkashishkhanna6-Nov-14 0:53 
Questionprint report in c# PinmemberMohammed Abdul Muqeet20-Jan-13 1:33 
Questionprinttoprinter Error Pinmemberer_ashu18-Jul-12 1:40 
GeneralMy vote of 3 Pinmemberparthmehta.indianic17-Mar-12 1:02 
QuestionExport excel with password protected Pinmemberselvakumark19-Feb-12 17:27 
Questionexport crystal report into pdf from 2nd page [modified] Pinmemberselvakumark16-Feb-12 16:58 
GeneralMy vote of 5 Pinmembermanoj kumar choubey9-Feb-12 4:06 
GeneralMy vote of 2 PinmemberMember 42938943-Apr-11 19:16 
GeneralCrystal Report viewer Pinmemberamitrajahuja11-Dec-10 4:25 
GeneralAnother method PinmemberAlexandru Matei12-Oct-09 3:55 
In the Page_Load event, you could write:

string fileName = "reportName";
crReportDocument.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, true, fileName);
I am using Visual Studio 2005 SP1
GeneralRe: Another method Pinmembermahi159021-Mar-13 22:10 
QuestionPrinting using Crystal reports Print Control PinmemberKrutiCh30-Sep-08 7:45 
GeneralTroubles with Login PinmemberMember 477445510-Sep-08 8:53 
GeneralTrying in c# and gives an error Pinmembermundaves8-Jul-08 14:42 
GeneralProblem in export to excel with paramater Pinmembershms3-Mar-08 17:06 
Generalstill getting error Pinmemberpatel heena d29-Jun-07 14:24 
Questionhow to create an object of crystal file Pinmemberpatel heena d29-Jun-07 13:48 
GeneralWeb application doesn't show the report. Pinmemberm3n5413-Mar-07 17:30 
Generalgood one PinmemberMember #26788916-Mar-07 20:09 
Questioncrystal report Pinmemberkk_upadhyay28-Feb-07 23:15 
QuestionI am getting a record per page... Pinmembergrigorythegreat5-Feb-07 4:47 
AnswerRe: I am getting a record per page... Pinmembersylvesterg15-Feb-07 21:09 
GeneralGood Artical Pinmembersumja17-Jan-07 3:20 
Generalprinting error Pinmembercontact_ashishjain16-Nov-06 0:57 
GeneralRe: printing error PinmemberbackSlashZero12-Sep-07 21:46 
QuestionURGENT : Crystal reports - export to prn programmatically PinmemberNosheenA13-Nov-06 2:15 
GeneralGood Example Pinmemberanil0012327-Sep-06 1:28 
GeneralThread was being aborted Pinmembermarquito_cuba5-Jun-06 12:50 
GeneralGetting Blank Screen After Exporting PDF PinmemberSakkaravarthi10-May-06 1:08 
QuestionRe: Getting Blank Screen After Exporting PDF Pinmemberguyvds200025-Apr-07 3:45 
GeneralRe: Getting Blank Screen After Exporting PDF Pinmemberhkdhamija19-Jul-07 1:12 
Generalexporting the report Pinmemberj0ms9-May-06 7:15 
Question"Logon Failed" error while printing crystal report PinmemberNaynesh8-May-06 23:57 
AnswerRe: "Logon Failed" error while printing crystal report Pinmembertawpuia4-Jul-08 2:24 
JokeGood Artical Pinmemberykg1-May-06 2:39 
GeneralRe: Good Artical PinmemberSuresh Dayma7-Sep-06 7:35 
GeneralError export Report with parameters PinmemberDon Maxim28-Feb-06 23:18 
GeneralRe: Error export Report with parameters PinmemberThanh-hdu5-Mar-07 22:53 
GeneralUnable to debug the application Pinmemberskan81228-Feb-06 2:09 
GeneralRe: Unable to debug the application PinmemberSakkaravarthi10-May-06 1:09 
GeneralLogon Failed with C# web application Pinmemberquocviet47717-Jan-06 17:25 
Generalcrsytal report login failure Pinmembervipindev27-Dec-05 2:21 
QuestionHow could I use share printer for to print? PinmemberAgent00931-Oct-05 21:21 
QuestionProblem to export to MS Word 7:21 
AnswerRe: Problem to export to MS Word PinmemberGerald Lee26-Jan-06 15:23 
GeneralRe: Problem to export to MS Word PinmemberThanh-hdu5-Mar-07 21:01 
GeneralRe: Problem to export to MS Word PinmemberThanh-hdu5-Mar-07 21:23 
GeneralAnother Logon Failure PinmemberLilay8-Oct-05 9:07 
GeneralRe: Another Logon Failure Pinmembersudheerbalanagu18-Dec-05 21:10 
QuestionHow to refresh data when Report export DPF file Pinmembercuongeagle26-Sep-05 22:41 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.150301.1 | Last Updated 15 Mar 2005
Article Copyright 2005 by patelsachin
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid