Hola amigos, soy realmente nuevo, super novato en .NET y tengo problemas para generar graficos en Visual Studio.
Tengo la siguiente vista desarrollada en sql server
Código:
SELECT id_ev_pai, Alumno, Profesor, Escuela, Grado, Grupo, ID,
SUM(
CASE WHEN R4 = 1 THEN 1 ELSE 0 END +
CASE WHEN R26 = 1 THEN 1 ELSE 0 END +
CASE WHEN R55 = 1 THEN 1 ELSE 0 END +
CASE WHEN R103 = 1 THEN 1 ELSE 0 END +
CASE WHEN R6 = 1 THEN 1 ELSE 0 END +
CASE WHEN R71 = 1 THEN 1 ELSE 0 END +
CASE WHEN R24 = 1 THEN 1 ELSE 0 END +
CASE WHEN R99 = 1 THEN 1 ELSE 0 END +
CASE WHEN R27 = 1 THEN 1 ELSE 0 END +
CASE WHEN R48 = 1 THEN 1 ELSE 0 END +
CASE WHEN R64 = 1 THEN 1 ELSE 0 END +
CASE WHEN R97 = 1 THEN 1 ELSE 0 END +
CASE WHEN R29 = 1 THEN 1 ELSE 0 END +
CASE WHEN R50 = 1 THEN 1 ELSE 0 END +
CASE WHEN R73 = 1 THEN 1 ELSE 0 END +
CASE WHEN R90 = 1 THEN 1 ELSE 0 END +
CASE WHEN R32 = 1 THEN 1 ELSE 0 END +
CASE WHEN R49 = 1 THEN 1 ELSE 0 END +
CASE WHEN R77 = 1 THEN 1 ELSE 0 END +
CASE WHEN R88 = 1 THEN 1 ELSE 0 END
) as Poco_Logrado,
SUM (
CASE WHEN R4 = 3 THEN 1 ELSE 0 END +
CASE WHEN R26 = 3 THEN 1 ELSE 0 END +
CASE WHEN R55 = 3 THEN 1 ELSE 0 END +
CASE WHEN R103 = 3 THEN 1 ELSE 0 END +
CASE WHEN R6 = 3 THEN 1 ELSE 0 END +
CASE WHEN R71 = 3 THEN 1 ELSE 0 END +
CASE WHEN R24 = 3 THEN 1 ELSE 0 END +
CASE WHEN R99 = 3 THEN 1 ELSE 0 END +
CASE WHEN R27 = 3 THEN 1 ELSE 0 END +
CASE WHEN R48 = 3 THEN 1 ELSE 0 END +
CASE WHEN R64 = 3 THEN 1 ELSE 0 END +
CASE WHEN R97 = 3 THEN 1 ELSE 0 END +
CASE WHEN R29 = 3 THEN 1 ELSE 0 END +
CASE WHEN R50 = 3 THEN 1 ELSE 0 END +
CASE WHEN R73 = 3 THEN 1 ELSE 0 END +
CASE WHEN R90 = 3 THEN 1 ELSE 0 END +
CASE WHEN R32 = 3 THEN 1 ELSE 0 END +
CASE WHEN R49 = 3 THEN 1 ELSE 0 END +
CASE WHEN R77 = 3 THEN 1 ELSE 0 END +
CASE WHEN R88 = 3 THEN 1 ELSE 0 END
) as Logrado,
SUM (
CASE WHEN R4 = 4 THEN 1 ELSE 0 END +
CASE WHEN R26 = 4 THEN 1 ELSE 0 END +
CASE WHEN R55 = 4 THEN 1 ELSE 0 END +
CASE WHEN R103 = 4 THEN 1 ELSE 0 END +
CASE WHEN R6 = 4 THEN 1 ELSE 0 END +
CASE WHEN R71 = 4 THEN 1 ELSE 0 END +
CASE WHEN R24 = 4 THEN 1 ELSE 0 END +
CASE WHEN R99 = 4 THEN 1 ELSE 0 END +
CASE WHEN R27 = 4 THEN 1 ELSE 0 END +
CASE WHEN R48 = 4 THEN 1 ELSE 0 END +
CASE WHEN R64 = 4 THEN 1 ELSE 0 END +
CASE WHEN R97 = 4 THEN 1 ELSE 0 END +
CASE WHEN R29 = 4 THEN 1 ELSE 0 END +
CASE WHEN R50 = 4 THEN 1 ELSE 0 END +
CASE WHEN R73 = 4 THEN 1 ELSE 0 END +
CASE WHEN R90 = 4 THEN 1 ELSE 0 END +
CASE WHEN R32 = 4 THEN 1 ELSE 0 END +
CASE WHEN R49 = 4 THEN 1 ELSE 0 END +
CASE WHEN R77 = 4 THEN 1 ELSE 0 END +
CASE WHEN R88 = 4 THEN 1 ELSE 0 END
) as Pendiente
FROM vw_ev_1ro
group by id_ev_pai, Alumno, Profesor, Escuela, Grado, Grupo, ID
Y cada vez que intengo generar un grafico me da errores. Tal vez estoy siguiendo el tutorial equivocado pero no logro dar con el sentido de como generar el grafico. Alguien podria darme una idea o ayuda?
Gracias.