Table is not connected error

Hi,

I have a simple report that is attached to an xml datasource. I can run the report in the designer and it renders correctly but when I run it programmatically it throws the "table is not connected" error (screenshot and report, data attached).

Could anyone please advise how to resolve this?

Thanks


Comments

  • Hello!

    To resolve the issue, update the XmlFile path (and, if applicable, the XsdFile path) for the connection after loading the .frx file:

    var xmlConn = report.Dictionary.Connections.OfType<XmlDataConnection>().FirstOrDefault();
    if (xmlConn != null)
    xmlConn.XmlFile = actualXmlPath;
    

    Alternatively, delete or disable the file-based XmlDataConnection in the .frx file and call `report.RegisterData(dataSet)` ensuring that the `Name` and `ReferenceName` of the tables match exactly, and set `ds.Enabled = true`.

This discussion has been closed.