WFFM Detailed Reports are empty

Question

This is an 8.1 Update 2 setup, but the client does NOT have xDB (although we set up the Mongo connection strings, etc). We were getting 500 errors when hitting the Form Reports section for the APIs using the default analytics provider, so I switched to the SQL provider since xDB wasn't in use. That's working to fill in the Summary tab and to allow for exported data, but the Detailed Reports tab is coming back with "no data has been set."

When I look at the WFFM database in SQL, there are only two tables, one of which has fields with a ContactID and InteractionID, which have GUIDs filled in. I assume this would be the data saved to Mongo if xDB was running, but without it, those IDs don't appear to be otherwise used. I have the VisitorIdentification tag in the layout, and Analytics.PerformLookup is set to true. I also set my local session state expiration to 2 minutes in web.config to flush out the session.

If xDB isn't part of the license, is that Detailed Report tab essentially unavailable, since it requires the Contact and Interactions information from xDB?

Answer 1

I'm afraid the answer is no. The information on the form reports can be found here: https://doc.sitecore.net/web_forms_for_marketers/81/using_web_forms/form_reports/the_web_form_reports

For the detailed reports it says that the report:

Lists the contacts that have interacted with the web form.

As you don't have contacts without xDB, that's going to be difficult...

Each row in the report should contain the following information: Name, Date, Value, Visits, Submission attempts, Dropouts, Failures, Result.

Most of that data is in the xDB contact, so the reports is indeed not really possible without xDB enabled.