Creating reports and dashboards | Stimulsoft community forum

Code: Select all

using (SqlConnection connection = new SqlConnection(sqlConnectionString))
{
      SqlCommand myCommand = new SqlCommand("select * from Table_2", connection);
      SqlDataAdapter dataAdapter = new SqlDataAdapter(myCommand);
      DataTable dataTable = new DataTable("Table_2");
      dataAdapter.Fill(dataTable);
      StiReport report = new StiReport();
      Stimulsoft.Report.Dictionary.StiSqlDatabase db = new Stimulsoft.Report.Dictionary.StiSqlDatabase("myConnection", "");
      db.ConnectionString = sqlConnectionString;
      Stimulsoft.Report.Dictionary.StiSqlSource userSource = new Stimulsoft.Report.Dictionary.StiSqlSource();
      userSource.NameInSource = "myConnection";
      userSource.Name = "UserDataSourse";
      userSource.Alias = "UserDataSourse";
      userSource.SqlCommand = "SELECT * FROM Table_2";
      userSource.CommandTimeout = 3000;
      
      /// Here, users in any way determine the visible columns 
      /// for example
      int[] isVisible = new int[] {1,1,0,0,1};
      int ind = 0;
      
      foreach (DataColumn col in dataTable.Columns)
      {
            if (isVisible[ind] == 1)
            {
                  userSource.Columns.Add(new Stimulsoft.Report.Dictionary.StiDataColumn(col.ColumnName, col.GetType()));
            }
            ind++;
      }
      report.Dictionary.Databases.Add(db);
      report.Dictionary.DataSources.Add(userSource);
      report.Dictionary.Synchronize();
      report.Design();
}