Win a copy of Event Streams in Action this week in the Java in General forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Devaka Cooray
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Paul Clapham
  • Knute Snortum
  • Rob Spoor
Saloon Keepers:
  • Tim Moores
  • Ron McLeod
  • Piet Souris
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Frits Walraven
  • Ganesh Patekar

Jasper report: How to suppress the total column of a crosstab for specific column group

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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



 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!