One line per record

[brian123]

I am trying to figure out to display responses from users to one line via a report. I am currently collecting responses (yes/no) to two questions and when displaying them i have two lines for each user. 1 line is for the response to the first question and the 2nd line is for the second question. How would i go about getting this to reach onto one line?

Report.pdf

[MayMusic]

Instead of creating your report based on a view which is joining response and user table, create your report based on user table and for the scores add one calculated field for each column you want to read the value from response table. Use SQL select to get the values. For instance:

SELECT [ColumnName] FROM [ResponstTableName] WHERE [UserIDColumnName from Response table] = target.[@field:UserID]

 

Select [@field :UserID ] from Picker