missing field in preview mode...

[MParker]

ok, this one has me stumped. i have a layout that i do a weekly print on. basically, i have 3 fields in the footer of the layout that prints. there is:

1 - Dollar Amount

2 - Minus Amount On Hand

3 - Sum of the first two

so, in browse mode, everything is fine. it shows the amounts and equations correctly. but when i go to print it (no matter if i take it into preview mode to print or leave it in browse mode), it does not print #2, therefore the equation is wrong. i don't understand why it won't print. any ideas?

[Ugo DI LUCA]

Hi,

Welcome to the forums.

I can't think of any reason why the equation would be wrong, really. But is it really that the total is incorrect, or only that the #2 value doesn't show ?

If so, make sure you didn't select "do not print the selected objects" in the 'Set Sliding/Printing' Menu, accessible with 'Format>Set Sliding/Printing...' after the field was selected.

HTH

Edited May 2, 2008 by Guest

[MParker]

thank you for the welcome. sadly, no, that option is unchecked. here's what i mean though...

Browse Mode:

Preview Mode:

i just can't figure this one out. :

[comment]

It doesn't appear to be missing - it looks like it has no value. Instead of guessing, why don't you supply some details, like how is the field defined, in which layout part is it, which table does it come from, and so on. Or even better, post a file that shows the problem. Two blurry pictures do not tell much.

[MParker]

sorry, i was just trying to keep the size of them down. here's the details...

all fields are in a table called tkstatus.

fields involved:

• recommended (type: Number)
  
• total (type: Summary of "recommended" [Total of] - [All Together Summarize Rep]
  
• alreadyhere (type: Number)
  
• pullfrombank (type: Calculation [total - alreadyhere]
  

now, i have a layout that i input all the required information into, then click a button that is connected to a script that filters the date and prints all records for that day. the layout that it prints is a basic layout with a header (containing logo and report title), a body that is a list view of records (containing information for that day), and a footer that contains these three fields.

i'm sorry but i can not post a copy of it, it holds a good bit of my company's information. hopefully i have described it well enough that it might help. please let me know if there's any other information that you might need.

[comment]

I am guessing it's the last field, pullfrombank, that's "missing"?

[MParker]

no, it's the second...the "alreadyhere" that's missing in preview and on print.

[comment]

Ah, sorry - that's the one I actually meant. Alright, here's a suggestion: in Browse mode, go to the last record. My crystal ball says you will see the same thing as you do in Preview.

[MParker]

your crystal ball is 100% correct. it's only showing on the first record...the rest have nothing. how do i fix this?

[comment]

I don't know - because I don't know the meaning of your fields, and what do you actually want to calculate. The only thing that is clear is that the field is not global, and each record has its own alreadyhere value. Therefore, each record has its own pullfrombank value, too (place these fields in the body part to see this). What you see in the footer in Preview mode are the values from the last record in the found set.

[DanG.]

I think I figured it out. First let me thank you; by figuring that your last field was empty, it clued me in to what was wrong with my Header formula (which displayed fine on page one but not on the subsequent pages).

The formulas (as near as I can tell) in the header and footer are not stored in a single area, but in a field in every single record. So while one record (on mine) showed TempDate as the date I had selected, most were blank.

I solved this by adding a script.

1. Go to the field that has the correct information, and enter (or calculate the information needed).

2.Replace Field Contents (with current contents).

I seldom check back here but will try to in the next few days in case you have more questions about what I did (and I am a Filemaker dummy, so don't expect much).

Edited May 6, 2008 by Guest