Multi-Column Report Question

rbuser

I have a report that a want to get to look like the following:

Account # Amend#1 Amend#2 ... Amend#n

The Account# will be the same for all of the amendments and the
amendments should each be in there own column. When the amendments run
out of room on the line, they should go to a new page and finish there.
However, on the next line, the next account should show up. So for
example, the report may look like this:

Page 1:
Account # Amend#1 Amend#2 Amend#3
1 10 12 14
2 0 5 10

Page 2:

Account # Amend#4 Amend#5
1 20 21
2 30 31

I am at a loss as to how to do this. Any ideas?

nardmoseley

1. You might be able to configure the report to have N number of columns
where the column layout looks like: Account# Amend#, and in column 1 set the
Account# to visible of true and for other columns set it to visible of
false.

2. Another solution might be to build a spread sheet style report like the
one shown in this example:

www.digital-metaphors.com/tips/SpreadsheetStyle.zip

You may need to pre-process the data and build some temp tables.



--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com