data sources which was registered in the report by a programming method

Comments

• AlexTZ

  March 2010 edited 3:50PM

  Hello,
  
  You may use the following scenario to create a report in webmode:
  http://www.fast-report.com/en/forum/?p=/discussion/6475
• Ozan K. BAYRAM Istanbul

  March 2010 edited 3:50PM

  this doesn't make any sense to me!
  
  what about my scenario?
• AlexTZ

  March 2010 edited March 2010

  In your scenario, there is no datasource at the time when you create a report. How do you create a report with no datasource? You need to put some Text objects on a databand, write something like
  [Table.Column1] [Table.Column2] ...
  in them. You may easily make a mistake because you need to type table/column names, there is no way to drag/drop them.
  Then you need to register a datasource with the "Table" name (because you use this name in the Text objects), and attach the databand to that datasource.
  
  In your case you need to put single Text object on the databand, and write the following text in it:
  [items.Value]
  In your code:

  report.RegisterData(items, "items");
  report.GetDataSource("items").Enabled = true;
  report.Data1.DataSource = report.GetDataSource("items");
  WebReport1.Report = report;
  
• Ozan K. BAYRAM Istanbul

  March 2010 edited March 2010

  i've added [items.value] as label to data band. and saved .frx file as report.
  
  then edit this new class' namespace because it is 'FastRepor' by default
  
  i tried to compile class library and get the following error
  
  Error 7 The name 'items' does not exist in the current context \Sources\MyWise\Reports\DetailedProductGroupList.cs 32 16 Reports
  
  Do i have to add another thing to report? (parameter etc.)
  
  Thanks in advance
• AlexTZ

  March 2010 edited 3:50PM

  I'm afraid this will not work with the "report as a class". You still may use this approach with the report stored as .frx file:
  Report report = new Report();
  report.Load(frxfile);
  report.RegisterData(items, "items");
  report.GetDataSource("items").Enabled = true;
  (report.FindObject("Data1") as DataBand).DataSource = report.GetDataSource("items");
  WebReport1.Report = report;
• Ozan K. BAYRAM Istanbul

  March 2010 edited March 2010

  one of my collegue made it work with both methods. we're having a problem with generic list i think...
  

                  DBDataContext db = new DBDataContext();
  
                  var products = from p in db.Products
                                 select p;
  
                  //as a report file
                  string reportFile = HttpContext.Current.Request.MapPath(HttpContext.Current.Request.ApplicationPath) + @"Reports\test.frx";
                  Report report1 = new Report();
                  report1.Load(reportFile);                
                  report1.RegisterData(products.AsEnumerable(), "Products");
                  ((DataBand)report1.Pages[0].ChildObjects[2]).DataSource = report1.GetDataSource("Products");
                  report1.Prepare();
                  reportViewer.Report = report1;
  
                  //as a class
                  FastReport.test report = new test();
                  report.RegisterData(products.AsEnumerable(), "Products");
                  report.dataProducts.DataSource = report.GetDataSource("Products");
                  report.Prepare();
                  reportViewer.Report = report;
  
• magm710912

  March 2010 edited 3:50PM

  AlexTZ wrote: »

  I'm afraid this will not work with the "report as a class". You still may use this approach with the report stored as .frx file:
  Report report = new Report();
  report.Load(frxfile);
  report.RegisterData(items, "items");
  report.GetDataSource("items").Enabled = true;
  (report.FindObject("Data1") as DataBand).DataSource = report.GetDataSource("items");
  WebReport1.Report = report;

  
  Hi, I newbi, I,m intented use this code, but my report have a group and sendme this error en de web
  GroupHeader1): error BC30034: Bracketed identifier is missing closing ']'.
  (Text4): error BC30451: Name 'nomina' is not declared.
  
  have declare datasource for gruop elements and footer ?, how declare ?
  
  regaders
• AlexTZ

  March 2010 edited 3:50PM

  Hello,
  
  Probably you make a type in the tablename.columnname in your report, or you have not registered the datasource with the correct name. I need a test application from you to find an error. If you able to create such application, please send it to tz@fast-report.com.