First record is repeated

Comments

• ipong

  July 2018 edited 12:43AM

  have you set datasource in databand?
• jima66

  July 2018 edited 12:43AM

  The report uses a single table that contains 16 rows, when executed from the designer it works ok, showing all the records.
  
  When invoking it from an application C # shows 16 rows, but all with the information of the first article, the code is:
  
  FastReport.Utils.RegisteredObjects.AddConnection(typeof(MySqlDataConnection));
  
  using (Report report = new Report())
  {
  report.Load(@..\test.frx);
  
  MySqlDataConnection conn = new MySqlDataConnection();
  conn.ConnectionString = connStr;
  conn.CreateAllTables(true);
  report.Dictionary.Connections.Add(conn);
  report.RegisterData(bindingSource1, "table1");
  report.GetDataSource("table1").Enabled = true;
  report.Show();
  }
  
  thanks for your reply
  
• ipong

  July 2018 edited 12:43AM

  look at this working example, https://mega.nz/#!w00lXSCL!H8uuUmMJ...Frz5jRbQ8JWrKBc
• jima66

  July 2018 edited 12:43AM

  In the example, the report uses the connection defined at design time, in my case a report defined in the designer passes a mysql connection at run time.
  
  It works well and connects to the data set defined in the connection at run time, but repeats the content of the first item information for all rows.
  
  From:
  https://www.nuget.org/packages/FastReport.Data.MySql/#
  
  example of use:
  
  
  execute the following code once at the application start:
  
  FastReport.Utils.RegisteredObjects.AddConnection(typeof(MySqlDataConnection));
  
  now you should be able to create a new MySQL data source from Designer (.Net 4) or from code:
  
  Report report = new Report();
  report.Load(@YourReport.frx);
  //...
  MySqlDataConnection conn = new MySqlDataConnection();
  conn.ConnectionString = "your connection string";
  conn.CreateAllTables();
  report.Dictionary.Connections.Add(conn);
  
• ipong

  July 2018 edited 12:43AM

  you get mixed up, there are 2 methods of datasource:
  1. push data, from main app, report.registerdata
  don't do this : report.Dictionary.Connections.Add(conn);
  
  2. pull data, define db connection and table in report template
  you can alter the connection string from main app

  FastReport.Report report = new FastReport.Report();
  report.Load("untitled.frx");
  report.SetParameterValue("Parameter1", "CHRISTIAN");
  report.SetParameterValue("Parameter2", "GABLE");
  FastReport.Data.DataConnectionBase connection = report.Dictionary.Connections[0];
  MessageBox.Show(connection.ConnectionString);
  
• emilysmithes

  August 2018 edited 12:43AM

  a. Remove all documents in one go
  
  var duplicates = [];
  
  db.collectionName.aggregate([
  { $match: {
  name: { "$ne": '' } // discard selection criteria
  }},
  { $group: {
  _id: { name: "$name"}, // can be grouped on multiple properties
  dups: { "$addToSet": "$_id" },
  count: { "$sum": 1 }
  }},
  { $match: {
  count: { "$gt": 1 } // Duplicates considered as count greater than one
  }}
  ],
  {allowDiskUse: true} // For faster processing if set is larger
  ) // You can display result until this and check duplicates
  .forEach(function(doc) {
  doc.dups.shift(); // First element skipped for deleting
  doc.dups.forEach( function(dupId){
  duplicates.push(dupId); // Getting all duplicate ids
  }
  )
  })
  
  // If you want to Check all "_id" which you are deleting else print statement not needed
  printjson(duplicates);
  
  // Remove all duplicates in one go
  db.collectionName.remove({_id:{$in:duplicates}})
  
  b. You can delete documents one by one.
  
  db.collectionName.aggregate([
  // discard selection criteria, You can remove "$match" section if you want
  { $match: {
  source_references.key: { "$ne": '' }
  }},
  { $group: {
  _id: { source_references.key: "$source_references.key"}, // can be grouped on multiple properties
  dups: { "$addToSet": "$_id" },
  count: { "$sum": 1 }
  }},
  { $match: {
  count: { "$gt": 1 } // Duplicates considered as count greater than one
  }}
  ],
  {allowDiskUse: true} // For faster processing if set is larger
  ) // You can display result until this and check duplicates
  .forEach(function(doc) {
  doc.dups.shift(); // First element skipped for deleting
  db.collectionName.remove({_id : {$in: doc.dups }}); // Delete remaining duplicates
  })
  Reference - stackoverflow