-
The XPath is still not right... your filter on d:TOSS is comparing the first instance of @employeeDepartment (i.e. the field value on the first row of the table) to itself.
The beginning of the filter (or the parts in the square brackets '[ ]' is an absolute path to the first row of d:TOSS. The second part of the filter steps back up the tree, ...
-
Great! Glad to hear you got it working!
-
Yes, once you have the position of the row, you can use that position in a filter (i.e. Table/Row[Number]/FieldOfInterest).
You are getting 1 back because somehow you are not connecting to the master table properly with your XPath, and you've specified 1 as teh default return value. When you look in your view .xsl file, you will find existing ...
-
-
Can this Xpath work
sum(xdXDocument:GetDOM(''TOSSReceive'')/dfs:myFields/dfs:dataFields/d:TOSS[xdXDocument:GetDOM(''TOSSReceive'')/dfs:myFields/dfs:dataFields/d:TOSS/@employeeDepartment = ../../dfs:dataFields/d:TOSS/@employeeDepartment]/@monthlyExpenses)
or is it best to edit the SQl connection to do this
-
Hi
I have six views within one form and we would like to print out all the forms that have been filled leaving the remaining unfilled forms out of the print job. Within most forms we have expandable text boxes and would like to have our printed forms to be nice and neat, if you know what i mean, within nice sections. Some of the views may ...
-
Hi
Sorry but I fixed the submission to Sharepoint! It was the path name, my folder had a space so I inserted %20 for the space and it work. Many thanks for all your help.
Ali.
-
Its coming from my secondary data source, because that is where I want to add up the totals depending on department.
-
Greg this is the Xpath I put in the ytdExp0enses text Box
sum(xdXDocument:GetDOM(''TOSSReceive'')/dfs:myFields/dfs:dataFields/d:TOSS[xdXDocument:GetDOM(''TOSSReceive'')/dfs:myFields/dfs:dataFields/d:TOSS/@employeeDepartment = ../../dfs:dataFields/d:TOSS/@employeeDepartment]/@monthlyExpenses)
-
What file (extension) do I try and open with notepad?