1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
| Dim Rst As DAO.Recordset, cadena As String
Dim stsql As String, Status As String, total As String
Dim uno As Integer, rutaarchivo As String
rutaarchivo = CurrentProject.Path & "\Recursos\charts\ampie\ampie3\ampie_data.xml"
uno = FreeFile
Open rutaarchivo For Output As #uno
cadena = "<?xml version='1.0' encoding='UTF-8'?>"
Print #uno, cadena
cadena = "<pie>"
Print #uno, cadena
stsql = "select * from sql_calendarStatusCount Order By title"
Set Rst = CurrentDb.OpenRecordset(stsql)
If Rst.EOF = False Then 'Si el recordset devuelve registros ==>
Rst.MoveLast
Rst.MoveFirst
Do Until Rst.EOF
Status = Rst!title
total = Rst!total
cadena = "<slice title=""" & Status & """" & " " & "pull_out=""true"">" & total & "</slice>"
Print #uno, cadena
Rst.MoveNext
Loop
End If
Rst.Close
Set Rst = Nothing
cadena = "</pie>"
Print #uno, cadena
Close #uno |
Partager