Here's the basic report I'm trying to create. Across the top running horizontally I'd like to display a list of questions...(Q1, Q2, Q3, etc...)

Going vertically are the user names of the people who answered the questions. And in the middle I'd like to see the answers they gave as well as any comments they made.

To get the data is a little tricky. I insert the cross-tab report in the report footer. I can get the correct questions to display and the correct user names as well as their answers. But as soon as I try to add in the comments, the comments are always added in the next column over for the next question.

The comments and the answers are stored in the same field:

{@AnswerFormula}
if Question.Label = 'Answer' then
Answer.TextAnswer

{@CommentFormula}
if Question.Label = 'Comment' then
Answer.TextAnswer

Writing each of the above in their own formula is no problem. But as soon as I concat the two formulas in the cross tab report, it will always show the comments for Q1 in the Q2 answer, the Q2 comments in the Q3 answer, and so on.

Is there any quick way to get them to simply go back one column?