subreport not showing fully

[Guest]

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 &
'"> ')
</select><br>

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!

 

[Duane Hookom]

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

 

[Guest]

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]

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

 

[Guest]

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]

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?

 

[Mingqing Cheng [MSFT]]

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, (e-mail address removed) (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

 

[Guest]

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]

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