help with report

M

mcnews

i need to create a report that looks like so:

IDNumber IDType Family1 Family2 Family3 Family4 Family5 Family6


that data for the Family types come from a table called FinalResults
that looks like:

BatchID IDNumber FamilyName Result

a given IDNumber can have Results for any number of Families (1 - 18).

i have to determine the family count for a given Batch.

the headers on the report for Family should be the actual FamilyName.
the client wants the report to fill out the results for 6 families and
all of the IDNumbers.
if there are more than 6 families the remainder will print after the
first 6 have finished.
if more than 12 .....
i have decided to use a temp table to flatten out the data for
results.

how can i get the family headers to be correct if more than 6
families?

thanks
mc
 
Top