Report Design Question

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

I need to create a report with information about active projects in my
company. There are 4 categories of projects.

About 80% of the info I need on my report is the same for all projects,
20% differs by project category.

I need a combined report for all of the projects that will group the
projects together by category and then alter the headers (for the 20%
difference) depending on what project type it is printing.

Is subprojects the best way to do this? Do I have to run queries up
front to separate the data to use a a source for each subproject?

I am new to access and don't want to waste time on a poor design.

Thanks,
Ben
 
Hi Ben,

Try this:

make a query that gathers data from all the tables you are reporting from

Make a report with the wizard based on your query

The wizard will ask what you want to GROUP by... choose your Category
field and then your Project Type field

After the wizard is done, look at the design...

in the Project Type section, move the Project Type over to the right and
then drag the Category field down to the Project Type section (I like to
do this in case the category spans several pages)

"Is subprojects the best way to do this?"

You can use a subreport -- it really depends on your data and how you
want to look at it ... hard to say since you did not provide more
specific information.

"I am new to access and don't want to waste time on a poor design."

Great! Fire away with your questions! Good design is most important!

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*
 
Back
Top