Monday, December 10, 2012

How to filter the data in Crystal report


Crystal Report viewer control is providing selection information property
Syntax:CRV.SelectionFormula="Criteria"

Here i will give some examples to filter the data in reports
Query based on numeric
CRV.SelectionFormula="{emp.deptno}=10"
Query based on string
CRV.SelectionFormula="{emp.nob}"="head"
Query based on date
CRV.SelectionFormula="{emp.expDate}"="#11/12/2012#"
We can use operators  >,<,in,like etc to filter the data.

No comments:

Bel