-
That is the way Office 365 returns user name, I'm afraid - so yes, a different result than you see in Filler / Preview.
-
If you set up the filter using the UI - select @SPCurFYNum and "is equal to" and SPNewFY, then change the first drop down to "The expression" you can manually add the substring-before bit.
-
max(@ReqNum[substring-before(@SPCurFYNum, '.') = SPNewFY])
-
Well - you don't have to do anything for the Request Number, just for getting that Fiscal Year filter to match. So you could use substring-before on the "." in the FY from SharePoint.
-
Right, that returns the items that match. Then you use the count function to count them....
-
If you set the query field in your Detention List data connection to the selected date, then execute the query, you should get back just the rows that match. No need to filter in your count formula. :)
-
I just tried this type of formula in a test form and it worked as anticipated. Offhand, I'd guess that @SPCurFYNum is not equal to SPNewFY - possibly because the data returned by the secondary data connection has decimal points or some other different. Can you drag your secondary data source data fields onto the form and take a look at the ...
-
Make sure your form is a filler form and it has to be full trust.
-
Yah, I think the expression needs to be modified manually. Can you open the filter dialog and set it up with Name = Name, then click the first drop down and set that to "The expression" then copy out the XPath that appears and paste it in a reply?
-
This appears to be VB, sort of, not C#. I don't think you need your "using" namespaces. I'd just get rid of the using / end using and replace "this.print()" with "Me.Print()" (https://msdn.microsoft.com/en-us/library/office/Aa944006.aspx?cs-save-lang=1&cs-lang=vb#code-snippet-2)