Well, let me apologize as well. It seems Stephen, as I am sure Marshall,
would agree think you are a nice guy and maybe I took your responses the
wrong way. Stephen is right, just because I feel someone else has been rude
or disrespectful to me, does not neccessarily give me the right to do the
same thing. That would be the pot calling the kettle black. And since you
did not mean to offend me (it seems I just took it the wrong way), I want to
extend my apologies for my actions. I am new to using newsgroups, infact
just started the other day and am learning the "rules".
Stephen - maybe I should just ignore people, but for example, had I not
written that I felt offended, I would not have received Duane's acclaration
that he didn't intend for his words to come accross that way. I think it is
good and healthy for people to express what they feel/think and clear up
misunderstandings which is hopefully what we did. Maybe we don't know each
other and it doesn't make a difference, but I certainly learned something
from it all - Duane is a nice guy and he doesn't mind if I write him back
when I don't understand something.
Sorry again for any misunderstandings on my part.
I hope both of you have a good weekend!
Dee
Duane Hookom said:
In my first reply to you on this thread, I suggested:
"Is it possible for you to move some labels or whatever from your subreport
to your main report?"
How is this different than:
"putting controls on the main report"
My statement above was a question to which I didn't get a reply. In
addition, I had suggested a method that would allow you to display some
value on the main report if there was no data on a subreport.
If you think my responses/questions are being "nasty", then I am
sorry if
I
have offended you. Sometimes I get frustrated when I ask a simple question
or make a suggestion and it seems like it gets ignored. If you don't
understand then refer back to my posting and tell me what part of it you
don't understand.
--
Duane Hookom
Microsoft Access MVP
showed me
how
as
was
just
more detailed and easier to understand. You don't have to treat
people
like
they're complete idiots you know. I may not know as much as you,
but I
got
the average guy beat by 1,000 miles. I hope you can take the
initiative
to
try and treat people with a little more kindness and respect because you
haven't been kind or respectful to me.
Dee
I find it hard to believe you are getting 0's in the bound
fields if
there
are no records in the reports. Get used to the fact that you
will not
have
a
subreport display on a main report if there are no records in the
subreport.
If you need to display something, you have to display it on the main
report.
--
Duane Hookom
MS Access MVP
Hi Duane!
Here's the rundown. The main report is not linked to any
table or query. There are 6 subreports. They are not all
related, so I can't really put any of the information in
the main report. The main report is a compilation
(executive summary totals) of the subreports. The only
thing they have in common is the Rep ID = CHID. They all
have that field. There are about 30 Reps. Some will have
data in all of the subreports, some will have some data in
some of the subreports and in others none, and some will
have no data in any of the subreports. The important
thing here is show the REP, through this report is that if
they have no data recieved, it shows 0 in all of the
columns.
Currently, if I open the subreports individually (not the
main report), they will show a Zero value in the columns
where no data is found. However, when I open the main
report with the subreports in them that have no data, they
do not show up.
I was sure that there had to be a way programatically to
force the subreport to be visible. There is a way to
force it to not be visible programatically. If you can
force a query to show Null records and a control on a
subform to convert null records to Zero, then why not a
subform? There is nothing that can be written in a macro
or VBA to solve this problem or maybe in the NoData Event
of the subform?? All of my work will be useless if I
can't make it all show up.... I could create a snapshot
of it to show you what it looks like with all the
information filled out and you could imagine Zero's in
those columns and see how I need it look with or without
information. Each row is a subreport, but it appears to
be a common table.
Thanks,
Dee
-----Original Message-----
I assume you are referring to reports throughout your
email. You can't make
subreports appear if they have no records. Is it possible
for you to move
some labels or whatever from your subreport to your main
report? In your
main report, you can also use expressions like:
=IIf(subrptControl.Report.HasData, "","No data in
subreport")
--
Duane Hookom
MS Access MVP
Does anyone know how to force subreports to show up on
my
main report if they have no information? I have not
programmed the report to not show if nulls are present
and
they just do not show at all if there is no data???
When
I open the subreport by itself, it will show 0's if
there
is no data using the formula: =IIf
([Report].HasData,Count
(IIf([Date] Between #1/1/2003# And
#3/31/2003#,1,Null)),0). But when I open the main form,
it is blank and only shows the header. This only
happens
with subforms that contain no data...
Any ideas?
Thank you,
Dee
.
