Copying sub reports - third time around

  • Thread starter Thread starter phm
  • Start date Start date
P

phm

How else do you express frustration of having had two, count the messages,
two people respond with none answers; why respond if not to answer the
question? Or are credits given for number of responses, rather than
resolutions.

so, how do i copy a subreport and change the datasource, all small letters.
 
Most of the time, the OP would post back in the thread where some of us had
tried to help. They provide some information about what they tried and why it
worked or didn't work. It also is nice if you say "thanks for trying to help".

What you don't generally do is start a new thread complaining about an old
thread. Those of us who answer questions, typically are more interested
helping than earning any type of credits.
 
PHM,

I'm feeling a little small here... I answered your question! However, note
your questions was... "Can I...." not "How do I...." Kind of rude to
insult the volunteers and indicate you did not get an answer when in fact
you did... Kind of rude to start a new thread instead of just posting you
clarified question to the same post. You simply misphrased your question
but you did get an answer. To answer you second question...

1. In the Object WIndow highlight the report/subreport you want to copy.
2. On you keyboard press Ctrl+C then...
3. Crtl+V and in the window that opens up type the new name for your
report/subreport
4. Go to Design View of the report and in the Properties Window select a new
RecordSource...
5. Change the fields on the report to correspond to your new RecordSource

As a side note, since we are UNpaid volunteers. We answer because we want
to help. So perhaps you could take a breath and think that perhaps your
question was not as clear as you thought it was. (Thank you for not yelling
at us in this post! <smile>)

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
I really think creating multiple reports is not the solution. If the only
difference is the set of records then a single subreport pasted into the
main report would be the best option. You can use the Link Master/Child
properties to filter the set of records displayed in each subreport.

You wouldn't create a separate Order Details subform for each unique order.
For the same reason, you would not create a new subreport for each different
region. What happens when you get another region?

I did make this suggestion in a previous thread but my suggestion got no
response.

Duane Hookom
MS Access MVP
 
Duane,

What the Poster is doing makes no sense to me either but with *tone* with
which the first (all caps) and second (insulting) were asked I did not get
the impression there was any room for discussion. So, I simply answered the
question.

Perhaps seeing your additional response will invite a *conversation* that
will lead to a better solution.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
You can have one copy of the subreport in a section of the main report that
contains a unique region value. Each region would render its own copy of the
subreport filter to that region.

You could also have 7 copies of the same subreport in the detail section of
a main report. I create calendar reports like this with the same "DAY"
subreport copied 7 times across a detail section to produce one week of days.

I have an aversion to creating multiple similar objects whether its
repeating fields in a table or multiple identical queries with the only
difference being the subset of records or several reports that are the same
only based on different queries or similar tables but for different years or
.....

I can't imagine why the different regions would have different subreports.
If the regions each have their own table (which wouldn't surprise me) then
you could union them together and use my suggestion.

I don't know if we will ever find out. If I'm wrong, I will buy someone a
drink next month ;-)
 
My calendar report available at http://www.access.hookom.net/Samples.htm has
a record source on the main report that includes a WeekOf field with values
like:
1/3/2010
1/10/2010
1/17/2010
I then create text boxes across the detail section with control sources like:
=[WeekOf]+0
=[WeekOf]+1
=[WeekOf]+2
I can then use these 7 (or 5 if only workweek) text boxes as the Link Master
for the individual copies of the same subreport.
 
Clifford,

Or combo boxes... No the wizard does not bo you can just type them in or
set them in code.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
Clifford Bass via AccessMonster.com said:
Hi Duane,

Ah, the light dawns. I did not realize you could link on non-record
source items such as text boxes. That because the linking wizard does not
offer that option and complains if you try to do so. Very interesting!!!

Learn something new! Thanks again!

Clifford Bass

Duane said:
My calendar report available at http://www.access.hookom.net/Samples.htm
has
a record source on the main report that includes a WeekOf field with
values
like:
1/3/2010
1/10/2010
1/17/2010
I then create text boxes across the detail section with control sources
like:
=[WeekOf]+0
=[WeekOf]+1
=[WeekOf]+2
I can then use these 7 (or 5 if only workweek) text boxes as the Link
Master
for the individual copies of the same subreport.
Click to expand...
Click to expand...
 
At least we're having a good time and learning new things in this thread ;-)

I don't like setting the Link Master/Child properties in code (forms or
reports). It seems to me I have had issues with this but it was a number of
years (and versions) ago.

I expect you could create a 5 or 7 column subreport for a calendar but you
would have to make sure every date was rendered.
 
First, I believe I have only tried this with forms and subforms. I recall
having serious corruption issues when attempting to change these properties.
Like I said it was quite a few years ago.

Now, I don't even recall why I thought I needed to change the properties.
 
Back
Top