InfoPath Dev

There are many things that cannot be done during a view switch -- including switching to another view during a view switch (i.e. redirecting the view switch elsewhere). Closing is also not likely available during that event. However you can place a button in the view (I know--not what you want to do--not automated enough) that the user can click ...

Great work! Yes, since print views are not meant for editing, you can get away with a few extra things in them.

Expression boxes, unfortunately, do no support rich text. There's a hack you can do to the XSL file to make them show rich text, but it is not supported and InfoPath will revert your change unless you put your expression box into a Preserve Code Block -- a lot more work than it is worth. Since your view is strictly a Print View, just use a ...

You can set up a rule on the button to close the form. However, launching a web page is not supported via rules. You can probably do this in code, or if you put the button in the task pane, you can definitely do this.

You will have to write some code (you are using managed code, yes? C# or VB.NET) to save your file to disk. There should be plenty of examples of how to write managed code to save a file to disk available on the Web for your favorite programming language. Doing this will likely require you to have a full-trust form.

Great! Glad you got it working. I was going to suggest the following: Design an new blank InfoPath form template from your SQL source. Add your tables and child tables as needed. It should create a nice hierarchical structure for you. Modify your main data source and look at the SQL that InfoPath created... it will give you the exact ...

Glad to be of help. The easiest solution (if possible) is to convince them that it is okay to have the header/footer on the cover page.

Glad to have helped!

1. What kind of values are in @TRASPORT_NUM? Just numbers? 2. Are there ANY rows of @TRASPORT_NUM at all when you get this error value? 3. Are there any rows of @TRASPORT_NUM that have non-numeric values? I don't get 1.#QNAN, but if I have no rows, or any rows that have non-numeric values, I get NAN. This is expected.

You can create an XML file and add it to your template as a secondary DOM. Then, using code you can add/remove nodes all you want. This has to be done using code (as appropriate to the coding language you are using). But again, the DISPLAY of those nodes requires that they exist during design time or you cannot bind controls to them in the ...