I am trying to test out a report that is much like the Table as Datasources example but with a TADODataSource connected to SQL Server.
ConnectionString: Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyTestDatabase;Data Source=.\SQLEXPRESS;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=DESKTOP-544L2GV;Use Encryption for Data=False;Tag with column collation when possible=False;
Everything seems to connect ok when setting the TADODataSet component to active.
I have one TADODataSet component named "Orders" with a TDataSource component.
My Excel template only has a single line in it <#Orders.ID> in hopes to just get a list of OrderIDs for now. When I run the report I am getting the following error:
Project Monthly_Report.exe raised exception class EFlexCelCoreException with message 'The expression "Orders.ID" on the Excel template refers to DataTable "Orders" which is not defined. Verify that the cell with the expression is inside a "Orders" or similar named range.'.
The Table as Datasources example works fine so I am at a loss as to what might be different or if there is something that could be not supported. Thanks
I am using Delphi 11.3 with FlexCel 7.17.