hi,
I working crystal reports in .net . report viwer is used toopen the reports in web application. Database(sql server) is connecting using oledb with Windows authentication.

now my problem is in run time crystal reports is giving login failed.
Otherwise how can i specify "windows authentication" in loginfo of the crystal reports.

can anybody help?
shyna

HI there .
If u r using SQL DATABASE , then y dont u go for sqlclient connectivity. i mean use sqldataadapter and its connectivity , bcz its much more relaible. anyways your problem is no where releted to this topic.
let me show u the code to make the login for crystal report web applications.
 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> >>>>>

              Dim Rport As New CryRWebForm13

          ' providing the log on authentication
            Dim myTable As CrystalDecisions.CrystalReports.Engine.Table
            Dim myLogin As CrystalDecisions.Shared.TableLogOnInfo
            For Each myTable In Rport.Database.Tables
                myLogin = myTable.LogOnInfo
                myLogin.ConnectionInfo.ServerName = ServerName
                myLogin.ConnectionInfo.DatabaseName = DatabaseName
                myLogin.ConnectionInfo.Password = Password
                myLogin.ConnectionInfo.UserID = UserName
                myTable.ApplyLogOnInfo(myLogin)
            Next
            Rport.SetDatabaseLogon(UserName, Password, ServerName, DatabaseName)
' username -> database username eg: sa
' password -> DB password eg : ""
' Servarname -> ServerName eg: sqlServer
' Databasename -> Db Name eg: SaudiSystemsDB


               ' passing parameters
            Rport.SetParameterValue("YEAR_ID", lstYear.SelectedValue)
            Rport.SetParameterValue("GLOBAL_STATUS", lstGStatus.SelectedValue)
            Rport.SetParameterValue("PRO_TYPE", lstType.SelectedValue)
            Rport.SetParameterValue("PRO_STATUS", lstStatus.SelectedValue)
            'Rport.FormatEngine.PrintOptions.PaperOrientation = PaperOrientation.Landscape
            Rport.PrintOptions.PaperOrientation = PaperOrientation.Landscape

           ' binding the report
            CrystalReportViewer1.ReportSource = Rport
            CrystalReportViewer1.DataBind()

thts it,
now i think u will get the idea how to go for dynamic reports using web application in dotnet
best of luck
regards
Raza



Mohammed Raza Ullah Khan

hi,

I am using sqladapter only.
my sample code is below:

dim rpt as crystalreport1
dim myadapter as new sqladapter("select * from employee",sqlconn)
dim mydataset as new dataset
myadapter.fill(mydataset,"employee")
rpt.setdatasource(mydataset)
reportviewer1.reportsource=rpt
reportviewer1.databind();


the abovecode is givingthe following error:
Logon failed.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: CrystalDecisions.CrystalReports.Engine.LogOnExcept ion: Logon failed.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[LogOnException: Logon failed.]
   .F(String  , EngineExceptionErrorID 
) +506
   .A(Int16 
, Int32 ) +537
   CrystalDecisions.CrystalReports.Engine.FormatEngin e.GetPage(PageRequestContext reqContext) +539
   CrystalDecisions.ReportSource.LocalReportSourceBas e.GetPage(PageRequestContext pageReqContext) +189
   CrystalDecisions.Web.ReportAgent.u(Boolean N) +164
   CrystalDecisions.Web.CrystalReportViewer.OnPreRend er(EventArgs e) +108
   System.Web.UI.Control.PreRenderRecursiveInternal() +62
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Page.ProcessRequestMain() +1489




.............. pls help me rgd this
thanks

I don't know if it can help you and other with Crystal Report, but we have an amazing online course (with a lot of free videos) that complete all of the Wrox books about it.
You can see it at:
http://mrbool.com/course/E-Learning-...in-ASP-NET/265