473,326 Members | 2,134 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Subreport not showing - but my frustration is

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. Arrrgggghhhhhhhhhhhhhhhhhhhhhh.....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;LineNo'. 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

Feb 20 '06 #1
2 3231
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" <je************@asken.com.au> wrote in message
news:43***********************@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. Arrrgggghhhhhhhhhhhhhhhhhhhhhh.....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;LineNo'. 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

Feb 20 '06 #2
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" <Al*********@SeeSig.Invalid> wrote in message
news:43***********************@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" <je************@asken.com.au> wrote in message
news:43***********************@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. Arrrgggghhhhhhhhhhhhhhhhhhhhhh.....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;LineNo'. 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


Feb 20 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Wayne | last post by:
rr@kristin.school.nz (Wayne) wrote in message news:<7ec36840.0403301824.16f2cd9f@posting.google.com>... > I have a subreport in my report and when it contains exactly one row, > it works fine. In...
7
by: Ellen Manning | last post by:
I've got an A2K report showing students and their costs. Student info is in the main report and costs are in a subreport for each student. The user inputs the program desired then only those...
10
by: sara | last post by:
I am STUCK! I have an Access2000 report; main report and subreport. The sub report is 2 columns, with a footer controlled by a value in a field. The Report Footer should have SUM of values in...
2
by: GB | last post by:
Hello: I created a report as a perent report with subreport in the middle of detail section of the perent report. The subreport has a query as the recordsource, which can return different number...
2
by: Jana | last post by:
Using Access 97. Background: I have a main report called rptTrustHeader with a subreport rptTrustDetails in the Details section of the main report. The main report is grouped by MasterClientID. ...
3
by: Matt | last post by:
Hi All, I currently have 2 reports. One report shows Transaction History (I will refer to as "TH") and the other shows Account Summary (I will refer to as "AS"). I want to combine the reports...
2
by: Ron | last post by:
I have a report let's call rptOne. On rptOne I have a subreport called srptOne. On srptOne I have a subreport called srptTwo. Sometimes, srptTwo is there and shows it's data and sometimes not,...
3
by: Simon | last post by:
Dear reader, The syntax for the VBA code to change the RecordSource of a Master Report is: Me.RecordSource = "TableOrQueryName"
1
by: eogyamfi | last post by:
i have subreport within the main report. The grand total for the main report is showing on the report. The grandtotal for the subreport is not showing even though on the subreport itself it shows...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.