How do I make a Report with always different Fields?

rbuser

Hi

I need to be able to print Time Sheets. The Job Nos are Fields and the days
for each month are records.

The Table to be printed is built in code from a global TimeSheet table that
has records with date, time, user and jobno. The Table has different fields
for different users and indeed for each user the jobs worked on change each
month.

How do I produce a report with a changing number of fields? Also, will a
second sheet (and third etc) automatically be generated if there are too
many fields to fit on the first sheet?

Thanks.

Rob.

digitalmetaphors

You'll have to build the report in code. If you want a spread sheet style
report, then this will also require special coding. Here is an example
which builds a report from a supplied dataset.
http://www.digital-metaphors.com/tips/CreateReportFromDataset.zip

Here is a demo which create a spread sheet style report. Basically you have
to generate subreports over the same dataset by splitting hte fields used
over multiple subreports so that they can all be printed. Then you have to
reorder the pages from each subreports so that the fields printed for each
subreport are combined one after the other. For example, subreport 1 prints
to completion, then subreport 2 prints to completion. Then the first page
from subreport 2 needs to be placed after the first page from subreport one
in order to make the actual second page of the first record.
http://www.digital-metaphors.com/tips/SpreadsheetStyleReport.zip

Cheers,

Jim Bennett
Digital Metaphors

rbuser

Thanks Jm

I'll have a look at the links.

Rob.