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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |