.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

How to sum up InfoPath calculated fields

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :SharePoint
 
I have a repeating table with calculated fields on each row.  At the end, I need to sum up all these calculated fields into total.  Which total is also a calculated field to sum up 2 calculated fields in the repeating table.  The total never show anything after data entry.  How can I sum up total from the calculated fields?  For example: QTY 1 of a Computer would cost $1000.  In the repeating row, I will allow customer to fill in multiple rows.  A field named line item total is a calculated field named EXTCOST which is set to QTY X Computer = $1000.  At the bottom of the form, I would like to sum up EXTCOST to get the Grand Total Cost.  The Grand Total Cost is fomat as SUM(EXTCOST) which is zero at all time. Please advise. Brian.


View Complete Post


More Related Resource Links

Calculated Date Fields

  
I'm trying to calculate whether a delivery is on time or late and by how many days. Is there a way to format the column so it show's the result in the number format as opposed to showing up as a date? Negative numbers don't export into excel well.

Changing fields while updating an InfoPath Form to a SharePoint 2010 Document library

  
My document library has following EventReceiver: <?xml version="1.0" encoding="utf-8"?> <Elements xmlns="http://schemas.microsoft.com/sharepoint/"> <Receivers ListTemplateId="101"> <Receiver> <Name>EventReceiverDocumentLibraryItemUpdating</Name> <Type>ItemUpdating</Type> <Assembly>$SharePoint.Project.AssemblyFullName$</Assembly> <Class>EventHandling.EventReceiverDocumentLibrary</Class> <SequenceNumber>10000</SequenceNumber> </Receiver> </Receivers> </Elements> Updating a browser enabled InfoPath form in the document library fires following event: Public Overrides Sub ItemUpdated(ByVal properties As SPItemEventProperties) Try Me.EventFiringEnabled = False properties.ListItem("Lastname") = "Testperson" properties.ListItem.ParentList.ParentWeb.AllowUnsafeUpdates = True properties.ListItem.SystemUpdate(False) ' solution 1 properties.ListItem.Update() ' solution 2 properties.ListItem.UpdateOverwriteVersion() ' solution 3 properties.ListItem.ParentList.ParentWeb.AllowUnsafeUpdates = False Me.EventFiringEnabled = True MyBase.ItemUpdated(properties) Catch ex As Exception Me.EventFiringEnabled = True E

Calculated Fields and Lists.. do tell!

  
Ok, so I have a massive Excel Spreadsheet with some lookups and calculated fields.  I need to port this over to a SharePoint list.   I'm guessing for something like this the Import Spreadsheet function won't cut it.. and that I have to rebuild the spreadsheet essentially from scratch and start from there. Is this the case? Once I create the columns as I want them, can I still port over the information (data) in the spreadsheet or am I essentially pooched when it comes to porting that data over?    Thanks!   J

Using UserName to enable disable access to InfoPath form fields

  
Hi Everyone, I have created a browser enable form in InfoPath and restrict certain fields depending on the official logged on User Name. Now this works most of the time but my problem has to do with the "case" of User Names for some of the site users. In most cases the User Name is an exact match but for some reason, some user's names are reported by SharePoint (the Welcome at top of screen) with some parts captilized. Example - my hidden filed on the form reports my user name as xrs_master but the Welcome up top says XRS_Master - and the fields act as though I am not the correct user and won't enable. On the other hand there are users who's user name matches the case exactly and all works fine. Why is SharePoint reporting the user name differently? And if this is the reason they don't match, how do I fix it? Any Ideas? Many thanks in advance for help!

Types of calculated fields in a query

  
Hello, I have a question about how the SQL server engine determines the types of calculated fields. For simple calculations I assume it's based on the types of the fields composing the query as they are defined in their tables, but what about a calculated field in this form, for example: isnull(field-name,-99)? Is there a way I can change the engine's selection in the query? Thanks.

Types of calculated fields in a query

  
Hello, I have a question about how the SQL server engine determines the types of calculated fields. For simple calculations I assume it's based on the types of the fields composing the query as they are defined in their tables, but what about a calculated field in this form, for example: isnull(field-name,-99)? Is there a way I can change the engine's selection in the query? Thanks.

