dhis2-users team mailing list archive

[Alex Tumwesigye <atumwesigye@xxxxxxxxx>]

Hi Moses,

See this link. It is possible to do multiple queries within ireport using
sub datasets and tables.

http://www.oodlestechnologies.com/blogs/Using-Jasper-Reports-Part-3-(Datasets--and-Table-component-in-Jasper-Reports)
.

Good luck.

Alex

On Thu, Nov 27, 2014 at 10:38 AM, Moses Marimo <marimo@xxxxxxxxx> wrote:

> Hey apologies. I just send an email from a colleague's computer. Anyway, a
> bit of more information. I need all columns to be in the detail section. I
> could used sub totals to get the total for the three months but them, the
> design of the report becomes distorted. Is this practical????
>
> On Thu, Nov 27, 2014 at 9:28 AM, Morina Matasi <morena.motsieng@xxxxxxxxx>
> wrote:
>
>> I have a unique scenario here. I have a report which is supposed to list
>> monthly data BUT one of the columns will be a percentage of the quarterly
>> figures.
>>
>> See Below sample data
>>
>>
>>                                         ANC Visits
>> Percentage of Quarter
>> Facility 1     January          100
>> 100/(100+150+123)
>> Facility 1     February         150
>> 150/(100+150+123)
>> Facility 1     March              123
>> 123/(100+150+123)
>> Facility 2     January          112
>> 112/(112+156+145)
>> Facility 2     February         156
>> 156/(112+156+145)
>> Facility 2     March              145
>> 145/(112+156+145)
>> ....
>> ....
>> ....
>> Facility N
>>
>>
>> From the above data, column Percentage of Quarter should use data from
>> the other three columns (January+February+March) and I guest I need a
>> sub-query for this. How do I go about this.
>>
>>
>> Regards,
>>
>> Moses Marimo
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> ICT Warehouse (Pvt) Ltd - "The Stockist of *e*-nnovation"
> 7 Chelmsford Belgravia, Harare
> Tel: +263-8644-102349
> Cell: +263-772-268353
> Website: *www.ict.co.zw <http://www.ict.co.zw>*
>
>
> Innovative solutions in Web Design and E-Commerce, Software Engineering,
> Mobile and Bulk SMS Solutions, Graphic Design and Printing, General ICT
> Solutions and Consultancy.
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Alex Tumwesigye

Technical Advisor - DHIS2,
Ministry of Health/AFENET
Kampala
Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems -
DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don't want to be anything other than what I have been - one tree hill "