This is a migrated thread and some comments may be shown as answers.

Setting ODS Parameter Value / Data Explorer

7 Answers 195 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

7 Answers, 1 is accepted

answered on 24 Mar 2010, 11:39 AM

Hello, I have also found the same problem. When the ODS expects parameters (and these are defined in the report with default values set), the Data Explorer will not display the datasource fields. Remove the parameters from the ODS and the fields are displayed in the Data Explorer. This is really annoying.

Here is the ODC method:

    
            public DataTable PlanningMasterData(DateTime StartDate, DateTime EndDate)  
        
                    {  
        
                        string cnn = "DATA SOURCE=xxxx;PERSIST SECURITY INFO=True;USER ID=xxxx;PASSWORD=xxxx";  
        
                        //DateTime StartDate = DateTime.Today.AddMonths(-1);  
        
                        //DateTime EndDate = DateTime.Today;  
        
                        using (Oracle.DataAccess.Client.OracleConnection cn = new Oracle.DataAccess.Client.OracleConnection(cnn))  
        
                        using (Oracle.DataAccess.Client.OracleCommand cmd = cn.CreateCommand())  
        
                        {  
        
                            DataTable dt = new DataTable();  
        
                            Oracle.DataAccess.Client.OracleDataAdapter da = new Oracle.DataAccess.Client.OracleDataAdapter();  
        
                            cmd.CommandType = System.Data.CommandType.Text;  
        
                            cmd.CommandText = OracleSQL.SQLPlanningMaster;  
        
                            cmd.Parameters.Add(new OracleParameter("StartDate", OracleDbType.Date));  
        
                            cmd.Parameters.Add(new OracleParameter("EndDate", OracleDbType.Date));  
        
                            cmd.Parameters["StartDate"].Value = StartDate;  
        
                            cmd.Parameters["EndDate"].Value = EndDate;  
        
                            da.SelectCommand = cmd;  
        
                            da.Fill(dt);  
        
                            return dt;  
        
                        }  
        
                    }

If I remove the two parameters StartDate and EndDate, the report Data Explorer displays all the fields as expected.

Regards,
Jonathan