Data not to repeat in subreport

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I am hoping this is not a dumb question and theres a simple answer but
for the life of me I can't even come up with an idea on how to do this.

I have a report that I send an individual which includes a subreport that
includes all people associated to an item. Both pull data fine however what
I would like to do is to be able to print the report to an individual without
their name included in the subreport. Is there a way to do this? Below is
an idea of what I am talking about, name1 in the subreport I do not want to
show in the subreport:

(send to) Name1
Mailing address

report guts
[subreport:name1]
[subreport:name2]
[subreport:name3]
[subreport:name4]

I would be so ever greatful to anyone who could answer this one as I dont
want to have to delete this information manually on some 200 reports.
 
The simplest solution would be to use a query that excludes the name before
it gets to the subreport.

Tell us about the RecordSource of the report and subreport. If this is 2
tables (e.g. Table1 feeds the main report, and Table2 feeds the subreport),
you might be able to create a query that uses both tables. Use an outer join
so you get all records from Table1. In the Criteria under the name frield
from Table2:
Is Null OR <> [Table1].[Name1]

Then create a single report (no subreport). In the Sorting And Grouping
dialog (View menu) choose Name1, and in the lower pane of the dialog set Yes
for Group Header. Move all the fields that were in your main report into
this group header, and all the fields that were in the subreport into the
Detail section.
 
Hi Allen, The RecordSource is actually 3 tables [speakers], [speakerdetails]
and [Sessions]. To feed the main report I have a select query that pulls
information from all 3 tables. The subreports record source is the exact
same thing but with a different select query. My problem lies in that for
each speaker they could have more than one session and work with any
combination of other speakers on the same or different sessions.

Allen Browne said:
The simplest solution would be to use a query that excludes the name before
it gets to the subreport.

Tell us about the RecordSource of the report and subreport. If this is 2
tables (e.g. Table1 feeds the main report, and Table2 feeds the subreport),
you might be able to create a query that uses both tables. Use an outer join
so you get all records from Table1. In the Criteria under the name frield
from Table2:
Is Null OR <> [Table1].[Name1]

Then create a single report (no subreport). In the Sorting And Grouping
dialog (View menu) choose Name1, and in the lower pane of the dialog set Yes
for Group Header. Move all the fields that were in your main report into
this group header, and all the fields that were in the subreport into the
Detail section.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

dc said:
Hi, I am hoping this is not a dumb question and theres a simple answer
but
for the life of me I can't even come up with an idea on how to do this.

I have a report that I send an individual which includes a subreport that
includes all people associated to an item. Both pull data fine however
what
I would like to do is to be able to print the report to an individual
without
their name included in the subreport. Is there a way to do this? Below
is
an idea of what I am talking about, name1 in the subreport I do not want
to
show in the subreport:

(send to) Name1
Mailing address

report guts
[subreport:name1]
[subreport:name2]
[subreport:name3]
[subreport:name4]

I would be so ever greatful to anyone who could answer this one as I dont
want to have to delete this information manually on some 200 reports.
Click to expand...
Click to expand...
 
So the main report lists the event and one speaker, and the subreport lists
all the other speakers for that same event?

Could you add a text box to the main report with these properties:
Name txtAlwaysTrue
Control Source -1
and another in the subreport:
Name txtNotTheSameSpeaker
Control Source =([SpeakerID] <> [Report].[Parent].[SpeakerID]
Then set:
Link Master Fields EventID; txtAlwaysTrue
Link Child Fields EventID; txtNotTheSameSpeaker

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

dc said:
Hi Allen, The RecordSource is actually 3 tables [speakers],
[speakerdetails]
and [Sessions]. To feed the main report I have a select query that pulls
information from all 3 tables. The subreports record source is the exact
same thing but with a different select query. My problem lies in that for
each speaker they could have more than one session and work with any
combination of other speakers on the same or different sessions.

Allen Browne said:
The simplest solution would be to use a query that excludes the name
before
it gets to the subreport.

Tell us about the RecordSource of the report and subreport. If this is 2
tables (e.g. Table1 feeds the main report, and Table2 feeds the
subreport),
you might be able to create a query that uses both tables. Use an outer
join
so you get all records from Table1. In the Criteria under the name frield
from Table2:
Is Null OR <> [Table1].[Name1]

Then create a single report (no subreport). In the Sorting And Grouping
dialog (View menu) choose Name1, and in the lower pane of the dialog set
Yes
for Group Header. Move all the fields that were in your main report into
this group header, and all the fields that were in the subreport into the
Detail section.

dc said:
Hi, I am hoping this is not a dumb question and theres a simple answer
but
for the life of me I can't even come up with an idea on how to do this.

I have a report that I send an individual which includes a subreport
that
includes all people associated to an item. Both pull data fine however
what
I would like to do is to be able to print the report to an individual
without
their name included in the subreport. Is there a way to do this?
Below
is
an idea of what I am talking about, name1 in the subreport I do not
want
to
show in the subreport:

(send to) Name1
Mailing address

report guts
[subreport:name1]
[subreport:name2]
[subreport:name3]
[subreport:name4]

I would be so ever greatful to anyone who could answer this one as I
dont
want to have to delete this information manually on some 200 reports.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top