Tarek.Ghonamy

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

is there a way to have 2 crosstabs inserted next to each others (horizontally) in the title band of the parent report. the problem i am facing is that the second crosstab starts based on it's actual position which makes it overlaps with the first crosstab. I would like to have the second crosstab starts after the first one finishes. it seems that there is no direct way to do this from the studio (the float option works vertically and doesn't work horizontally), does anyone have an idea how this can be done even through the API. note that i am using Jasper 6.7.0