Re: Multiple fields in one column on a report

Home Forum Reporting Multiple fields in one column on a report Re: Multiple fields in one column on a report

#5876

First create a connection to your survey form. In the action you need no send parameters and return the caption value for every drop down.

In your report add two tables. The first table is a hidden helper table. It has 94 columns, one for each question. The second table should be read-only and have three columns: Question #, Yes, and No. Then you will need to add 188 hidden helper fields: a yes and a no counter field for each question.

When the report opens create a behavior that adds 94 new rows to the second table and number the first column sequentially from 1 to 94. To do this use a hidden helper field for the row count. If you don’t know how to do this let me know and I can describe it.

When the page opens create a behavior that uses a connect to enter the value of each question in all rows of each column of the helper table. Then use a Set Table Rows behavior object to move to the first row of the helper table and use a simple branch (is value in column 1 – current row = “yes”?). If true set the question 1 yes counter helper field with the formula: Value of question 1 yes counter + 1. If false set the question 1 no counter helper field with the formula: Value of question 1 no counter + 1. Then use another simple branch for question 2 and build it all of the way to question 94.

After question 94 move to a Set Table Rows behavior object and move to the first row of your read-only table. Then use a Set Field behavior object to set the value of your Yes column – current row with the value of the question 1 yes helper field. Do the same for the no column. Then move to the next row and do the same for question 2. Repeat to question 94.

Hopefully that is clear. The concept is simple but will be a bit tedious to build because you are dealing with a yes and a no for 94 questions.

Workflow software, Process software, Procedure software