Jump to content
Changes to the Jaspersoft community edition download ×

Dynamic Horizontal Columns


2005 IR Help

Recommended Posts

By: Jeffrey S. Hair - jshair

Dynamic Horizontal Columns

2004-10-20 19:54

I need to write a report which appears as follows:

 

Date Acct1 Acct2 Acct3 Acct4 Acct5

10/28/2004 1.0 2.0 3.0 4.0 5.0

10/27/2004 1.2 2.2 3.2 4.2 5.2

....

 

The data is stored in a 3 column table: date, acct_id, amount. The acct_id column maps directly to Acct1, Acct2, Acct3, Acct4, etc.

 

What is the best way to tackle this report? Use sub-reports? I tried defining the report w/ multiple columns. I was able to get the data displayed nicely except for the date column.

 

Also, how do you specify no page breaks? I want the data to be displayed on one page.

 

Thanx,

jsh

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...