How do I find the table/column for a survey or questionnaire?

[annominous]

My company uses a survey that is tied to a questionnaire. I want to pull the responses potential clients give to the survey into a report, but I don't know how to determine which table and column contains that information. Any pointers on how I might be able to determine that?

Thanks.

[SanjivMeher]

Navigate to Survey->Survey Responses, and you should see the responses and the corresponding questions.

[annominous]

sanjivmeher - Sanjiv, thanks.

I'm assuming that you mean I should navigate to Survey -> Survey Responses in the Choose Columns pop-up window of the report editor, correct?

If so, I don't see Survey in the column list, which I'm guessing means that it's not configured to be included in reports. Is that correct and, if so, can you tell me how I can get that information added to a table or data source?

Thanks.

[antin_s]

Metric Result (asmt_metric_result) table would have Survey results.

[SanjivMeher]

Survey Instance has the parent instance record. If you open one of the records, you will see the list of answers under the related list.

You can directly open the answer table by navigating to asmt_assessment_instance_question.list