Dynamic Horizontal Columns

[2005 IR Help]

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