Details in column

rbuser

Hi,

Can we print details in column?
I.e. if I have data like this:
Day Total Transaction Unit sold
1 50 100
2 5 99
3 14 124
4 10 50
....
31 30 150

How do I show it in this order:
Day 1 2 3 4 .....
8
Total Transaction 50 5 14 10
Unit Sold 100 99 124 50

Day 9 10 11 12 ..... 16
Total Transaction 50 5 14 10
Unit Sold 100 99 124 50

...

Day 25 26 27 28 ..... 31
Total Transaction 50 5 14 10 30
Unit Sold 100 99 124 50 150

I remember reading that report builder has a feature to print details in
columns, can someone shed me a light?

TIA,
Karnel

digitalmetaphors

You can set the DetailBand.ColumnTraversal property to ctLeftToRight. There
is one problem though, the subreport LeftToRight traversal setting in a
detail subreport is broken but has been fixed for the next release. It
should work if you aren't using subreports to print the column data lef tto
right.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Thanks a lot, Jim.
Unfortunately I'm using subreport, what's the problem in subreport?
I've already tried, and am quite happy with that.
But there is another problem, how do I print the header at the first column
only, so that it looks like:

Day 1 2 3 ...........
Total 10 5 8
Unit Sold 20 100 77

Karnel

rbuser

If I drop the label and text on detail band, it will show both label and
text for every record.
Day 1 Day 2 Day 3
Total 10 Total 5 Total 8 .............
....

Where should I drop the label? Or is there any trick to do it? Making it
invisible doesn't help.

Thanks,
Karnel

digitalmetaphors

You can set Subreport.ParentWidth := false. Resize it in the main report so
that you can place the labels in the main report next to the subreport.

If this doesn't work out, you can try adding a column and updating the draw
commands to have labels on the left side of the page. Here is a demo:
http://www.digital-metaphors.com/tips/FirstColumnAsLabels.zip


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Hi, Jim.
Thanks for the demo.
However, I still couldn't do it in my report.
The second record is printed next to the labels, but the first one is always
printed below the labels, overlapping other record.
And failed on setting the labels to be visible on the next line.
The result is something like:

Day 2 3
Total 10 3
Unit 55 40
4 5
15 9
80 50 ....

With first record printed at the same position as record 4 (day 4).

Can you show me what am I missing, any properties?

Thanks a lot, Jim.
Karnel

digitalmetaphors

Ok, you want them to print all the way down. To get the labels to reprint,
you could create a group around the main report detail band so that it
prints once a week. Maybe a master-detail configuration linking on a
calculated "day of week" field. The detail subreport in the detail band
will have to print 7 records, for the week. Place the labels in the detail
band next to the subreport. The goal of this approach is for the subreport
to generate left to right 7 records across every time the main report detail
band prints.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

YES!! Finally.
Thanks, Jim.

Karnel