Omitting certain fields on the form from the output XML

[vodred]

Hi,
I want certain fields in the form not to show up in the XML data saved
after the user fills the form. I need those fields for display and
calculation purposes only(So using an expression box is ruled out). How can I
achieve this? Here is the scenario

Option 1
field1 , field2, field 3 etc
Option 2
field4, field5

If option 1 is chosen, I want the sum of all the fields in option to be
assigned to another field called "TOTAL"
If option 2 is chosen, I want the sum of fields in option 2 to be assigned
to the field "TOTAL"

I only want TOTAL to appear in the saved XML file and do not want the fields
field1, field2 etc

Thanks for your help in advance

 

[Josh Bertsch [MSFT]]

Values that are stored in the XML are used to do your calculations. Without
those values or the XML nodes that store those values, the calculations
couldn't take place. As such, there really is no way that those values
could be removed and still have the calculations work properly.

--josh bertsch

 

[virgul]

Hi You can try to store your field1,field 2,... etc. in a secondary
data source (like an xml) and put only the fiel TOTAL (and the other
field that you need) in your primary data source so only total appear
in your template.xml (it's the file who is send when saving your form).
That work I have try.

If you don't understand ask for more

++

 

[vodred]

Thanks Virgul. I will try that. I have another question though. When the
saved XML is opened in infopath , will it retrieve field1, field2 from
secondary datasource?

Thanks