InfoPath Dev

 Unfortunately I think that would go against my company's policy though I will try to ask around if I can do that.  The actual data is completely fake but since it is on our work server I have no idea if It's permissable.  I realize it may be impossible to troubleshoot further without it but you have been a huge help ...

I found that using this filter - [my:Total != 0 or my:PullID !=''] works just fine for my scenario. 

It appears that it does not like the syntax.  I get a "Failed to generate batch from mapping" error with the combined rule. 

DBXL requires Microsoft's SQL Server 2005 or 2008. You can obtain the free (Express) versions from Microsoft if your server does not have SQL installed. Once SQL is installed and ready, go ahead with the DBXL installation.

Do you have SQL server installed on your server?

Any chance you can attach your template to a reply? Under the Options tab.... then I can maybe see what's up?

SQL instance? Do I need to run a sort of program or something? I have a Microsoft Server 2008 r2 is this the SQL instance? Or is the SQL instance sharepoint? Thanks already

 Just for a little more info:   - I have 5 items in my SP list - It puts 5 rows in my IP table with IDs of 5-1 - It is loading all IP rows with the data from the SP row with an ID of 1 - One of the columns is staying blank for all rows even though there is data in the list; this formula is the same as the others ...

 FYI, I just tried using the XML count and I think it does what it's supposed to.  I'm getting very close but I seem to have one more issue.  When I preview the form it correctly inserts the same number of items that I have in my SP list but the data in the other columns all comes from the first ID in the list.  I will ...

Hello Hillary, This is a great forum and it has helped me a lot. Thanks! I was able to follow your sample below and apply it to a form I'm working on, I'm able to build the new query to execute a stored proc, and I see the new string with the proper syntax, and it seems like the form is executing it, but I do not see any records ...