I have created a form using InfoPath and published it to a form library on my MOSS 2007 server. This form has 2 views - the default view is for users completing the form, and a second view that administrators can view to see the form plus some additional information I'd like to add to the bottom.
This additional information is metadata about the form itself, specifically the "Created By" and "Created" values from the form library. So, when the second view is displayed, the administrators should see the form as well as the name of the person that submitted the form and when it was submitted.
I have found some information online about using a query data source to do this but I have had no luck. I have created the data source to point the form library, to include data for the active form only, and to automatically retrieve data when the form is open. I then opened my second view and inserted both of the fields using the data source pane on the right of the screen.
So far this seems to be correct, however when I submit a form and then open it from the form library and view the second view, I do not see the additional fields for "Created By" and "Created' at all. When I initialy inserted them into the form the application put them into a repeating section automatically, but I have also tried inserting them as non-repeating text boxes, and in that case even though I do see the fields there is nothing displayed in them.
I have also tried using a Rule and a Refresh button to refresh the query (secondary) data source, but the data is still not displayed. I'm sure it must be something simple that I'm doing wrong but I cannot figure out what I'm doing differently than all the examples on the web.
Any help is greatly appreciated!
Thanks,
Chanda
View Complete Post