By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,269 Members | 1,561 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,269 IT Pros & Developers. It's quick & easy.

Print group header on report even if no detail?

P: n/a
LF
Hello,

I have a database with a table of projects and a table of tasks (each
project can have multiple tasks). I have a report that has a group
header for the project name, etc., and then the tasks appear in the
Detail section.

Is it possible to have the project information in the group header show
up on the report even if there are no tasks (i.e., no records in the
Detail) for that project? How would I do that?

Thanks for any help.

Aug 1 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
If you set up the query behind the report properly, it's a pretty
simple request.

LF wrote:
Hello,

I have a database with a table of projects and a table of tasks (each
project can have multiple tasks). I have a report that has a group
header for the project name, etc., and then the tasks appear in the
Detail section.

Is it possible to have the project information in the group header show
up on the report even if there are no tasks (i.e., no records in the
Detail) for that project? How would I do that?

Thanks for any help.
Aug 1 '06 #2

P: n/a
LF
ManningFan,
Forgive my limited knowledge, but how would such a query be structured?
Would I somehow have a record for each project in addition to a record
for each task? Right now my query has a record for each task, but
there aren't separate records for the projects.
Thanks.

ManningFan wrote:
If you set up the query behind the report properly, it's a pretty
simple request.

LF wrote:
Hello,

I have a database with a table of projects and a table of tasks (each
project can have multiple tasks). I have a report that has a group
header for the project name, etc., and then the tasks appear in the
Detail section.

Is it possible to have the project information in the group header show
up on the report even if there are no tasks (i.e., no records in the
Detail) for that project? How would I do that?

Thanks for any help.
Aug 2 '06 #3

P: n/a
EP
May be you need to create a new query. Select those tables, create the
relationship and
double click on the relationship and the options pop up allow you to
select the union way.

LF wrote:
ManningFan,
Forgive my limited knowledge, but how would such a query be structured?
Would I somehow have a record for each project in addition to a record
for each task? Right now my query has a record for each task, but
there aren't separate records for the projects.
Thanks.

ManningFan wrote:
If you set up the query behind the report properly, it's a pretty
simple request.

LF wrote:
Hello,
>
I have a database with a table of projects and a table of tasks (each
project can have multiple tasks). I have a report that has a group
header for the project name, etc., and then the tasks appear in the
Detail section.
>
Is it possible to have the project information in the group header show
up on the report even if there are no tasks (i.e., no records in the
Detail) for that project? How would I do that?
>
Thanks for any help.
Aug 2 '06 #4

P: n/a
"LF" <lf****@gmail.comwrote in
news:11**********************@s13g2000cwa.googlegr oups.com:
ManningFan,
Forgive my limited knowledge, but how would such a query be
structured?
Would I somehow have a record for each project in addition to
a record
for each task? Right now my query has a record for each task,
but there aren't separate records for the projects.
Thanks.
Proper database theory says you have one table that contains
project information, and a separate table that contains task
info, ....
You create a relation between the projects and tasks based on
the project ID which defines the project, and is in the tasks
table as a 'foreign key'.

This way, you get the power of having info related to project,
like start/end dates, manager, customer, only entered once, and
a change like a contract end date change is still visible
against all the tasks.

So you should have a projects table, as well as the tasks table.

You can cheat, however, by making a SELECT DISTINCT type query
to extract each unique project, and use that instead of a table,
for now. just join that query back to the tasks table, setting
to join type to left outer. that's the one that would say select
all records from PROJECTS and only records tfom TASKS where the
Project ID is equal, when you double-click the join line in the
upper pane of the query builder. .

ManningFan wrote:
>If you set up the query behind the report properly, it's a
pretty simple request.

LF wrote:
Hello,

I have a database with a table of projects and a table of
tasks (each project can have multiple tasks). I have a
report that has a group header for the project name, etc.,
and then the tasks appear in the Detail section.

Is it possible to have the project information in the group
header show up on the report even if there are no tasks
(i.e., no records in the Detail) for that project? How
would I do that?

Thanks for any help.


--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Aug 2 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.