String Type as measure of crosstab in jaspersoft studio

0

sample data

A B C
ACC AWT 344
SV AWT 0
CA AWT 0
CM AWT 2
DR AWT NA
ACC COUNTED 345
SV COUNTED 1
CA COUNTED 0
CM COUNTED 2
DR COUNTED 0

need output in below format

  ACC SV CA CM DR
AWT 344 0 0 2 NA
COUNTED 345 1 0 2 0

 

Attachments: 
teena.mathew's picture
Joined: Sep 21 2021 - 11:09pm
Last seen: 1 week 1 day ago

1 Answer:

0

You'll need two text fields in each crosstab data cell (laying one on top of the other - same size and x/y coordinates) - one with left aligned text for numbers, one with right aligned text for strings. Then use printWhen expressions with some form of 'is numeric' test to determine which to use for each value to display. There are many different ways to perform the 'is numeric' test available.

darth_fader's picture
Joined: Mar 7 2010 - 9:45pm
Last seen: 1 week 2 days ago
Feedback
randomness