Subreport won't show on main report

[Dee]

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

 

[Duane Hookom]

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]

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

Duane,

I don't know why you have to be so nasty. You know, Marshall showed me how
to do it by putting controls on the main report and refering back to the
subreport and getting nulls to come up zero. Had you been as nice as him,
I'm sure you could have given that instruction too. That, or he 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


.

 

[Stephen Lebans]

Jeesuz Dee, get a thicker skin. Duane will probably apologize to you
simply because he really is a nice guy. I on the other hand am not and
do not suffer fools gladly.
Your comments are both foolish and unjustified. There is nothing in
Duane's posts that I would characterize as either "nasty" or
"disrespectful".
On the other hand Dee, your post is definately both nasty and
disrespectful. If you are not happy with a response to your posting I
would suggest you simply forget about it an move on.

Finally, you are not paying for the peer to peer support you receive in
this group. The overwhelming majority of responders in this NG do not
work for Microsoft. I would suggest you take a moment to read our FAQ
here:
http://www.mvps.org/access/netiquette.htm

--
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

Duane,

I don't know why you have to be so nasty. You know, Marshall showed me how
to do it by putting controls on the main report and refering back to the
subreport and getting nulls to come up zero. Had you been as nice as him,
I'm sure you could have given that instruction too. That, or he 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


.

 

[Dee]

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

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

Duane,

I don't know why you have to be so nasty. You know, Marshall showed me how
to do it by putting controls on the main report and refering back to the
subreport and getting nulls to come up zero. Had you been as nice as him,
I'm sure you could have given that instruction too. That, or he 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


.

 

[Stephen Lebans]

Well Dee that was an excellent reply. See you are getting a thicker skin
already!<grin>



HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

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

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

him,

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


.

 

[Dee]

I'll check that out . Believe it or not, I've never used a Union query.
I have created a msg box on other reports to say "No Records Available for
This Report" through the No Data event in VBA. For now, I can get all the
information to show on the main report by refering to the subreports by
using IIf HasData (with the exeption of one). My hopefully last problem I
sent to you in the Make Nulls Show in Query a few minutes ago. It comes
from have queries in another query that when they have no data, the main
query doesn't come up with any information. But I sent you all the details
on that string .

Thanks,

Dee

Thanks Dee. You did get me thinking about adding a "false" record to a
report's record source using a UNION query. If this was the only record
resulting in the report, it would display (with 0s or text like "No
Records"). If there were other records in addition to the record added with
the UNION syntax, code in the On Format event would cancel its printing.
This would ensure that the report header and footer of a subreport would
always show.

If you think this might be an option for you and you have a question then
let us know.

--
Duane Hookom
MS Access MVP

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


if as
him,

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


.