Hiding tables / showing specific ones.

Comments

• AlexTZ

  October 2009 edited 10:00PM

  Sorry, there is no way to hide some tables, if you pass a connection object. You may use a DataSet, there is no need to fill it with data - FastReport will automatically fill only tables that are needed in a report.
• trinode

  October 2009 edited 10:00PM

  Can you explain how I'd do this?
  
  I can make an empty dataset, and pass it to FR, but then where will it get the data?
• AlexTZ

  October 2009 edited 10:00PM

  If you make a DataSet using Visual Studio, it will generate a DataAdapter for each table. FR will use it to fill a table.
• trinode

  October 2009 edited 10:00PM

  AlexTZ wrote: »

  If you make a DataSet using Visual Studio, it will generate a DataAdapter for each table. FR will use it to fill a table.

  
  ah, ok, is this possible in code? - Starting with an odbcconnection, then what?
• AlexTZ

  October 2009 edited 10:00PM

  I think it's not suitable in your case. I will add an event that you can use to filter the tables.
• trinode

  October 2009 edited 10:00PM

  AlexTZ wrote: »

  I think it's not suitable in your case. I will add an event that you can use to filter the tables.

  
  That sounds like a great solution! Thanks!
• AlexTZ

  October 2009 edited 10:00PM

  You will be able to do this in the next daily build (tomorrow):
  

  Config.DesignerSettings.FilterConnectionTables += DesignerSettings_FilterConnectionTables;
       
       private void DesignerSettings_FilterConnectionTables(object sender, FilterConnectionTablesEventArgs e)
       {
         if (e.TableName == "Table 1")
           e.Skip = true;
       }