Desperate: RePost

[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

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

 

[Tom Wickerath]

Hi Brian,

Have you tried using a subreport for displaying the Funds?


Tom
__________________________________________


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

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

 

[imbd4a]

Thanks Tom,

I think that might do it. That was the lead I needed!