MS Access database support - Subreport not showing

Author

Subreport not showing - but my frustration is

Jeff

2006-02-20, 3:24 am

Damn this is frustrating. I have used subreports for years and never had
this problem. I have used these things more times than I can remember. Never
have I had this problem. Arrrgggghhhhhhhhhhhh
hhhhhhhhhh.....etc and ahhh

This should be simple, but... This is a report for a sales order. Parent
report actually shows the header and detail, detail is not in the subreport.
In the subreport is a breakup of committed product by UseBy date.

Master and Child link fields are both 'OrderInvoiceNo;Line
No'. There are
records to show for the order the report is generated on.

The fields do exist in both the parent and sub reports.

If I remove the link fields the report shows heaps of records, as expected,
including the ones that should show for each detail. Add just the
OrderInvoiceNo and nothing shows. Add anything in the link fields and
nothing shows.

Why? Is it because it is Monday? Or maybe because I was having a good day?
Or am I just missing something so obvious here that it isn't?

And yes, I have restarted Access, which usually fixes illogical problems.
And gone and had some comfort food - snakes. Haven't got to the chocolate
yet. Cholesterol is too high for pizza. Chocolate doesn't count.

Jeff Pritchard
________________
Asken Research Pty. Ltd.
Access Database Developers (still)
www.asken.com.au

Allen Browne

2006-02-20, 7:24 am

Hi Jeff

No doubt there will be an obvious reason once the dust settles. :-)

In the mean time, is there any chance Access could misunderstand the data
type of any of these fields? Particularly:
- calculated fields may need to be typecast;
- query parameters may need to be declared (esp if applied to calculated
fields, or if reading a value from a control on a form);
- text boxes may need their Format property set if unbound, bound to an
expression, assigned programmatically, or bound to a calculated field.

Do the *controls* have the same name as the fields? If not, are you using
the control names in LinkMasterFields/LinkChildFields?

How are you limiting the date range for the subreport?

The subreport CanGrow?

You've probably tried a compact'n'repair (just in case there's a bad index.)

No doubt you already have the Name AutoCorrupt boxes unchecked (Tools |
Options | General.)

If none of that goes anywhere, what happens if you create a query based on
the main report's query joined to the subreport's query on OrderInvoiceNo
and LineNo?

BTW, there's a rumour that dark chocolate is supposed to be good for us?
:-)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jeff" <jeff.pritchard@asken.com.au> wrote in message
news:43f9606e$0$3075
9$5a62ac22@per-qv1-newsreader-01.iinet.net.au...
> Damn this is frustrating. I have used subreports for years and never had
> this problem. I have used these things more times than I can remember.
> Never have I had this problem. Arrrgggghhhhhhhhhhhh
hhhhhhhhhh.....etc and
> ahhh
>
> This should be simple, but... This is a report for a sales order. Parent
> report actually shows the header and detail, detail is not in the
> subreport. In the subreport is a breakup of committed product by UseBy
> date.
>
> Master and Child link fields are both 'OrderInvoiceNo;Line
No'. There are
> records to show for the order the report is generated on.
>
> The fields do exist in both the parent and sub reports.
>
> If I remove the link fields the report shows heaps of records, as
> expected, including the ones that should show for each detail. Add just
> the OrderInvoiceNo and nothing shows. Add anything in the link fields and
> nothing shows.
>
> Why? Is it because it is Monday? Or maybe because I was having a good day?
> Or am I just missing something so obvious here that it isn't?
>
> And yes, I have restarted Access, which usually fixes illogical problems.
> And gone and had some comfort food - snakes. Haven't got to the chocolate
> yet. Cholesterol is too high for pizza. Chocolate doesn't count.
>
> Jeff Pritchard
> ________________
> Asken Research Pty. Ltd.
> Access Database Developers (still)
> www.asken.com.au

Jeff

2006-02-20, 8:25 pm

Hi Allen

Oh what a difference a day makes.

I thought I had done all of those yesterday, but guess what - there was a
control named OrderInvoiceNo and that was the problem. Now I am sure I
checked that all controls had a prefix, 'txt' in this case. I think someone
is playing games with me. I'm not paranoid, really I'm not.

Time for some chocolate. We have to celebrate these little successes - don't
we.

Jeff Pritchard
________________
Asken Research Pty. Ltd.
Access Database Developers
http://www.asken.com.au

"Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message
news:43f9ab1f$0$3072
4$5a62ac22@per-qv1-newsreader-01.iinet.net.au...
> Hi Jeff
>
> No doubt there will be an obvious reason once the dust settles. :-)
>
> In the mean time, is there any chance Access could misunderstand the data
> type of any of these fields? Particularly:
> - calculated fields may need to be typecast;
> - query parameters may need to be declared (esp if applied to calculated
> fields, or if reading a value from a control on a form);
> - text boxes may need their Format property set if unbound, bound to an
> expression, assigned programmatically, or bound to a calculated field.
>
> Do the *controls* have the same name as the fields? If not, are you using
> the control names in LinkMasterFields/LinkChildFields?
>
> How are you limiting the date range for the subreport?
>
> The subreport CanGrow?
>
> You've probably tried a compact'n'repair (just in case there's a bad
> index.)
>
> No doubt you already have the Name AutoCorrupt boxes unchecked (Tools |
> Options | General.)
>
> If none of that goes anywhere, what happens if you create a query based on
> the main report's query joined to the subreport's query on OrderInvoiceNo
> and LineNo?
>
> BTW, there's a rumour that dark chocolate is supposed to be good for us?
> :-)
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Jeff" <jeff.pritchard@asken.com.au> wrote in message
> news:43f9606e$0$3075
9$5a62ac22@per-qv1-newsreader-01.iinet.net.au...
>
>

Sponsored Links