subreport not showing fully

I have a subreport, and it previews properly. When I put the subreport in
the main report, it shows the detail portion, but not the footer portion of
the subreport. However, I have another subreport one line above this
subreport, and it is showing both the detail and the footer properly. I
can FTP or IM the Access .MDB to you to see it, if you are willing to help.
I have a version in 2000 and 2003 (yes I've been having the same problem for
several years.) I do not use macros, but I do use a VB6 IIF statement to
print the detail portion of the report.

The footer consists of 2 lines:
=('input type="hidden" name="t2" value="d-Material' & lblSummary.Caption &
'" ')
/selectbr

As I said, it previews fine as a subreport, just won't fully work in the
main report, only the detail portion of the subreport prints reliably,
sometimes it will show the summary portion and sometimes it won't in the main
report (but always shows fine in the subreport preview). All the subreport
and main report are is a lot of string manipulation with some database
variables. The resulting output looks like an html page.

Any suggestions? I don't think it's related to the size of
lblSummary.Caption. The subreport is in the detail portion of the main
report and it seems to always happen to the first detail record of the main
report, but may not happen to the second or third, etc. detail record of the
main report.

I think this is an Access problem, not my problem, based on the symptoms.
If I move it to .NET and still use the Access database backend do you think
it will work any better using .NET expressions rather than Access reports?
And anyone know of an easy way to convert an Access report (version 2000 or
2003) into VB.NET or C#.NET?

Thanks for your help!

Is this an DAP file? If so, perhaps you should ask your question of the
DataAccess.Pages NG.

--
Duane Hookom
MS Access MVP


"Pam Ammond" wrote in message
...
I have a subreport, and it previews properly. When I put the subreport in
the main report, it shows the detail portion, but not the footer portion
of
the subreport. However, I have another subreport one line above this
subreport, and it is showing both the detail and the footer properly. I
can FTP or IM the Access .MDB to you to see it, if you are willing to
help.
I have a version in 2000 and 2003 (yes I've been having the same problem
for
several years.) I do not use macros, but I do use a VB6 IIF statement to
print the detail portion of the report.

The footer consists of 2 lines:
=('input type="hidden" name="t2" value="d-Material' & lblSummary.Caption
&
'" ')
/selectbr

As I said, it previews fine as a subreport, just won't fully work in the
main report, only the detail portion of the subreport prints reliably,
sometimes it will show the summary portion and sometimes it won't in the
main
report (but always shows fine in the subreport preview). All the
subreport
and main report are is a lot of string manipulation with some database
variables. The resulting output looks like an html page.

Any suggestions? I don't think it's related to the size of
lblSummary.Caption. The subreport is in the detail portion of the main
report and it seems to always happen to the first detail record of the
main
report, but may not happen to the second or third, etc. detail record of
the
main report.

I think this is an Access problem, not my problem, based on the symptoms.
If I move it to .NET and still use the Access database backend do you
think
it will work any better using .NET expressions rather than Access reports?
And anyone know of an easy way to convert an Access report (version 2000
or
2003) into VB.NET or C#.NET?

Thanks for your help!

I don't know what a DAP file is, so it probably isn't. As I stated, the
problem is with a subreport not showing properly in a report. So, I believe
access.reports IS the correct place to ask about this.

Pam

"Duane Hookom" wrote:

Is this an DAP file? If so, perhaps you should ask your question of the
DataAccess.Pages NG.

--
Duane Hookom
MS Access MVP


"Pam Ammond" wrote in message
...
I have a subreport, and it previews properly. When I put the subreport in
the main report, it shows the detail portion, but not the footer portion
of
the subreport. However, I have another subreport one line above this
subreport, and it is showing both the detail and the footer properly. I
can FTP or IM the Access .MDB to you to see it, if you are willing to
help.
I have a version in 2000 and 2003 (yes I've been having the same problem
for
several years.) I do not use macros, but I do use a VB6 IIF statement to
print the detail portion of the report.

