Izenda, LLC

Ad Hoc Reports & Dashboards for ASP.NET Apps

Free Trial
Chat

Izenda Reports is licensed on a "per user" or "per server" basis. Please complete this form to receive a price quote.

All fields are required.

The live demo demonstrates Izenda reports with the Northwind Sample database. To login, please register below.

All fields are required.

Please register to try Izenda reports on your data today.

All fields are required.

Izenda Customer Portal

Home Search
Welcome Guest ( Login )
Most Popular
Home » FAQ » Questions » Can I inject SQL "Where Clause" or other expressions into a query...

Can I inject SQL "Where Clause" or other expressions into a query...

Expand / Collapse
 

Can I inject SQL "Where Clause" or other expressions into a query or queries?


Yes,

Lets say you have the following situation:

You have  2 views, invoices and payments. But when you run a report where the invoice date is a range and you want to display any blank payments also included in this report, you will have an issue where the payment date will show blanks if the payment amount is blank.

There are 2 basic ways to address this problem.

Method 1

In your filter, select "Use Previous Or" to bring in payments.

Method 2

You can also use the Sql Override property in the PreExecuteReportSet method to inject a 'Where' clause.  Please see the hidden filter with Sql Override section in this article.
 



Details
Type: How-To
Options



Contact us: 1-888-493-6321 (1-888-IZENDA1) - 26 Executive Park Drive STE 2650 Atlanta, GA 30329

Copyright 2011 © Izenda, LLC