Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
DataSet Filter
Migrateduser
Hi,
I am converting a crystal report to BIRT, in which the crystal report has a report selection filter condition as below :
if {Customer.Country} = "USA" then {Customer.Customer Name} = ["7 Bikes For 7 Brothers","Against The Wind Bikes","Bicycle Races","Bikefest"]
else if {Customer.Country} = "England" then {Customer.Region} = ["Greater Manchester","Devon","West Yorkshire"]
else if {Customer.Country} = "Switzerland" then {Orders.Order Date} < date(2004,1,1) and {Orders.Order Amount} < 1000
else
{Customer.Country} in ["Australia", "Brazil", "Canada", "China", "France", "Germany", "Italy", "Japan", "Mexico", "New Zealand", "Singapore", "Switzerland", "Portugal"] and
{Customer.Region} <> "Ile de France" and
{Customer.Customer Name} <> "Fahrkraft R?der"
In BIRT report, I am unble to set this filter condition in the dataset filter.
Please help if anybody have idea on such type of dataset filtering.
Thanks in advance.
Rajani Gunda.
Find more posts tagged with
Comments
There are no comments yet