First record is repeated

jima66

First record is repeated multiple times in the report (not use subreport)

ipong

have you set datasource in databand?

jima66

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

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

jima66

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

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

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