Report Design Problem

[imbd4a]

Morning folks

..

Well I'm at my wits end on this one. I have been trying to resolve this
report design for a while now but can't seem to get it. I'm sure there must
be a way but I sure I don't what it is. I have tried several approaches but
to no avail.



I am work on the reports for my database. I have basically 3 main tables I
am working with. The ActionStep table has a unique ID and all of the other
tables have a reference ID to it.

§ tblActionSteps

§ tblMilestones

§ tblFunding



My base report needs to show each ActionStep in the database on each page
with it's number, description and it's relative information all listed at
the top of the page. No Problem. I have used a group header [AS_ID] to do
this.



I then need to list below that all of the Milestones related to each
ActionStep. No Problem. I used a group header [MS_ID] to do this.



I need it to look Like This:



ACTION STEP: 201



Develop program..



Persons Responsible: Bob Mary
Alice

John
Sue



MILESTONES:



1. Complete study

2. Write report

3. Publish Findings



Funds:



Grant $ 5,000

Billings $ 10,000

Other $ 1,500





When I try and design the report for the funding section to lists all the
funding sources and amount for each ActionStep I cannot get it to do it.
All of my attempts thus far have been futile. I tried several different
approaches but continue to get the Funding info interspersed with the
Milestone data or I get multiple duplicate Funding listings. I've tried to
use the "Detail" section, It's own group header , rework the query design
etc. but still can't seem to get it listing the way I need it.



Any suggestion or help is greatly appreciated.



Thanks



Brian

 

[Jeff Boyce]

Just a thought...

From your description it sounds like you might be able to use subreports to
show different aspects of the total information you want to convey.