The footer consists of 2 lines:
=('input type="hidden" name="t2" value="d-Material' & lblSummary.Caption
&
'" ')
/selectbr

As I said, it previews fine as a subreport, just won't fully work in the
main report, only the detail portion of the subreport prints reliably,
sometimes it will show the summary portion and sometimes it won't in the
main
report (but always shows fine in the subreport preview). All the
subreport
and main report are is a lot of string manipulation with some database
variables. The resulting output looks like an html page.

Any suggestions? I don't think it's related to the size of
lblSummary.Caption. The subreport is in the detail portion of the main
report and it seems to always happen to the first detail record of the
main
report, but may not happen to the second or third, etc. detail record of
the
main report.

I think this is an Access problem, not my problem, based on the symptoms.
If I move it to .NET and still use the Access database backend do you
think
it will work any better using .NET expressions rather than Access reports?
And anyone know of an easy way to convert an Access report (version 2000
or
2003) into VB.NET or C#.NET?

Thanks for your help!

So, what's up with "=('input type="hidden" name="t2" value="d-Material' &
lblSummary.Caption &
'" ')
/selectbr"
This is clearly HTML. I think you have more explaining to do.

--
Duane Hookom
MS Access MVP


"Pam Ammond" wrote in message
...
I don't know what a DAP file is, so it probably isn't. As I stated, the
problem is with a subreport not showing properly in a report. So, I
believe
access.reports IS the correct place to ask about this.

Pam

"Duane Hookom" wrote:

Is this an DAP file? If so, perhaps you should ask your question of the
DataAccess.Pages NG.

--
Duane Hookom
MS Access MVP


"Pam Ammond" wrote in message
...
I have a subreport, and it previews properly. When I put the
subreport in
the main report, it shows the detail portion, but not the footer
portion
of
the subreport. However, I have another subreport one line above this
subreport, and it is showing both the detail and the footer properly.
I
can FTP or IM the Access .MDB to you to see it, if you are willing to
help.
I have a version in 2000 and 2003 (yes I've been having the same
problem
for
several years.) I do not use macros, but I do use a VB6 IIF statement
to
print the detail portion of the report.

The footer consists of 2 lines:
=('input type="hidden" name="t2" value="d-Material' &
lblSummary.Caption
&
'" ')
/selectbr

As I said, it previews fine as a subreport, just won't fully work in
the
main report, only the detail portion of the subreport prints reliably,
sometimes it will show the summary portion and sometimes it won't in
the
main
report (but always shows fine in the subreport preview). All the
subreport
and main report are is a lot of string manipulation with some database
variables. The resulting output looks like an html page.

Any suggestions? I don't think it's related to the size of
lblSummary.Caption. The subreport is in the detail portion of the
main
report and it seems to always happen to the first detail record of the
main
report, but may not happen to the second or third, etc. detail record
of
the
main report.

I think this is an Access problem, not my problem, based on the
symptoms.
If I move it to .NET and still use the Access database backend do you
think
it will work any better using .NET expressions rather than Access
reports?
And anyone know of an easy way to convert an Access report (version
2000
or
2003) into VB.NET or C#.NET?

Thanks for your help!

As I said in my initial post "All the subreport and main report are is a lot
of string manipulation with some database variables. The resulting output
looks like an html page."

Do you want to help me figure out why the subreport doesn't work in the main
report, which is what this forum IS about, or do you want to continue
delaying by asking me questions that are answered in my initial post???
Sorry, I really don't understand why you keep asking me questions like this.
Do you get brownie points for each "answer" you give someone? How about if I
send you the code so you can actually help me?


"Duane Hookom" wrote:

So, what's up with "=('input type="hidden" name="t2" value="d-Material' &
lblSummary.Caption &
'" ')
/selectbr"
This is clearly HTML. I think you have more explaining to do.

--
Duane Hookom
MS Access MVP


"Pam Ammond" wrote in message
...
I don't know what a DAP file is, so it probably isn't. As I stated, the
problem is with a subreport not showing properly in a report. So, I
believe
access.reports IS the correct place to ask about this.

