Saturday, March 22, 2014

Crystal Reports in Visual Studio (C#,ASP.NET)

Crystal Reports  for Visual Studio 2010 is version 13
 and use version 10.5 for Visual Studio 2008

Getting Started with Crystal Reports for Visual Studio 2010

Tutorials for Crystal Reports for Visual Studio 2010 »
Service Pack 1:

Crystal Reports for Visual Studio .NET 2010 - Support Pack 1


Database Login Problem In Crystal Reports
http://www.google.co.in/search?q=database+login+in+crystal+report+viewer&hl=en-IN&gbv=2&oq=data+base+login+&gs_l=heirloom-serp.3.0.0i13j0i13i10j0i13l8.1246482.1250850.0.1252293.16.15.0.0.0.0.365.2823.5j2j5j3.15.0....0...1ac.1.34.heirloom-serp..9.7.820.-y8Y7o-j9iI

About Crystal Report Useful Link
http://1800thenerd.wordpress.com/2010/11/24/sap-crystal-reports-for-visual-studio-2010-files-needed-to-download/

Set Crystal Reports Location Dynamically

http://stackoverflow.com/questions/12002957/how-to-set-database-login-infos-connection-info-for-crystal-report


ConnectionInfo crconnectioninfo = new ConnectionInfo();
    ReportDocument cryrpt = new ReportDocument();
    TableLogOnInfos crtablelogoninfos = new TableLogOnInfos();
    TableLogOnInfo crtablelogoninfo = new TableLogOnInfo();

    Tables CrTables;

    crconnectioninfo.ServerName = "localhost";
    crconnectioninfo.DatabaseName = "dbclients";
    crconnectioninfo.UserID = "ssssssss";
    crconnectioninfo.Password = "xxxxxxx";  


  cryrpt.Load(Application.StartupPath + "\\rpts\\" + dealerInfo.ResourceName);

        CrTables = cryrpt.Database.Tables;

        foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
        {
            crtablelogoninfo = CrTable.LogOnInfo;
            crtablelogoninfo.ConnectionInfo = crconnectioninfo;
            CrTable.ApplyLogOnInfo(crtablelogoninfo);
        }


        cryrpt.RecordSelectionFormula = getCustInfoRptSelection();
        cryrpt.Refresh();

        allReportViewer.ReportSource = cryrpt;

No comments:

Post a Comment