Assign list data to report problem

Mike193 · February 2025

I try to use designer to create report, as need to debug purpose, from the report will connect my mssql database to get fields and column, so the report.frx will be like

</TableDataSource>

</MsSqlDataConnection>

In the dotnet, for load this report, I don't need to pass sql connection to this report, just use report.load(dataObjects, "BS");

from frx I remove <MsSqlDataConnection Name="Datasource" ConnectionString="...."> </MsSqlDataConnection>

but finally , it's throw the exception which said

FastReport.Utils.DataTableException: BS: Table is not connected to the data. Register the data using Report.RegisterData method.

at FastReport.Data.TableDataSource.LoadData(ArrayList rows)

at FastReport.Data.DataSourceBase.LoadData()

at FastReport.Data.DataSourceBase.Init(Relation relation, String filter, SortCollection sort, Boolean useAllParentRows)

at FastReport.Data.DataSourceBase.Init(DataSourceBase parentData, String filter, SortCollection sort, Boolean useAllParentRows)

for this case, how to handle it ?

stg · 10:54AM

Hello!

The DataTableException: ‘Table is not connected to the data’ occurs because simply removing the <MsSqlDataConnection> tag leaves a TableDataSource object within the .frx file with Name="Table", Alias="BS" and a reference to a non-existent connection, instead of a source with ReferenceName="Data.BS".

The simplest and most reliable approach is not to edit the XML manually, but to switch the source programmatically immediately after Load():

using var report = new Report();
report.Load(‘template.frx’);

// Remove old database connections and the unbound TableDataSource
foreach (var conn in report.Dictionary.Connections.ToArray())
report.Dictionary.Connections.Remove(conn);

if (report.GetDataSource(‘BS’) is DataSourceBase oldDs)
report.Dictionary.DataSources.Remove(oldDs);

// Register a list of objects with the same alias and rebind the DataBand
report.RegisterData(bsList, ‘BS’);
var newDs = report.GetDataSource(‘BS’);
newDs.Enabled = true;
((DataBand)report.FindObject(‘Data1’)).DataSource = newDs;

report.Prepare();

Assign list data to report problem

Comments