Pam

"Duane Hookom" wrote:

Is this an DAP file? If so, perhaps you should ask your question of the
DataAccess.Pages NG.

--
Duane Hookom
MS Access MVP


"Pam Ammond" wrote in message
...
I have a subreport, and it previews properly. When I put the
subreport in
the main report, it shows the detail portion, but not the footer
portion
of
the subreport. However, I have another subreport one line above this
subreport, and it is showing both the detail and the footer properly.
I
can FTP or IM the Access .MDB to you to see it, if you are willing to
help.
I have a version in 2000 and 2003 (yes I've been having the same
problem
for
several years.) I do not use macros, but I do use a VB6 IIF statement
to
print the detail portion of the report.

The footer consists of 2 lines:
=('input type="hidden" name="t2" value="d-Material' &
lblSummary.Caption
&
'" ')
/selectbr

As I said, it previews fine as a subreport, just won't fully work in
the
main report, only the detail portion of the subreport prints reliably,
sometimes it will show the summary portion and sometimes it won't in
the
main
report (but always shows fine in the subreport preview). All the
subreport
and main report are is a lot of string manipulation with some database
variables. The resulting output looks like an html page.

Any suggestions? I don't think it's related to the size of
lblSummary.Caption. The subreport is in the detail portion of the
main
report and it seems to always happen to the first detail record of the
main
report, but may not happen to the second or third, etc. detail record
of
the
main report.

I think this is an Access problem, not my problem, based on the
symptoms.
If I move it to .NET and still use the Access database backend do you
think
it will work any better using .NET expressions rather than Access
reports?
And anyone know of an easy way to convert an Access report (version
2000
or
2003) into VB.NET or C#.NET?

Thanks for your help!

1) "The footer consists of 2 lines:" is this in a report, group, or page
footer?
2) what do you mean by "2 lines"? Do you mean two text boxes?
3) what are the exact control sources of the text boxes?
4) I hadn't seen the use of a label caption in a control source before so
this was new to me. Is there a reason why the caption isn't hard-coded in
the expression rather than referencing the caption property of a label
control?
4.5) where is lblSummary located?
5) you mention "VB6 IIf statement" and "send you the code". Does this
suggest you are using code in either the main or subreport? If so, could you
post the code?

--
Duane Hookom
MS Access MVP


"Pam Ammond" wrote in message
...
As I said in my initial post "All the subreport and main report are is a
lot
of string manipulation with some database variables. The resulting output
looks like an html page."

Do you want to help me figure out why the subreport doesn't work in the
main
report, which is what this forum IS about, or do you want to continue
delaying by asking me questions that are answered in my initial post???
Sorry, I really don't understand why you keep asking me questions like
this.
Do you get brownie points for each "answer" you give someone? How about
if I
send you the code so you can actually help me?


"Duane Hookom" wrote:

So, what's up with "=('input type="hidden" name="t2" value="d-Material'
&
lblSummary.Caption &
'" ')
/selectbr"
This is clearly HTML. I think you have more explaining to do.

--
Duane Hookom
MS Access MVP


"Pam Ammond" wrote in message
...
I don't know what a DAP file is, so it probably isn't. As I stated,
the
problem is with a subreport not showing properly in a report. So, I
believe
access.reports IS the correct place to ask about this.

Pam

"Duane Hookom" wrote:

Is this an DAP file? If so, perhaps you should ask your question of
the
DataAccess.Pages NG.

--
Duane Hookom
MS Access MVP


"Pam Ammond" wrote in message
...
I have a subreport, and it previews properly. When I put the
subreport in
the main report, it shows the detail portion, but not the footer
portion
of
the subreport. However, I have another subreport one line above
this
subreport, and it is showing both the detail and the footer
properly.
I
can FTP or IM the Access .MDB to you to see it, if you are willing
to
help.
I have a version in 2000 and 2003 (yes I've been having the same
problem
for
several years.) I do not use macros, but I do use a VB6 IIF
statement
to
print the detail portion of the report.

