[AccessD] Report Design Advice required (A97)

Thanks for reply (and to all others as well).  The client has decided that 
they are happy with only one goal on each page so the problem has 
disappeared.  Still - it is more experience for the programmer!

Regards

David Emerson
DALYN Software Ltd
25b Cunliffe St, Johnsonville
Wellington, New Zealand
Ph/Fax (877) 456-1205

At 4/02/03, you wrote:
>David
>A dynamic crosstab sounds right (see the Solutions MDB that comes with
>Access). As far as some comments needing more than one line though that
>should be handled by setting the section and all controls in it to Can
>Grow=Yes. It'll expand if it needs to then.
>
>Andy Lacey
>http://www.minstersystems.co.uk
>
>
>
> > -----Original Message-----
> > From: accessd-admin at databaseadvisors.com
> > [mailto:accessd-admin at databaseadvisors.com] On Behalf Of David Emerson
> > Sent: 04 February 2003 00:58
> > To: accessd at databaseadvisors.com
> > Subject: [AccessD] Report Design Advice required (A97)
> >
> >
> > I have a report which I am not sure the simplest/best way to
> > design and am
> > looking for ideas.
> >
> > I have a table with the following fields:  GoalID, Year,
> > Amount, Comments
> > (Because it is a temporary table created on the fly there is
> > no primary key
> > field)
> >
> > Each Goal has a record for each year.  If there are 5 goals
> > and 10 years
> > then there would be 50 records.
> >
> > The report is to have the following columns:
> > Year, Goal 1 Amt, Goal 1 Comment, Goal 2 Amt, Goal 2 Comment
> > , Goal 3 Amt,
> > Goal 3 Comment, Goal 4 Amt, Goal 4 Comment
> >
> > If there are more than 4 goals then they appear in columns in
> > the next page: Year, Goal 5 Amt, Goal 5 Comment, Goal 6 Amt,
> > Goal 6 Comment etc
> >
> > It is also possible that each column takes up more than 1 page.
> >
> > I think I am needing a main report with the years in the left
> > hand side and
> > then a multi column subreport with the actual goal records.
> > However, it is
> > likely that some of the Comment fields will take more than 1
> > line but not
> > necessarily all the comments for a particular year.  How can
> > I work out if
> > I need to leave lines in the left hand column which has the years?
> >
> > Perhaps some type of cross tab report so that each record is
> > just printed
> > across the page?  In this case, how can I ensure that there
> > are the correct
> > number of columns on the report (there could be anything from
> > 1 to 14 goals
> > (or 1 to 4 pages).  My clients don't want to have the report
> > allow for the
> > max number of goals and then print out blank pages.
> >
> > Any suggestions?
> >
> > Regards
> >
> > David Emerson