I have 2 separate dynamic form pages on my website and i want to be be able to use the dynamic view to view results from both forms.

What i did:

I created two pages for the dynamic view and on the first instance, it works great and i can view all my results posted there.

i then created another page and put in the dynamic view module and tried now to view results of the second dynamic form by selecting that instance in the dropdown. the columns then generated are those of the first instance and i want column of the second instance. can you please help me on this issue or how i can go around this problem.

Hello Patsoncc,

You can do this with one Dynamic View and use a Custom SQL data source to pull in all of the columns from both Dynamic Forms by using an INNER JOIN or LEFT OUTER JOIN in SQL.

Then generate columns and you'll have all of the columns you wish to use in the Dynamic View.

If you have any questions please let me know.

Thanks,

Ryan

Can you please help me with this sql query. The data is normalised in the table DynamicForms_QuestionResponse and would need to get corresponding column names from DynamicForms_Question.I cant figure out how to get unique rows as enter on the form itself and to generate the columns for my template.

i created my own table as test and could get all columns and unique rows.I used Custom SQL data source as you advised. i can view data and export to pdf which what i want to be able to do with the issue above.

(* is there a number that we can talk directly to you guys when u are available?)

i know I am still a nubie :-)

Hello Patson,

Do you still need help on this?? I believe I helped you the other day with fixing your Dynamic View. Let me know if you have any other questions.

Thanks,

Ryan