Multi-column report 1

[jollyreaper]

Crystal XI, looking to do the following:

Read from construction schedule: lot number, task, cost code, vendor

Display format: arranged in columns by day of week.

Group 1 - Week Span -- by day of week
Group 2 - Lot Number
Group 3 - Vendor
Details - Task, Cost Code

The results should look something like this:

Monday | Tuesday | Wednesday
Lot 1 Lot 3
ABC Co. LMNOP Inc.
44421: Drains 23423: Etc.
44312: Sinks
DEF Co.
12321: Fans
21342: Helipad

Lot 2
XYZ Corp.
12312: Lighting

Report will be landscape, 8.5x11. Columns should extend down to multiple pages if necessary, ending when they run out of content. Group 1's next iteration would be with the following week, starting the process over again.

Now in THEORY, this is what's been asked for. I have no idea if it can even be done! My first guess was sub-reports but that would put the performance right in the gutter. Anyone have a good direction to point me in on this? Thanks!

 

[lbass]

First insert a group on {table.date} on change of week. Then create a formula {@week} for linking with subreports:

datepart("ww",{table.date})

Then insert a GH1b section where you will place a separate subreport for each day of the week side by side. For the Monday subreport, use a record selection formula of:

dayofweek({table.date}) = 2//for Tues, use 3, etc.

In each subreport, create a {@week} formula, as above, and link each subreport to the main report by linking the two formulas to each other (edit->subreport links).

In each subreport, add your groups by lot number, vendor, and your detail fields. In the main report, suppress the detail fields and group footer sections.

-LB

 

[shenay921]

lbass -- this was excellent! Thanks!