newbie layout question

[ktrinad]

By: abangkisp - abangkisp

newbie layout question

2003-01-27 21:13

Hello..

 

i have the data in the database look like this

 

Account Group | Account Number

-------------------------------------------------

1 | 11

1 | 12

2 | 21

2 | 22

2 | 23

3 | 31

3 | 32

 

I want the data to be categorized by the accountGroup. And replace the number with my own label. The text is fix, 1 for house, 2 for car, and 3 for animals

 

So the report will look like this

 

House

11

12

 

Car

21

22

23

 

Animals

31

32

 

could anyone help me?

 

TIA

 

 

 

 

By: Mark Rhodes - mrhodes2

RE: newbie layout question

2003-01-27 22:57

It is best to handle this in your query or view. Create a new table called Accountgroupnames and add to your view/query.

 

accountgroupname is a table with two fields;

 

accountgroup

accountgroupname

 

sample query:

 

select accountgroup,accountnumber,accountname from accounts as a inner join accountgroupnames as b on a.accountgroup = b.accountgroup order by accountgroup,accountnumber

 

1 | 11 | house

1 | 12 | house

2 | 21 | car

2 | 22 | car

2 | 23 | car

3 | 31 |animal

3 | 32 |animal

 

In your report add a band/group on accountgroup and add the accountgroupname field your accountgroup band of your report.

 

If this were really only limited to the 1,2 and 3 you could create a new variable in jasper.

 

new String($F{accountgroup}.intValue()==1?"house":($F{accountgroup}.intValue()==2?"car":"animals"))

 

but as you can see this could get ugly if you had 5 or more of these to lookup and any time you added a new accountgroupname you would have to edit the report XML and recompile your report. Lookup the ? operator in a java manual for a more complete explanation.

 

 

 

 

 

By: abangkisp - abangkisp

RE: newbie layout question

2003-01-29 00:28

thanks

 

i think i use the second one because its fix.

i still need to practice using variable in jasper though.