Calculation not showing in pdf

[kellywood1]

Hi!  Hopefully, someone can help me.  I made a grid that should show each lines sale total and in the second line it is not showing the total when you test the form in pdf preview.  All the calculations and everything look the same as the other lines that are showing the total.  Does anyone have any ideas on what would make a line not show a total when all the others do?  I have the form attached.

[Former Community Member · Accepted solution]

I do not know why it is happenin but if you change the binding on the total field to Normal it works just fine.

Paul

[kellywood1]

That worked!!  Thanks!!!

[Jono_Moore]

Paul beat me to it.

You have all of the fields on your form set to Global binding, which depending on what you are trying to do is probably not what you want. Global binding means that every field with the same name will get the same data.

Also (again depending on what exactly you're trying to accomplish with the form) there's an easier way to deal with tables and table calculations.

There's a good diagram in the help - search on "to perform calculations in a table" - basically if you let the table auto-number the rows (leave the Row1 name alone and when you duplicate the rows each subsequent Row1 will get an instance number after it e.g. Row1[1]) and leave your cells the same name (you don't need to rename them for every row) you can then use wildcards in your Total calculations and maintenance on your form will become much easier (in case fields get renamed, etc.).

[kellywood1]

Thanks for the info! I have it on the Global binding because I have 3 different forms and I want the information to automatically populate in the other forms. Does anyone know how you can make the print buttons print a specific page, not all of the pages?  

[Jono_Moore]

A caveat I'd add for the Global binding is the way you have it set up if someone changes a value on one of the other pages it will change the other references as well - if you don't want someone making changes on one of the other pages you should make the fields on those pages read only.

As for printing, xfa.host.print() is what you want.

This will print page 1:

xfa.host.print(1, "0", "0", 0, 0, 0, 0, 0);

For a list of the variables check the help under: Scripting > Scripting Reference > Scripting Methods > print

[kellywood1]

Thanks.  Ugh!  Now I am running into another problem!   I realized that my margin calculation wasn't right because I didn't have the garment costs in my formula.  Everytime I try to add it into my costs cell the program crashes!! I'm so close to being done!

[Former Community Member]

Global binding only works in a a single form. It will not work across forms.

Paul