filter from c# code

akki

Hello FS team,

is there a way to filter report using something like report1.filterString="[Customer.CustCode] in ('A001','A002')" from c# code runtime.

remember i don't want to use your dialog form for this, because i want to print report directly without showing it which i m doing right now with CrystalReports and Devexpress reports and they both have runtime filterString property to filter data runtime.

right now i m evaluating your reports for the testing purpose.

kindly give me suggestion

ipong

there are 2 kind of models :
1. pull data from fastreport
Yes, you can do filtering data at query level, database connection string is defined in frx file.
https://www.fast-report.com/en/forum/index....tabledatasource

2. push data from desktop/web project to fastreport
filtering is available by modifying databand filter property, the syntax is not like sql syntax.

internally, fastreport put data in TableDataSource class => table property (datatable type), i already tried to manipulate the datatable with no success.

DataTable dt = (Report.GetDataSource("YourDataSourceName") as TableDataSource).Table;

akki

ipong wrote: »

there are 2 kind of models :
1. pull data from fastreport
Yes, you can do filtering data at query level, database connection string is defined in frx file.
https://www.fast-report.com/en/forum/index....tabledatasource

2. push data from desktop/web project to fastreport
filtering is available by modifying databand filter property, the syntax is not like sql syntax.

internally, fastreport put data in TableDataSource class => table property (datatable type), i already tried to manipulate the datatable with no success.

DataTable dt = (Report.GetDataSource("YourDataSourceName") as TableDataSource).Table;

ThanX for the reply dear