Tag: birt

How to replace a column result if null with another column result in BIRT

birt expression expressionbuilder java sql

I would really appreciate some help with a computed column using an expression in Birt. I have two columns which are giving results, one gives email addresses and one gives contact numbers: telephone, mobile.. When the email result is null then the contact number column shows a number, these are separate communication methods from a table in sql. What I

Correct way to get data for BIRT reporting

birt mysql olap sql

We have a system which contains 4 Hierarchies. 1. Senior Manager 2. Manager 3. Supervisor 4. Employee Data related to all these are stored in different tables with respective details. There is a single address table which contains address of all these hierarchies. Sample Data Set We would be able to do a count on each IDs by City, State