Running DNN 4.4 Report Module with the Chart Visualizer fails to render an image
Using this query:
SELECT r.RoleName as 'Role', COUNT(ur.UserID) as 'Users',
(CASE
WHEN (COUNT(ur.UserID) > 10) THEN '#00FF00'
ELSE '#000000'
END) as 'Color'
FROM Roles r
INNER JOIN UserRoles ur ON r.RoleID = ur.RoleID
GROUP BY r.RoleName
Setting:
Chart Visualizer is installed
Vertical Column Chart
Enter a Width and Height 400x300, Enter the X-Axis Title: 'Role',
Enter the Y-Axis Title: 'Users in Role',
Enter the Bar Name Column: 'Roles',
Enter the Bar Value Column: 'Users'
Select "One Color per Bar" and enter 'Color' as the Bar Color Column
All values without quotes
We received this reported exception from Visual Studio: ChartImage.ashx at line 165 > context.Response.Flush()
An exception of type 'System.Web.HttpException' occurred in System.Web.dll but was not handled in user code
Additional information: Server cannot append header after HTTP headers have been sent.
Any suggestions would be greatly appreciated