How to stop crystal report viewer from asking login credentials when opening subreport

by

The problem is in Crystal Report login info. before showing the report you have to set login info to all tables which are included in main report and their sub reports. You are using Disconnected Datasource Report Show method. so you don’t need to provide login info to report document. your problem is here.

report.SetDataSource(ds);

when you are using SetDataSource method it is necessary to provide all tables which are included in crystal report document. here, you have passed only a single table in dataset. you must pass all tables including subreport tables.

I am suggesting you if you are using subreport then use connected datasource method instead if disconnected datasource(report.SetDataSource()). in Connected datasource you have to set login info before showing the report. 

private void PrintReport()
    {

        ReportDocument report = new ReportDocument();
        report.Load("ReportPath");

        ConnectionInfo crConnectionInfo = new ConnectionInfo();
        crConnectionInfo.ServerName = "HPL-WTS";
        crConnectionInfo.DatabaseName = "Enterprise32";
        crConnectionInfo.UserID = "sa";
        crConnectionInfo.Password = "*********";
        TableLogOnInfo crTableLogoninfo = new TableLogOnInfo();

        foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in report.Database.Tables)
        {
            crTableLogoninfo = CrTable.LogOnInfo;
            crTableLogoninfo.ConnectionInfo = crConnectionInfo;
            CrTable.ApplyLogOnInfo(crTableLogoninfo);
        }
        foreach (ReportDocument subreport in report.Subreports)
        {
            foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in subreport.Database.Tables)
            {
                crTableLogoninfo = CrTable.LogOnInfo;
                crTableLogoninfo.ConnectionInfo = crConnectionInfo;
                CrTable.ApplyLogOnInfo(crTableLogoninfo);
            }
        }                         

        CrystalReportViewer1.ReportSource = report;

        CrystalReportViewer1.ToolPanelView = CrystalDecisions.Web.ToolPanelViewType.None;
    }

if you want to use disconnected datasource even you have not included subreport then you can use a single command instead of multiple tables. that will make easy and gives better performance. becuase you just need to pass only a single table into SetDataSource method. but, dont forget to set tablename in DataTable otherwise report will not be displayed.

More Related Contents:

  1. How to bind crystal report to manually created DataSet
  2. Call a stored procedure with parameter in c#
  3. How to access session variables from any class in ASP.NET?
  4. Convert webpage to image from ASP.NET
  5. How to pass values across the pages in ASP.net without using Session
  6. How should I inject a DbContext instance into an IHostedService?
  7. Convert JSON String to JSON Object c#
  8. ASP.NET use SqlConnection connect MySQL
  9. Ajax method call
  10. What is the right way to populate a DropDownList from a database?
  11. checking user name or user email already exists
  12. How to implement reCaptcha for ASP.NET MVC? [closed]
  13. Does Dispose still get called when exception is thrown inside of a using statement?
  14. Quartz.net setup in an asp.net website
  15. System.IO.File.Create locking a file
  16. how to generate a unique token which expires after 24 hours?
  17. Reading FromUri and FromBody at the same time
  18. Call and consume Web API in winform using C#.net
  19. How to share sessions between PHP and ASP.net application?
  20. asp.net asmx web service returning xml instead of json
  21. Get POST data in C#/ASP.NET
  22. Giving application elevated UAC
  23. Run command line code programmatically using C#
  24. Regex for Money
  25. DisplayFormat ApplyFormatInEditMode
  26. How do static properties work in an asp.net environment?
  27. Creating download link to a file on a file server
  28. Looping through GridView rows and Checking Checkbox Control
  29. How to reorder columns in gridview dynamically
  30. See if user is part of Active Directory group in C# + Asp.net

Leave a Comment