posted 5 years ago
I have a cross tab with 2 column groups, the upper column group have a total column, is there a way to suppress the total column for a specific column value. for example if i have the following query:
> select employee_number, payment_type, payment_name, amount from
> employees emp inner join payments pay on emp.id = pay.employee_id
the query results will look like this:
- 1, earning, basic, 1000
- 1, earning, bonus, 700
- 1, deduction, tax, 300
- 1, deduction, other, 100
in the cross tab the following is defined:
row groups:
- employee number
column groups:
- payment_type
- payment_name
measures:
- amount
i want to display the total column group for earnings but not for deductions so the final report will look like:
----------
**employee number basic bonus total earning other tax**
1 1000 700 1700 100 300
the problem is that the total deduction appears. i haven't find any option that i know about in the studio that can conditionally show the total, may be this can be done from the API . any help is appreciated. note that i am using jasper 6.7.0
