0 THEN 1 ELSE 0 END) AS LZ_CTS, SUM(CASE WHEN AgoMx > 0 THEN 1 ELSE 0 END) AS MX_CTS, SUM(CASE WHEN AgoMz > 0 THEN 1 ELSE 0 END) AS MZ_CTS, SUM(CASE WHEN AgoVe > 0 THEN 1 ELSE 0 END) AS VE_CTS, SUM(AgoLz) AS LZ_MONTO, SUM(AgoMx) AS MX_MONTO, SUM(AgoMz) AS MZ_MONTO, SUM(AgoVe) AS VE_MONTO FROM VT9000_IngresosPorClientePorMes"; //Ejecutar Query $result = sqlsrv_query($con_comercial, $sql); $result2 = sqlsrv_query($con_comercial, $sql2); ?>

INGRESOS MANZANILLO AGO/2018

Actualizar Regresar
". "". "". "". ""; while($row = sqlsrv_fetch_array($result)){ $monto = number_format($row['AgoMz'],2); $porcent = (100 * $row['AgoMz'])/$row2['MZ_MONTO']; $porcent = number_format($porcent, 2); $i = $i + 1; echo "". "". "". "". "". ""; } sqlsrv_free_stmt($result); sqlsrv_free_stmt($result2); sqlsrv_close($con_comercial); ?>
No Cliente Monto Porcentaje
".$row2['MZ_CTS']."Total$".$total_MONTO."".(100 * $row2['MZ_MONTO'])/$row2['MZ_MONTO']." %
".$i."".$row["Cliente"]."".$monto."".$porcent." %