Venn diagram? Anyone made one in fast reports?
I need to make a Venn diagram consisting of three intersecting sets with names of people in each set & intersection.
The data comes from a database. I can generate the sql to either get each of the 7 different data sets (for the 7 different parts of the Venn diagram) or get one data set with some sort of flag to indicate the section. However I'm not sure how to construct the report so that I get overlapping circles with the names in the right places. There is likely to be around 100 names in total.
Also I'm not sure about colouring the seven different sections as although I can colour a circle I can't colour the intersecting bits a differet colour. The sets do not have to be circular however.
Any help would be appreciated, or a confirmation that it can't be done!
The data comes from a database. I can generate the sql to either get each of the 7 different data sets (for the 7 different parts of the Venn diagram) or get one data set with some sort of flag to indicate the section. However I'm not sure how to construct the report so that I get overlapping circles with the names in the right places. There is likely to be around 100 names in total.
Also I'm not sure about colouring the seven different sections as although I can colour a circle I can't colour the intersecting bits a differet colour. The sets do not have to be circular however.
Any help would be appreciated, or a confirmation that it can't be done!