David Emerson
davide at dalyn.co.nz
Mon Feb 3 18:59:00 CST 2003
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 DALYN Software Ltd 25b Cunliffe St, Johnsonville Wellington, New Zealand Ph/Fax (877) 456-1205