Solved

providing sql username & password to crystal report in asp.net c#

Posted on 2010-08-15
3
505 Views
Last Modified: 2012-05-10
i have a crystal report in asp.net & c#

the rpt file has the sql query with groupings as i require

what i want to do is to provide ONLY the sql username & password using C# code

please note i want to supply just the username & password... NOT wanting to fill the report with a dataset or whatever
CrystalReportViewer1.ReportSource = "BrokerageConsolidatedMonthHO.rpt";

CrystalReportViewer1.SelectionFormula = "Month ({table1.cmonth})=5" + ;

Open in new window

0
Comment
Question by:RakeshBhandari
3 Comments
 
LVL 14

Accepted Solution

by:
Dhanasekaran Sengodan earned 500 total points
ID: 33443603
0
 
LVL 7

Expert Comment

by:alphaau
ID: 33443765
Please refer to the enclosed method, it can change the datasource, userid, password and databasename of a ReportDocument (support sub-report)

and you can get there information from web.config
            System.Data.SqlClient.SqlConnectionStringBuilder SConn = new System.Data.SqlClient.SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
           
            SetCRLogOnInfo(rptDoc, SConn.DataSource, SConn.UserID, SConn.Password, SConn.InitialCatalog);
        public void SetCRLogOnInfo(ReportDocument mainInRD, string dataSource, string userId, string pwd, string DatabaseName)

        {

            //do the main reports database

            TableLogOnInfo logonInfo = null;



            foreach (CrystalDecisions.CrystalReports.Engine.Table table in mainInRD.Database.Tables)

            {

                logonInfo = table.LogOnInfo;

                logonInfo.ConnectionInfo.ServerName = dataSource;

                logonInfo.ConnectionInfo.DatabaseName = DatabaseName;

                logonInfo.ConnectionInfo.UserID = userId;

                logonInfo.ConnectionInfo.Password = pwd;

                table.ApplyLogOnInfo(logonInfo);

            }

            try

            {

                //now update logon info for all sub-reports

                if (!mainInRD.IsSubreport && mainInRD.Subreports != null && mainInRD.Subreports.Count > 0)

                {

                    foreach (ReportDocument rd in mainInRD.Subreports)

                    {

                        SetCRLogOnInfo(rd, dataSource, userId, pwd, DatabaseName);

                    }

                }

            }

            catch

            {

            }

        }

Open in new window

0
 
LVL 2

Author Closing Comment

by:RakeshBhandari
ID: 33498453
thank you!
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

Today is the age of broadband.  More and more people are going this route determined to experience the web and it’s multitude of services as quickly and painlessly as possible. Coupled with the move to broadband, people are experiencing the web via …
Introduction Hi all and welcome to my first article on Experts Exchange. A while ago, someone asked me if i could do some tutorials on object oriented programming. I decided to do them on C#. Now you may ask me, why's that? Well, one of the re…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now