'RLDC Grouping on multiple columns: Group1 = Column1.Value, Group2 = Column2.Value, Group3 = Column3.Value, etc

My dataset contains rows with answers to multiple choice questions (the questions allow only one answer for each respondent). Each row also contains all possible answers to that question.

example:

Respondent Question Answer Answer1 Answer2 Answer3 Answer4

John StackOverflow is great! fully agreed fully disagreed disagreed agreed fully agreed

Mary StackOverflow is great! agreed fully disagreed disagreed agreed fully agreed

I would like to:

Design a graph with all possible answers in it, even when a certain answer is not given by a respondent. When an answer is not in the dataset I would to show it with 0 (zero).

Is there an automated way, where grouping is based on columns Answer1, 2, 3, 4 ?

I allready designed a table in which I defined rows for each possible answer, with columns that are 'filled' with a colour, based on the number of answers. But that is very time consuming and it slows down the report.

Thank you in advance, Max

rdlc


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions