InfoPath Dev

is it possible to use SQL Report Builder 3.0 & Infopath library to perform reporting?  I was going through Report Builder today, located the sharepoint list, found the list I needed, the fields, and tried to run a query, but it returned no results.....   Chris

You have multiple actions on a single rule. I am suggesting spliting some of those actions out onto new rules. See the New button in your screenshot? Click it and select Action. Your new action rule can have a condition, like "VoucherNumber is blank" - and then can run your query and set your voucher number field. Your other rule ...

I'm not sure how to if/else in the form submit or how to add multiple rules if possible. I already have a textbox called voucher number which is populated when the file is first submitted so I could query that but how would I say if vouchernumber is not blank     submit form else     create the ...

ok well I have solved the auto email side, and it works very nice. All done using Workflows, took me a little while to figure them out but now that I have I can have a very nice automated system.

Yeah, that is why I am saying do the following: Add a field to the main data source called something like "FileName" In your submit connection, use that field for your form name, and select the "overwrite existing" checkbox In your submit rules, where you have the rule to query for your data for the ID and set the ...

Hi, Yes to a sharepoint library. The problem with this is that when the form is submitted I am getting max(id) from the list to name my file so if the submit the file is named (for example) OP12.xml. If they make an amendment and submit again the file is saved as OP13.xml so we have 2 versions. I've got around it by setting a flag to true ...

Can you send a copy of the form and workbook you are using?  We have created an IP form with rest connections to Excel on O365.   Is the data content very large?

Hey there - You are submitting to SharePoint Library? When you set up your submit connection, you have the option to overwrite existing. If you ensure your file name for the submit will be unique, you can safely do this - take the whole saving thing off the table - users can just submit, and their updates update the existing item. You have to ...

Here's your form back - I've added to the error handling in the SubmitToSharePointList command. Save the file locally, and then right click on the saved file and select Design to open in design mode. From there you can preview - hopefully you'll find a lot more info in the error node this time - reply here with the error text....

You can send it to support AT qdabra DOT com - just reference this thread when you send it.