infopath 2007 Expected value type: end-of-string ! calculated field

  
Hello I am using infopath since there is no field with type date and time in InfoPath 2007. I created three fields one for date one, for hours, and one for minutes then I created forth field that concatenate the values of the three fields this field will be used as column in form template library used by my form. All seems good so far but when I tried to concatenate those fields go the following error Expected value type: end-of-string how can I solve this ? my xpath looks like ../my:calmomoDate../my:cbmomoHours:../my:cbmomoMunites Thanks  Momo

Get fields from InfoPath?

  

Hi all

I am using an web enabled infopath form to register leads for our crm system from sharepoint.

I want to get data from theese fields in infopath, and put them in our crm system, via a web service. I am using MOSS 2007 Enterprise.
I am having problems retrieving the fields from infopath, and map them to crm.

Any suggestions how that can be done or samples would be highly appreciated.

Regards


How to remove * for validation fields in Infopath 2010

  

Hi,

I am using Infopath 2010 and i had written validation rule for a fields.While loading the form field is showing with red * mark.It will go away as soon as i enter value but i don't want to diaply red * even i don't enter value just display a tooltip message saying that "Please enter vale" on submit button click.

Please help me in this out?

-Bassu


Update Infopath Fields with SharePoint Designer Workflow

  

Hi All,

Is there any way to update InfoPath Field and column with SharePoint Designer Workflow? I have an InfoPath Form Library on which I have published an InfoPath form. Now I want to change values of submitted infopath forms using SharePoint Designer Workflows ?

For your Information:

I am using SharePoint 2007 updated with SP2.

 

Regards..

 


Update Infopath Fields with SharePoint Designer Workflow

  

Hi All,

Is there any way to update InfoPath Field and column with SharePoint Designer Workflow? I have an InfoPath Form Library on which I have published an InfoPath form. Now I want to change values of submitted infopath forms using SharePoint Designer Workflows ?

For your Information:

I am using SharePoint 2007 updated with SP2.


load users records in infopath fields without using "run the query" button

  

hi,

is it posible to instead of clicking the "run the query" button to load the users records in the fields that the fields load automatically.

can this only be done with a role and a "set a value's field" action? 


SharePoint 2010 External Content Type and InfoPath 2010 - Numeric data type fields missing in InfoPa

  

Connected SQL data table to SP 2010 ECT from SQL table.  The SQL table has several fields that have a type of "numeric(3,0)".  The SP 2010 list shows all fields form SQL.  When we open up InfoPath Designer and reference the SP List data (from SQL) all of our numer fields are missing from the available fields list.

I amd going to try another data type but that hardly feels like a solution.  If anyone has any ideas please let me know!


Sharepoint calculated fields?

  

Hi all,

 

I have a quick question for you in relation to sharepoint calculated fields.

 

I am trying to set up a method in calculated fields, using the task list

to enter in the status (not started, In progress, Completed, Deferred, Waiting on someone else)

 

Basically when the user selects t

Workflow <=> Infopath Fields

  

I have an initialisation infopath-based form with text fields in it (ad accounts, like domain\user).

Can i make an input field like in sharepoint field of "User or Group" Type, where u can search users over domain?


Adding Calculated fields to a databound control

  

I need a form that displays three columns drawn directly from a database (no problems here) as well as two fields that require some complex calculations.  Not only am I lost as to how to incorporate the calculations into the control, I don't know exactly how to write the calculations. I am working in Visual Web Developer 2008 with Vb.NET.

The first of the two fields should take the sum of all payments made by a given customer and divide it by a DailyMembershipRate, returning a DaysPaid variable. It should take this variable and a CustomerSince field for that particular customer and calculate a PaidThrough field.

The second of the two columns similarly requires the DaysPaid variable described above. It should subtract the CustomerSince field from the current date and return the value in days, giving a MembershipDays variable. Finally, it should subtract MembershipDays from the DaysPaid variable, again returning a value in days, and then multiply this by the DailyRate value for a Credit/Deficit field.

I realize this is a lot, but I haven't been able to find any documentation either online or in VWD or ASP.NET texts on this topic. I could really use some fellow user input. I would really appreciate any help or general direction you're willing to offer. Thanks a

Projected Fields not available in InfoPath data connections

  

Projected fields are a nice way to join lists and show fields from related lists in the same view without physically duplicating fields. Unfortunately, these projected fields are not available in InfoPath data connections. I am now tempted to duplicate data and to maintain physical copies of fields in multiple lists to overcome this limitation, but it makes me uneasy ;-) 

I must add, the InfoPath form is a list based form without code behind. 

If you guys have a better idea, please let me know. thanks.


Iko
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend