[AccessD] SubForms/SubReport not displaying a report

Reuben Cummings reuben at gfconsultants.com
Thu Jan 13 14:47:44 CST 2005


I'd have to take a look, Dale.

Seems to me that the only other simple answer is that the data in the parent
and child fields does not match and therefore there is no data to put into a
subreport.  We came across that yesterday - drove us nuts until we finally
found a very slight variation in the data.

Beyond that I'm stumped.

Reuben Cummings
GFC, LLC
phone: 812.523.1017
email: reuben at gfconsultants.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Dale Kalsow
Sent: Thursday, January 13, 2005 3:25 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] SubForms/SubReport not displaying a report


I think it is a 2003 thing.  It has worked fine since I wrote it in office
97.

Andy Lacey <andy at minstersystems.co.uk> wrote:Scratching my head on this one.
I'd suggest you send me a copy off-line only
I don't have A2003. Ok, here's a shot in the dark. The query which drives
the subreport doesn't have a 'Top n' in it does it, or any kind of Distinct
which is causing it to suppress extra records? In fact, if you Preview the
subreport on its own does it show lots of records as you'd expect?

-- Andy Lacey
http://www.minstersystems.co.uk

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dale Kalsow
> Sent: 13 January 2005 19:23
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] SubForms/SubReport not displaying a report
>
>
> No it is in the detail section.
>
> Reuben Cummings wrote:The subform
> isn't in the report header is it? Or in a group header that
> is only showing on the first page?
>
> Reuben Cummings
> GFC, LLC
> phone: 812.523.1017
> email: reuben at gfconsultants.com
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Dale Kalsow
> Sent: Thursday, January 13, 2005 1:56 PM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] SubForms/SubReport not displaying a report
>
>
> The main form is a report and the item that is not displaying
> is a subform/subreport. Yes, I have master and child fields.
> My report is a shipping form. If my criteria produces more
> then one shipping form then the subform is only printed on
> the first shipping form. If I set my criteria to only be one
> of the pages that did not print before then it is fine.
>
> Dale
>
> Andy Lacey wrote:
> Hi Dale
> Questions. Do you mean subform not subreport? Is it in the
> Detail section? Is it linked via Master and Child fields?
>
> -- Andy Lacey
> http://www.minstersystems.co.uk
>
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Dale Kalsow
> > Sent: 13 January 2005 16:49
> > To: accessd at databaseadvisors.com
> > Subject: [AccessD] SubForms/SubReport not displaying a report
> >
> >
> >
> > Good Morning,I have Office 2003 with sp 1 installed. I have
> an access
> > report that has a subform on it. If my report has multiple
> pages the
> > subform will only show up on the first page of the
> report.Has anyone
> > seen this and is there a way to fix it?Thanks in advance!Dale
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam? Yahoo! Mail has the best spam protection around
> > http://mail.yahoo.com
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> >
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> ---------------------------------
> Do you Yahoo!?
> All your favorites on one personal page  Try My Yahoo!
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
> ---------------------------------
> Do you Yahoo!?
> All your favorites on one personal page - Try My Yahoo!
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



---------------------------------
Do you Yahoo!?
 All your favorites on one personal page  Try My Yahoo!
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com







More information about the AccessD mailing list