horizontal detail records

rbuser

How can I display multiple detail records horizontally, e.g., how to get
a series of dates from the MaintenanceDates table and display them
horizontally (while displaying the Equipment records vertically) (for
manually entering 'X' when the work is done):

Report: Equipment Service Record

------- service date -----------
7/1/2002 8/1/2002 9/1/2002

Compressor #1
Compressor #2
Generator #1
Generator #1
Fan assembly #1
Fan assembly #1


I tried using the CrossTab, but it insists on calculating something....


Thanks,

Dennis McFall

digitalmetaphors

If you have a multi column report and you want to show some labels, you can
force the first column to print labels by performing some draw command magic
as shown in this example:

http://www.digital-metaphors.com/tips/FirstColumnAsLabels.zip

But that doesn't solve the problem where you have items that you want to
print vertically as well. So, create a left to right main report, then
print a subreport with top to bottom turned on in its detailband. You'll
have to create a master detail dataset where the master key is the service
date, so that you print the detail items for that service data only for that
data column. The cells are static height, so you could use a fixed style
subreport.

Cheers,

Jim Bennett
Digital Metaphors