Parameters type datatable

loubet_dan

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?

ipong

https://www.fast-report.com/en/forum/index....mp;hl=parameter

loubet_dan

http://www.fast-report.com/en/forum/?p=/discussion/14394 wrote:

https://www.fast-report.com/en/forum/index....mp;hl=parameter[/url]

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?

ipong

build your own select command :
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=