subReport Problem

[SAL]

Opps, I also posted this in the Access group by mistake:

I'm going to try to explain this the best I can...
I have a report that has a sub-report embedded in it which has a sub-report
embedded in it.
With the main report, I filter the report with user input. The report looks
fine and the sub-reports look good too except for one thing:
the first sub-report is not including all of the related records--but the
query does.
So, in my main report it has a field called InspectionId and so does the
sub-report. This is the Master/Child link fields.
The query returns the following when I use:
Where InspectionId=340

qryInspectionObjects2 InspectionID FacilityObjectID SiteObjectID
Compliance FacilityObject
340 5 1301 Yes Catch Basin
340 5 1302 Yes Catch Basin
340 5 1303 Yes Catch Basin
340 5 1305 Yes Catch Basin
340 5 1308 No Catch Basin
340 15 1304 Yes CONTECH StormFilter (leaf compost or ZPG filters)
340 20 1300 Yes Access Road or Easement
340 21 1306 Yes Drywell


But the report is dropping off four of the Catch Basin items. As far as I
know, I'm not filtering this sub-report except by using the Master/Child
Link field stated above.
Can anyone give me any clues as to why the report is dropping off those
records while the query is not?

Any help is way appreciated. I've beat my head against the wall on this...

SAL

 

[Duane Hookom]

Is the subreport set to allow growing as well as the section containing the
subreport?

 

[Charles Wang [MSFT]]

Hi SAL,
I think that there might be some difference here between your subreport and
query. I performed a test by creating a main report and subreport with
master/child link at my side (in Access 2007), however I could not
reproduce your issue. Setting "Can Grow" either yes or no worked fine.
Since this issue is hard to be reproduced, I recommend that you first check
if you can reproduce this issue in a test database. If so, could you please
mail me (changliw_at_microsoft_dot_com) the test database so that I can
reproduce your issue and perform effective research?

Please feel free to let me know if you have any other questions or
concerns. It is my pleasure to be of assistance.

Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: (e-mail address removed).
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

 

[SAL]

Duane & Charles. I'm sorry for not responding to these posts earlier. As I
mentioned in this post, I also posted to the Access group and Crystal solved
my problem for me. She took a look at my database and told me how to fix the
problem.
The problem I was having was that I had two headers and I needed to move the
second headers info down into the detail section. After I did this, the
problem resolved.

Thank you so much for your follow up.

S

 

[Charles Wang [MSFT]]

Hi SAL,
Thank you for posting back and let us know that you had got the resolution
from another community. I would like to say sorry to you since we did not
help here. If you have any other questions or concerns, please feel free to
let us know.

Have a nice day!

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: (e-mail address removed).
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================