Print text field for last of a "group"

[steven.song]

I am trying to create a report for a questionnaire in JapserStudio.

This questionnaire allows for multiple question types: Yes/No, Multiple Choice, Select Multiple etc.

I'm running into an issue where for a question with a select multiple answer - they are also allowed to add a note to a question. I can have the question note successfully display after the first of the multiple answers but would of course prefer it to appear at the very end.

ie: This is what is happening now

Question 1	Answer 1 for Question 1
	Note for Question 1
	Answer 2 for Question 1
	Answer 3 for Question 1
Question 2	Answer 1 for Question 2

What I would like to happen

Question 1	Answer 1 for Question 1
	Answer 2 for Question 1
	Answer 3 for Question 1
	Note for Question 1
Question 2	Answer 1 for Question 2

Anyone have any suggestions on how I might accomplish this?

Thanks

 

[riodavid]

What does the DB structure looks like?

[steven.song]

On the DB the questions, answers and notes are all on different tables so I'm using joins to get the data together.

The joins return rows with no nulls as none of them are left. There are additional joins as well.

Would like to avoid manipulating the data in MSSQL if possible. 

[steven.song]

I've solved this by using table and group footer