Parameters type datatable
loubet_dan
Mexico
Hello everyone, I have a table-like function that receives in its parameters a table type created by user, this in sql works very well, I only fill the table and pass it as a parameter to the table function, and this serves as a wildcard for create any report just fill the datatable and I would pass it to the report as parameter and already there in the report designer I create the query that I want based on that table function that only has the id's that I want, in theory everything is fine but I want pass a datatable as a parameter to the report and not as a registered table, will it be possible?
Comments
Thanks for the help, I think you can not explain it well, in sql I can use table-type parameters created by the user and they work very well in the query and the report is based on an sql query, therefore using code pass this parameter typo table to the query of the report something like this.
rp.Dictionary.Connections.Item (1) .Tables (0) .Parameters.Item (0) .DataType = 30
rp.Dictionary.Connections.Item (1) .Tables (0) .Parameters.Item (0) .Expression = ""
rp.Dictionary.Connections.Item (1) .Tables (0) .Parameters.Item (0) .Value = tablaRpt
TablaRpt is a sqlClient.Recordset
Can this be done?
TableDataSource tds = Report.GetDataSource("Table1") as TableDataSource;
tds.SelectCommand = "SELECT Field1, Field2 FROM Table1 WHERE Field1 < 5;";
https://www.fast-report.com/en/forum/index....c=14113&hl=