The footer consists of 2 lines:
=('input type="hidden" name="t2" value="d-Material' &
lblSummary.Caption
&
'" ')
/selectbr

As I said, it previews fine as a subreport, just won't fully work
in
the
main report, only the detail portion of the subreport prints
reliably,
sometimes it will show the summary portion and sometimes it won't
in
the
main
report (but always shows fine in the subreport preview). All the
subreport
and main report are is a lot of string manipulation with some
database
variables. The resulting output looks like an html page.

Any suggestions? I don't think it's related to the size of
lblSummary.Caption. The subreport is in the detail portion of the
main
report and it seems to always happen to the first detail record of
the
main
report, but may not happen to the second or third, etc. detail
record
of
the
main report.

I think this is an Access problem, not my problem, based on the
symptoms.
If I move it to .NET and still use the Access database backend do
you
think
it will work any better using .NET expressions rather than Access
reports?
And anyone know of an easy way to convert an Access report
(version
2000
or
2003) into VB.NET or C#.NET?

Thanks for your help!

Hi,

Thanks for using MSDN Managed Newsgroup!

It is highly appreciated if you could provide me that sample mdb file. You
could email it directly to me, (Please Remove
"online" if you mail is not a SPAM ^_^) if the file size is no more than
10M.

I will try to find whether it is an known issue for us and any better
workaround could be available. Moreover, I will try to pick up a specialist
in .net co-working with me if necessary.

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!


Sincerely yours,

Mingqing Cheng
Microsoft Developer Community Support
---------------------------------------------------------------
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Mingqing Cheng,

Thank you SO much for taking the time to look at my code :-) I am emailing
the Access mdb now (3.9 mb). Since you are MSFT you probably already know
this, but Outlook won't let you see the .mdb by default, unless you allow it
in your settings since an .mdb is "unsafe". If you have any problems I would
be happy to IM or FTP it to you. If you have any problems receiving the file
you can email me at (remove the "online."
portion).

The subreport is called subrptPartMaterial and the full report is called
WebPageForClothingType. When it asks for a clothing type enter "robe". At
the top of page 2 of the full report you will see "7." which contains the
subrptPartMaterial. You will see option value.... statements which is
the detail of the subreport. Then you will see a blank space which is where
the footer should be.

Notice that if you go to the bottom of the first page on the main report
that the subreport called subrptPartSize DID put the footer information
properly. This is what is so puzzling to me.

Again, THANKS for your time!!!
Pam

""Mingqing Cheng [MSFT]"" wrote:

Hi,

Thanks for using MSDN Managed Newsgroup!

It is highly appreciated if you could provide me that sample mdb file. You
could email it directly to me, (Please Remove
"online" if you mail is not a SPAM ^_^) if the file size is no more than
10M.

I will try to find whether it is an known issue for us and any better
workaround could be available. Moreover, I will try to pick up a specialist
in .net co-working with me if necessary.

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!


Sincerely yours,

Mingqing Cheng
Microsoft Developer Community Support
---------------------------------------------------------------
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Thank you Duane. I don't see a way to attach a file and there is no easy way
to list an Access report. The "code" I am referring to is actually the
ControlSource for TextBoxes that I use throughout the report. Each TextBox
is one line of the final report. I think you really need to have the full
..mdb to solve my problem.
1. The footer relates to a header; and the header, footer and detail all
print for each "PartNo".
2. The two line footer were the only two lines I immediately posted. I
can't really post the report since it is long and the code isn't separate but
embedded in each textbox. The subreport by itself works, so it is useless to
post it. If you would like me to IM or FTP the .mdb to you, I would be happy
to (outlook won't accept an .mdb by default and it is 3.5 meg).
3.
4. The label seemed to be the only way I could get the report to work. The
detail section of the report keeps appending to the end of a hidden label and
then the label is used in the summary section.
4.5 lblSummary is located in the Detail section.
5. There actually isn't any outside code, it's just that when I go to Help
in Access it is going to VB6 help for some reason. Anyway, all the code is
contained within each textbox, no macros or additional code.

Thanks,
Pam

"Duane Hookom" wrote:


1) "The footer consists of 2 lines:" is this in a report, group, or page
footer?
2) what do you mean by "2 lines"? Do you mean two text boxes?
3) what are the exact control sources of the text boxes?
4) I hadn't seen the use of a label caption in a control source before so
this was new to me. Is there a reason why the caption isn't hard-coded in
the expression rather than referencing the caption property of a label
control?
4.5) where is lblSummary located?
5) you mention "VB6 IIf statement" and "send you the code". Does this
suggest you are using code in either the main or subreport? If so, could you
post the code?

