Page 1 of 1

Default the FilterEngine to SQLFilter?

Posted: Fri Nov 25, 2011 2:14 am
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.

Default the FilterEngine to SQLFilter?

Posted: Fri Nov 25, 2011 5:11 am
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.