------------------------------------------------------------ revno: 9159 committer: Lars Helge Øverland <[email protected]> branch nick: dhis2 timestamp: Mon 2012-12-03 18:55:53 +0100 message: Added jrxml report on data analysis usage added: resources/jrxml/ resources/jrxml/data_analysis_usage_stats.jrxml
-- lp:dhis2 https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk Your team DHIS 2 developers is subscribed to branch lp:dhis2. To unsubscribe from this branch go to https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription
=== added directory 'resources/jrxml' === added file 'resources/jrxml/data_analysis_usage_stats.jrxml' --- resources/jrxml/data_analysis_usage_stats.jrxml 1970-01-01 00:00:00 +0000 +++ resources/jrxml/data_analysis_usage_stats.jrxml 2012-12-03 17:55:53 +0000 @@ -0,0 +1,214 @@ +<?xml version="1.0" encoding="UTF-8"?> +<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd"; name="report1" pageWidth="792" pageHeight="612" orientation="Landscape" columnWidth="752" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="ce21c66a-4fd0-43ce-963f-b69dd85fd919"> + <property name="ireport.zoom" value="1.3310000000000004"/> + <property name="ireport.x" value="0"/> + <property name="ireport.y" value="0"/> + <queryString> + <![CDATA[select ( + select count(*) from map ) as maps, ( + select count(distinct userid) from map ) as mapusers, ( + select count(*) from chart ) as charts, ( + select count(distinct userid) from chart ) as chartusers, ( + select count(*) from interpretation ) as interpretations, ( + select count(*) from interpretation_comments ) as comments, ( + select count(*) from usersetting where name='dashboardConfig' ) as dashboards, ( + select count(*) from users ) as users, ( + select count(*) from message ) as messages, ( + select count(*) from userinfo + where (introduction is not null + or gender is not null + or nationality is not null + or education is not null + or interests is not null + or languages is not null )) as profiles;]]> + </queryString> + <field name="maps" class="java.lang.Long"/> + <field name="mapusers" class="java.lang.Long"/> + <field name="charts" class="java.lang.Long"/> + <field name="chartusers" class="java.lang.Long"/> + <field name="interpretations" class="java.lang.Long"/> + <field name="comments" class="java.lang.Long"/> + <field name="dashboards" class="java.lang.Long"/> + <field name="users" class="java.lang.Long"/> + <field name="messages" class="java.lang.Long"/> + <field name="profiles" class="java.lang.Long"/> + <background> + <band splitType="Stretch"/> + </background> + <title> + <band height="370" splitType="Stretch"> + <staticText> + <reportElement uuid="20210923-852e-4e3c-9007-b5e26098a416" x="205" y="20" width="319" height="33"/> + <textElement> + <font size="22"/> + </textElement> + <text><![CDATA[Data analysis usage stats]]></text> + </staticText> + <textField> + <reportElement uuid="3d5864c8-72a6-421e-856f-9d8530e69e16" x="393" y="118" width="131" height="20"/> + <textElement> + <font size="11" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[$F{maps}]]></textFieldExpression> + </textField> + <staticText> + <reportElement uuid="6897cf6a-c3ac-49dc-bc01-15d88ddd5010" x="205" y="118" width="188" height="20"/> + <textElement> + <font size="11"/> + </textElement> + <text><![CDATA[Maps]]></text> + </staticText> + <staticText> + <reportElement uuid="14dded0d-bdcd-463b-a7b0-8958dcea40b2" x="205" y="138" width="188" height="20"/> + <textElement> + <font size="11"/> + </textElement> + <text><![CDATA[Map distinct users]]></text> + </staticText> + <staticText> + <reportElement uuid="41e44f66-0fdb-4c85-978b-737cc5f4d5b8" x="205" y="158" width="188" height="20"/> + <textElement> + <font size="11"/> + </textElement> + <text><![CDATA[Charts]]></text> + </staticText> + <staticText> + <reportElement uuid="65c88e84-cc59-4e2f-9635-a0bc110b4380" x="205" y="178" width="188" height="20"/> + <textElement> + <font size="11"/> + </textElement> + <text><![CDATA[Chart distinct users]]></text> + </staticText> + <staticText> + <reportElement uuid="702c1830-259a-4b1a-bc3f-22d4ced65209" x="205" y="198" width="188" height="20"/> + <textElement> + <font size="11"/> + </textElement> + <text><![CDATA[Interpretations]]></text> + </staticText> + <staticText> + <reportElement uuid="ff90bdf5-fffa-4112-a3fc-26dbf63e412d" x="205" y="218" width="188" height="20"/> + <textElement> + <font size="11"/> + </textElement> + <text><![CDATA[Interpretation comments]]></text> + </staticText> + <textField> + <reportElement uuid="586ce00d-696d-4fdf-a0b5-0acccd0cdfda" x="393" y="138" width="131" height="20"/> + <textElement> + <font size="11" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[$F{mapusers}]]></textFieldExpression> + </textField> + <textField> + <reportElement uuid="6dd0a303-48b7-4bbc-9df8-d663dc1a1667" x="393" y="158" width="131" height="20"/> + <textElement> + <font size="11" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[$F{charts}]]></textFieldExpression> + </textField> + <textField> + <reportElement uuid="e0fc648b-eef4-42b0-b856-8be4f7aef4f6" x="393" y="178" width="131" height="20"/> + <textElement> + <font size="11" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[$F{chartusers}]]></textFieldExpression> + </textField> + <textField> + <reportElement uuid="a5eb2f14-6ae9-442a-8737-bfd21c3552ad" x="393" y="198" width="131" height="20"/> + <textElement> + <font size="11" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[$F{interpretations}]]></textFieldExpression> + </textField> + <textField> + <reportElement uuid="939900f9-ed9a-40fa-88a8-e575944a279e" x="393" y="218" width="131" height="20"/> + <textElement> + <font size="11" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[$F{comments}]]></textFieldExpression> + </textField> + <textField> + <reportElement uuid="4f4cbe49-5474-4fce-bf76-88ac27c72f05" x="393" y="279" width="131" height="20"/> + <textElement> + <font size="11" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[$F{users}]]></textFieldExpression> + </textField> + <staticText> + <reportElement uuid="ff90bdf5-fffa-4112-a3fc-26dbf63e412d" x="205" y="279" width="188" height="20"/> + <textElement> + <font size="11"/> + </textElement> + <text><![CDATA[Users total]]></text> + </staticText> + <staticText> + <reportElement uuid="ff90bdf5-fffa-4112-a3fc-26dbf63e412d" x="205" y="238" width="188" height="20"/> + <textElement> + <font size="11"/> + </textElement> + <text><![CDATA[Messages and comments]]></text> + </staticText> + <textField> + <reportElement uuid="74405f58-92f3-4bbc-af17-585b52bd835d" x="393" y="238" width="131" height="20"/> + <textElement> + <font size="11" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[$F{messages}]]></textFieldExpression> + </textField> + <textField> + <reportElement uuid="b86c5db4-009f-4643-b6aa-e009501abeab" x="393" y="258" width="131" height="20"/> + <textElement> + <font size="11" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[$F{dashboards}]]></textFieldExpression> + </textField> + <staticText> + <reportElement uuid="ff90bdf5-fffa-4112-a3fc-26dbf63e412d" x="205" y="258" width="188" height="20"/> + <textElement> + <font size="11"/> + </textElement> + <text><![CDATA[Dashboards set up]]></text> + </staticText> + <textField> + <reportElement uuid="4803d3a3-8fd7-4807-b738-6bb12cea15c9" x="393" y="299" width="131" height="20"/> + <textElement> + <font size="11"/> + </textElement> + <textFieldExpression><![CDATA[$F{profiles}]]></textFieldExpression> + </textField> + <staticText> + <reportElement uuid="ff90bdf5-fffa-4112-a3fc-26dbf63e412d" x="205" y="299" width="188" height="20"/> + <textElement> + <font size="11"/> + </textElement> + <text><![CDATA[User profiles]]></text> + </staticText> + <staticText> + <reportElement uuid="20210923-852e-4e3c-9007-b5e26098a416" x="205" y="60" width="319" height="33"/> + <textElement> + <font size="14"/> + </textElement> + <text><![CDATA[(Saved favorites by type)]]></text> + </staticText> + </band> + </title> + <pageHeader> + <band height="19" splitType="Stretch"/> + </pageHeader> + <columnHeader> + <band height="21" splitType="Stretch"/> + </columnHeader> + <detail> + <band height="13" splitType="Stretch"/> + </detail> + <columnFooter> + <band height="14" splitType="Stretch"/> + </columnFooter> + <pageFooter> + <band height="14" splitType="Stretch"/> + </pageFooter> + <summary> + <band height="16" splitType="Stretch"/> + </summary> +</jasperReport>
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
