Printing detail records horizontally across the top

rbuser

Is there a way to print detail records (probably in a subreport)
horizontally across the page/band. For example: If the detail records
are dates, can they be printed horizontally across. This seems like
something people would be doing a lot, but I can't see how. For example,
if a class meets 10 times, I would want to display 10 columns:
Jan_1 Jan_3 Jan_5 Jan_8 Jan_10, etc....

... and then have the student names listed vertically ("normal" detail
band behavior).

grazie,

Dennis McFall

digitalmetaphors

Sure, set the Detailband.ColumnTraversal property to ctLeftToRight in a
subreport. You could have other subreports below that would print the
student data in vertical columns. I thinkyou'll want lookup datasets for
each column that way it would be easiest to generate the report. Remember,
subreports are ParentWidth by default, so set this to false and you can have
free form subreports anywhere you want, ie. one for each column so they can
print down the page independently.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Jim Bennett (Digital Metaphors) wrote:

Jim:

How do you do this in the End-User environment? I am using a single
TppReport component to load templates from the database. How/where in
the end-user design environment (somewhere on the Calc tab??), can I set
that property. I tried in the DetailBeforePrint of the subreport, but
they still display vertically.


What I am after is:

June1 June8 June15 June22 June29 July 6

Juan Alba
Marco Benitez
Kim Sung
Jean Valais

The dates and the names are being pulled from separate pipelines. The
dates are in their own subreport, whose ColumnTraversal property I
would like to be ctLeftToRight. Setting this property needs to be
something that the user can do in the end-user environment. It's not so
much that I need to be able to do it, as that I need to tell end-users
how they can set this property.

You could have other subreports below that would print the

digitalmetaphors

Here is the example I was thinking of. The key is that the left to right
columns are static height so the subreport needs to be designed to be as
tall as you want it. Notice that the columns wrap. I used RB 7.02 and D6.
The data is DADE - DBDemos Customer- Orders- Items linked dataviews.

http://www.digital-metaphors.com/tips/LeftToRightDetailWithTopToBottomSubDet
ail.zip


Cheers,

Jim Bennett
Digital Metaphors

digitalmetaphors

Whoops, that link is wrapping funny on my newsreader. Here is a shortened
download file:
http://www.digital-metaphors.com/tips/LeftToRightGoingDown.zip

Cheers,

Jim Bennett
Digital Metaphors

rbuser

>>Here is the example I was thinking of. The key is that the left to right

Jim:
Got it working. Thanks. The basic problem was that I had not been aware
of the existence of the Column Traversal property option in Page Setup.


dm