Reporting \ Database Question

[srichardson]

I have created a survey and would like to create a custom Crystal report as the built in report writer does not provide what I am looking for. I have two types of questions in my survey, score fo 1 to 10 and free form text. I have found the text responses in the ResponseAnswers table but do not see don't see the responses for the questions that are on the 1 - 10 scale. Questions:

• How do I identify all of the responses that belone to one survey?
• Where would i find the responses to the questions that are on a 1 - 10 scale?
• What table are the questions stored in?

Thanks

Stacey

[pwiesner]

Unfortunately exporting results from Checkbox is a complicated process. Because much of the logic exists in code and not the database I can not point you toward specific stored procedures that will accomplish what you are looking for. Would it be a possibility to use the exported csv files as the source for your external reporting?

Typically detailed information about the database structure is reserved to customers who have developer support contracts. I am going to provide a high level overview below. If you have the developer contract please open a support ticket.

1Q - How do I identify all of the responses that belone to one survey?
1A - All responses are stored in the ckbx_Response table. A response is collection of answers. You can map a response to a specific survey by using the ResponseTemplateID to join on the ckbx_ResponseTemplate table. Individual answers are stored in the ckbx_ResponseAnswers table and are related to the response by the ResponseID column.

2Q - Where would i find the responses to the questions that are on a 1 - 10 scale?
2A - The ckbx_ResponseAnswers table contains columns for both the id of the item that was answered (ItemID) and, if it is applicable, the option that was selected (OptionID). Options being the potential answers to radio button, rating scale or checkbox questions. The details of question with options can be found in the ckbx_ItemOptions table.

3Q - What table are the questions stored in?
3A - As stated this is a difficult question to answer. There is not one table that contains item information. All items have an entry in the ckbx_Item table. Additional, type specific information, is stored in the varies ckbx_ItemData_xxx tables. SelectMany and Select1 items have option information in the ckbx_ItemOptions table.

I would suggest using SQL Profiler to capture the specific query generated when exporting survey results. In the past customers have found this to be a helpful starting point when creating custom queries.

[induswebi]

I am wondering if it is possible to use the checkbox API inside a new .NET 4.0 MVC 2 application to generate the HTML of a survey and then to save the question results. I have done this in a current C# Webforms application, but I am investigating converting some of this current application to MVC.