A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Report Design Problem



 
 
Thread Tools Display Modes
  #1  
Old August 8th, 2004, 02:32 PM
imbd4a
external usenet poster
 
Posts: n/a
Default Report Design Problem

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




  #2  
Old August 8th, 2004, 09:02 PM
Jeff Boyce
external usenet poster
 
Posts: n/a
Default Report Design Problem

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.

--
Good luck

Jeff Boyce
Access MVP

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Display Parameter from Form on Report sara Setting Up & Running Reports 10 July 19th, 2004 04:54 PM
Save Report With CreateReport Coding Issue Jeff Conrad Setting Up & Running Reports 8 July 12th, 2004 08:39 AM
Problem with a report Running & Setting Up Queries 3 June 16th, 2004 09:50 PM
Report Wizard Problem vikash General Discussion 1 June 16th, 2004 12:45 PM
Problem with filtering report Sunny Setting Up & Running Reports 1 May 24th, 2004 08:05 PM


All times are GMT +1. The time now is 10:05 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.