I saw an old thread from last fall that is closed now, but I thought I might be able to help someone else by posting a solution...
This is the original posting & thread number:
thread149-1155590
I am using CRv10 - but can also use CRXI.
I have been requested to create a report with a pie graph that shows a pie section for each of the groups listed in the report (there are 9 different groups in total).
The pie should show each group as equally sized pieces. If the group returns no data - the report should show the pie piece with a specified colour (lets say black) - if the group does have data - any other colour will do. I have managed to show the chart with the different groups - but had to resort to assigning the same value to each group (value = 1) for it to work. I would like to colour highlight the chart using a different value but the chart would not allow a second value.
I have tried almost every approach I can think of without success.
Any anyone come up with a suggestion that will show this breakdown - (I don't mind if the graph is not a pie)? Any ideas (no matter how unusual) would be greatly appreciated.
Cheers
paulmarr
----------------------------------------------------------------
I recently had a similar challenge and I ended up using a crosstab. It works b/c you can use the Highlighting Expert to make the cell colors change based on value=1 or value<>1... so it wouldn't be a pie chart, but if a rectangular grid is acceptable, this might be a solution. In the Highlighting Expert, I set the background and the font color to the same color, and then you can't even tell there's a number in the cell.
This is the original posting & thread number:
thread149-1155590
I am using CRv10 - but can also use CRXI.
I have been requested to create a report with a pie graph that shows a pie section for each of the groups listed in the report (there are 9 different groups in total).
The pie should show each group as equally sized pieces. If the group returns no data - the report should show the pie piece with a specified colour (lets say black) - if the group does have data - any other colour will do. I have managed to show the chart with the different groups - but had to resort to assigning the same value to each group (value = 1) for it to work. I would like to colour highlight the chart using a different value but the chart would not allow a second value.
I have tried almost every approach I can think of without success.
Any anyone come up with a suggestion that will show this breakdown - (I don't mind if the graph is not a pie)? Any ideas (no matter how unusual) would be greatly appreciated.
Cheers
paulmarr
----------------------------------------------------------------
I recently had a similar challenge and I ended up using a crosstab. It works b/c you can use the Highlighting Expert to make the cell colors change based on value=1 or value<>1... so it wouldn't be a pie chart, but if a rectangular grid is acceptable, this might be a solution. In the Highlighting Expert, I set the background and the font color to the same color, and then you can't even tell there's a number in the cell.