--
Duane Hookom
MS Access MVP


"Pam Ammond" wrote in message
...
As I said in my initial post "All the subreport and main report are is a
lot
of string manipulation with some database variables. The resulting output
looks like an html page."

Do you want to help me figure out why the subreport doesn't work in the
main
report, which is what this forum IS about, or do you want to continue
delaying by asking me questions that are answered in my initial post???
Sorry, I really don't understand why you keep asking me questions like
this.
Do you get brownie points for each "answer" you give someone? How about
if I
send you the code so you can actually help me?


"Duane Hookom" wrote:

So, what's up with "=('input type="hidden" name="t2" value="d-Material'
&
lblSummary.Caption &
'" ')
/selectbr"
This is clearly HTML. I think you have more explaining to do.

--
Duane Hookom
MS Access MVP


"Pam Ammond" wrote in message
...
I don't know what a DAP file is, so it probably isn't. As I stated,
the
problem is with a subreport not showing properly in a report. So, I
believe
access.reports IS the correct place to ask about this.

Pam

"Duane Hookom" wrote:

Is this an DAP file? If so, perhaps you should ask your question of
the
DataAccess.Pages NG.

--
Duane Hookom
MS Access MVP


"Pam Ammond" wrote in message
...
I have a subreport, and it previews properly. When I put the
subreport in
the main report, it shows the detail portion, but not the footer
portion
of
the subreport. However, I have another subreport one line above
this
subreport, and it is showing both the detail and the footer
properly.
I
can FTP or IM the Access .MDB to you to see it, if you are willing
to
help.
I have a version in 2000 and 2003 (yes I've been having the same
problem
for
several years.) I do not use macros, but I do use a VB6 IIF
statement
to
print the detail portion of the report.

The footer consists of 2 lines:
=('input type="hidden" name="t2" value="d-Material' &
lblSummary.Caption
&
'" ')
/selectbr

As I said, it previews fine as a subreport, just won't fully work
in
the
main report, only the detail portion of the subreport prints
reliably,
sometimes it will show the summary portion and sometimes it won't
in
the
main
report (but always shows fine in the subreport preview). All the
subreport
and main report are is a lot of string manipulation with some
database
variables. The resulting output looks like an html page.

Any suggestions? I don't think it's related to the size of
lblSummary.Caption. The subreport is in the detail portion of the
main
report and it seems to always happen to the first detail record of
the
main
report, but may not happen to the second or third, etc. detail
record
of
the
main report.

I think this is an Access problem, not my problem, based on the
symptoms.
If I move it to .NET and still use the Access database backend do
you
think
it will work any better using .NET expressions rather than Access
reports?
And anyone know of an easy way to convert an Access report
(version
2000
or
2003) into VB.NET or C#.NET?

Thanks for your help!

I see you have a MS employee willing to review your application. I hope this
works out for you.

--
Duane Hookom
MS Access MVP


