Report - Section OnRecord Event

[enstorms]

Re: Report - Section OnRecord Event

Mike and Tom,
Thanks for your help with this. As to my original question, the answer seems to be "No".

G.,
Thanks for your input. As to my original question, as stated above, it can't be done. But there are workarounds, as you've shown. Thought I had tried the footer option, but maybe I didn't. My intent was to get the ending values from the last record in the parent table to print in the header or footer. Thought using a variable to do this might work. But looks like there is no way to do that. By placing the ending value fields in the footer, it comes up with the correct number, but may not be from the last record in the parent table. So I can just label it as Ending values.
Ernie

[G Gabriel]

Re: Report - Section OnRecord Event

Ernie:

as stated above, it can't be done.

Yes there is a way to use the OnRecord events (not in this scenario) and yes there is a way to use a variable (not in this scenario either). This thread seems to mix Jazz with Rap with Beethoven.. I steered clear from discussing this issue until first you are clear on what the answer to your question is. Will get to that later if you are interested.

Since I wasn't quite sure what you were trying to do, I attached an image of the results to see if they reflect the right numbers.

Reading your last post, I now understand fully what you are trying to do. Interestingly enough, right after I started reading your original question, I knew right off what the answer should be before even finishing the question. Sometimes, I have the bad habit of responding without reading the whole thing. I was about to do so, but then when I read the whole thing I became unsure about your intentions.

The correct answer is you need a calc value not a variable nor an OnRecord event.

Your set has a filter that only shows records from the parent that have child records. Now you want to get a value for a child from a parent that may or may not be included in the report. This seems to be the part that got you off track.

I can't quite remember now if the value I placed in the footer was from the parent or the child. I just used whatever lookup() you used to obtain the same value. I think you need to make a correction here:
If you want to place the last value of the parent, you need to use a different function: you need lookupc() or lookupn() ... But, let's be clear what last means: last means the one that was added to the table last, i.e. the one with the highest recno. If however you are looking for the one with the highest value, then you need a completely different function: dbmax().

You could place this calc value in the details section or the footer, it does not matter. Only difference is, in the details section, it will repeat with every record.

[enstorms]

Re: Report - Section OnRecord Event

G.,
Really appreciate your help. I did try to use the calc field before, but was using the lookup() function instead of lookupn(). So that makes the difference. Guess I didn't want to have to use an index for the lookup since it is made up of 3 fields. Still learning how to concatenate fields together, although numeric fields are pretty simple.
Thanks again.
Ernie