Default the FilterEngine to SQLFilter?

Stimulsoft Reports.WEB discussion
Post Reply
hunter
Posts: 20
Joined: Thu Sep 08, 2011 7:13 pm
Location: Sydney, AUS

Default the FilterEngine to SQLFilter?

Post by hunter »

Is it possible to change the default of the Filter Engine in the Databand to SQLFilter ? I couldn't see anything in StiWebDesignerOptions for this.

For most reports I think it is bad to use the ReportFilter as that would need to pull all of the table data to the web server to filter it. 99.9% of the time i would filter on the database.

BTW, I have also had problems getting the variables to work in the ReportFilter. SQLFilter works fine, in .1106.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Default the FilterEngine to SQLFilter?

Post by HighAley »

Hello.
hunter wrote:Is it possible to change the default of the Filter Engine in the Databand to SQLFilter ? I couldn't see anything in StiWebDesignerOptions for this.

For most reports I think it is bad to use the ReportFilter as that would need to pull all of the table data to the web server to filter it. 99.9% of the time i would filter on the database.

BTW, I have also had problems getting the variables to work in the ReportFilter. SQLFilter works fine, in .1106.
There is no such option. You should do it in your code.

Thank you.
Post Reply