"Pam Ammond" wrote in message
...
Thank you Duane. I don't see a way to attach a file and there is no easy
way
to list an Access report. The "code" I am referring to is actually the
ControlSource for TextBoxes that I use throughout the report. Each
TextBox
is one line of the final report. I think you really need to have the
full
.mdb to solve my problem.
1. The footer relates to a header; and the header, footer and detail all
print for each "PartNo".
2. The two line footer were the only two lines I immediately posted. I
can't really post the report since it is long and the code isn't separate
but
embedded in each textbox. The subreport by itself works, so it is useless
to
post it. If you would like me to IM or FTP the .mdb to you, I would be
happy
to (outlook won't accept an .mdb by default and it is 3.5 meg).
3.
4. The label seemed to be the only way I could get the report to work.
The
detail section of the report keeps appending to the end of a hidden label
and
then the label is used in the summary section.
4.5 lblSummary is located in the Detail section.
5. There actually isn't any outside code, it's just that when I go to
Help
in Access it is going to VB6 help for some reason. Anyway, all the code
is
contained within each textbox, no macros or additional code.

Thanks,
Pam

"Duane Hookom" wrote:


1) "The footer consists of 2 lines:" is this in a report, group, or page
footer?
2) what do you mean by "2 lines"? Do you mean two text boxes?
3) what are the exact control sources of the text boxes?
4) I hadn't seen the use of a label caption in a control source before
so
this was new to me. Is there a reason why the caption isn't hard-coded
in
the expression rather than referencing the caption property of a label
control?
4.5) where is lblSummary located?
5) you mention "VB6 IIf statement" and "send you the code". Does this
suggest you are using code in either the main or subreport? If so, could
you
post the code?

--
Duane Hookom
MS Access MVP


"Pam Ammond" wrote in message
...
As I said in my initial post "All the subreport and main report are is
a
lot
of string manipulation with some database variables. The resulting
output
looks like an html page."

Do you want to help me figure out why the subreport doesn't work in
the
main
report, which is what this forum IS about, or do you want to continue
delaying by asking me questions that are answered in my initial
post???
Sorry, I really don't understand why you keep asking me questions like
this.
Do you get brownie points for each "answer" you give someone? How
about
if I
send you the code so you can actually help me?


"Duane Hookom" wrote:

So, what's up with "=('input type="hidden" name="t2"
value="d-Material'
&
lblSummary.Caption &
'" ')
/selectbr"
This is clearly HTML. I think you have more explaining to do.

--
Duane Hookom
MS Access MVP


"Pam Ammond" wrote in message
...
I don't know what a DAP file is, so it probably isn't. As I
stated,
the
problem is with a subreport not showing properly in a report. So,
I
believe
access.reports IS the correct place to ask about this.

Pam

"Duane Hookom" wrote:

Is this an DAP file? If so, perhaps you should ask your question
of
the
DataAccess.Pages NG.

--
Duane Hookom
MS Access MVP


"Pam Ammond" wrote in message
...
I have a subreport, and it previews properly. When I put the
subreport in
the main report, it shows the detail portion, but not the
footer
portion
of
the subreport. However, I have another subreport one line
above
this
subreport, and it is showing both the detail and the footer
properly.
I
can FTP or IM the Access .MDB to you to see it, if you are
willing
to
help.
I have a version in 2000 and 2003 (yes I've been having the
same
problem
for
several years.) I do not use macros, but I do use a VB6 IIF
statement
to
print the detail portion of the report.

The footer consists of 2 lines:
=('input type="hidden" name="t2" value="d-Material' &
lblSummary.Caption
&
'" ')
/selectbr

As I said, it previews fine as a subreport, just won't fully
work
in
the
main report, only the detail portion of the subreport prints
reliably,
sometimes it will show the summary portion and sometimes it
won't
in
the
main
report (but always shows fine in the subreport preview). All
the
subreport
and main report are is a lot of string manipulation with some
database
variables. The resulting output looks like an html page.

Any suggestions? I don't think it's related to the size of
lblSummary.Caption. The subreport is in the detail portion of
the
main
report and it seems to always happen to the first detail
record of
the
main
report, but may not happen to the second or third, etc. detail
record
of
the
main report.

I think this is an Access problem, not my problem, based on
the
symptoms.
If I move it to .NET and still use the Access database backend
do
you
think
it will work any better using .NET expressions rather than
Access
reports?
And anyone know of an easy way to convert an Access report
(version
2000
or
2003) into VB.NET or C#.NET?

Thanks for your help!