Comparison report

rbuser

Hello,

Is there a way to create a report that displays the details from left to
right. For instance I have 2 or more records with each record representing a
year. I want to display the years side by side as shown below.

1999 2000 Year N
-------------------------------------------
Field 1 data data data
.
.
.
Field N data data data

adding to that is there a way to have the last column as a "summary" type.

Thanks,
Ian

digitalmetaphors

You can join the master and detail tables in order to create a calculated
field to sum the data for each year of the master together. You can use
left to right column traversal in a detail subreport to show the details and
then place the summary info in the last column to the right of the
subreport. Resize the subreport to be smaller in width (ParentWidth =
False) so that you can place the summary info next to the subreport
component in the main detail band.


Cheers,

Jim Bennett
Digital Metaphors