creating dynamic reports for different databases

anneline · September 26th, 2003, 07:38 AM

Hi.

I want to be able to create dynamic reports for different databases.

By that I mean... I want the user to enter the servername,databasename,userid, password and this gets read in and this is the info that connects the .net application to the database.
Then, with this info being connected to the database, I want to be able from the crystal report(.rpt) be able to extract the necessary table info without having to go through the DB connection wizard on the report!

Can someone advise me on this?:(

anees81 · September 26th, 2003, 11:42 PM

ok there are two models that .Net provides.
one is Pull Model and other is Push Model.
Pull Model is one which u used to Connect ur report through wizard.
push is little bit complex but provides great flexbility. so firts create Dataset, populate it with data from database manuulay(through coding) an then assign this dataset object to ur report datasource property. ur report object will automatically exract rows from it.

melvik · September 27th, 2003, 12:52 AM

Dear friend:
I guess there is no hard part on this topic if u know what u'll do!
well, first u need a form to get User & server & ... info that u need from user. so then u'll pass those to ur report page & connect to ...
im going to send u a sample & hope it wull help u to connect to DB.

let me know what u've done.

Code:

    public class showreps : System.Web.UI.Page
    {

        //CR Variables
        Empower.reports.foreign        crReportft;
        Empower.reports.foreign_p    crReportfb;
        ConnectionInfo crConnectionInfo;
        TableLogOnInfo crTableLogOnInfo;
        Database crDatabase;
        Tables crTables;
        ParameterFields crParameterFields;
        ParameterField crParameterField;
        ParameterValues crParameterValues;
        ParameterDiscreteValue crParameterDiscreteValue;
        protected CrystalDecisions.Web.CrystalReportViewer CrystalReportViewer1;
        protected CrystalDecisions.Web.CrystalReportViewer CrystalReportViewer2;

        private void Page_Load(object sender, System.EventArgs e)
        {
            string id, type;
                    id = Request.QueryString.Get("id");

                    crReportft = new Empower.reports.foreign();
                    crConnectionInfo = new ConnectionInfo();
                    crConnectionInfo.ServerName = "BORNA";
                    crConnectionInfo.DatabaseName = "NewBaz";
                    crConnectionInfo.UserID = "report";
                    crConnectionInfo.Password = "";

                    crDatabase = crReportft.Database;
                    crTables = crDatabase.Tables;

                    foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
                    {        
                        crTableLogOnInfo = crTable.LogOnInfo;
                        crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
                        crTable.ApplyLogOnInfo(crTableLogOnInfo);
                    }

                    crReportfb = new Empower.reports.foreign_p();
                    crConnectionInfo = new ConnectionInfo();
                    crConnectionInfo.ServerName = "BORNA";
                    crConnectionInfo.DatabaseName = "NewBaz";
                    crConnectionInfo.UserID = "report";
                    crConnectionInfo.Password = "";

                    crDatabase = crReportfb.Database;
                    crTables = crDatabase.Tables;

                    foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
                    {        
                        crTableLogOnInfo = crTable.LogOnInfo;
                        crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
                        crTable.ApplyLogOnInfo(crTableLogOnInfo);
                    }
                CrystalReportViewer1.ReportSource = crReportft;
                CrystalReportViewer2.ReportSource = crReportfb;
        }
    }

Always:),
Hovik Melkomian.