|
Hola,
Mas indagaciones:
Se puede asignar una Sentencia SQL al Objeto Report, asignandole un DATASET
var
conn : String;
query : String;
midataSet : System.Data.DataSet;
oleConn : OleDbConnection;
oleAdapter : OleDbDataAdapter;
begin
query := 'select * from tabla where Id = 2';
conn := 'Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=XXXX;Data Source=SERVER';
// Use ADO.NET object model to set up the connection
// information.
midataset := dataset.Create;
oleConn := OleDbConnection.Create(conn);
oleAdapter := OleDbDataAdapter.Create;
oleAdapter.SelectCommand := OleDbCommand.Create(query, oleConn);
// Connect to the data source, fetch the data, and disconnect
// from the database.
oleAdapter.Fill(midataset);
.........
self.reportDocument1.Load('xxx.rpt');
self.reportDocument1.SetDataSource(midataset);
self.reportDocument1.Refresh;
Salu2;-)
|