[Dhis2-devs] Pivot Tables (ReportTable) to Standard Report HTML report format

2015-09-04 Thread moses mwale
Hello All, am keenly interested to learn how to convert Pivot Tables (ReportTable) to Standard Report HTML report format. I know how to do that from event report to standard report html report format, How can I arrange indicators, period which are connected to 2 Organization Units? Am used to the

Re: [Dhis2-devs] Pivot tables or event reports

2015-09-02 Thread Lars Helge Øverland
Hi Moses, you can download pivot tables as Excel from the Download top menu item. [image: Inline image 1] regards, Lars On Tue, Sep 1, 2015 at 1:14 PM, moses mwale wrote: > Hello, is it possible that fact sheets (Pivot tables or event reports) can > be converted into

Re: [Dhis2-devs] Pivot tables or event reports

2015-09-02 Thread Jan Henrik Øverland
If you are using Google Chrome you can even just select the html of the table in the browser by pressing Ctrl + a, then copy it (Ctrl + c) and paste it directly in Word. This works in e.g. Gmail as well. On Wed, Sep 2, 2015 at 2:20 PM, Jason Pickering wrote: >

Re: [Dhis2-devs] Pivot tables or event reports

2015-09-02 Thread moses mwale
How about to word? How about those charts in data visualizer, can they also be downloaded to word or as excel? Thank you for the help On 2 Sep 2015 09:25, "Lars Helge Øverland" wrote: > Hi Moses, > > you can download pivot tables as Excel from the Download top menu item. > >

Re: [Dhis2-devs] Pivot tables or event reports

2015-09-02 Thread Jason Pickering
Another trick is to download the HTML and the copy and paste into Word for the tables. You can also save the HTML file and open this file with word and make further edits. Regards, Jason On Wed, Sep 2, 2015 at 2:14 PM, Ali Karisa wrote: > Hello Moses, > > The charts can

Re: [Dhis2-devs] Pivot tables or event reports

2015-09-02 Thread Ali Karisa
Hello Moses, The charts can be downloaded as PDF or images; the latter can be pasted into a word document quite easily. The source data of these, however, can still be downloaded to excel with the process Lars described earlier on this email thread. Thanks, Ali On Wed, Sep 2, 2015 at 2:36 PM,

[Dhis2-devs] Pivot tables or event reports

2015-09-01 Thread moses mwale
Hello, is it possible that fact sheets (Pivot tables or event reports) can be converted into word or excel? ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs

[Dhis2-devs] Pivot tables: custom dimensions disappear when searching indicators

2015-06-18 Thread Victor Garcia
Hi all, we have found an issue in pivot tables and visualizer. When searching for an indicator using the search bar, the content of custom dimensions disappears. This issue can be easily replicated in demo server: - In pivot tables, search for an indicator (for example, write ANC in the search

Re: [Dhis2-devs] Pivot tables: custom dimensions disappear when searching indicators

2015-06-18 Thread Jan Henrik Øverland
Hi Victor, Fixed in all affected versions now. Thanks for reporting. Jan On Thu, Jun 18, 2015 at 9:41 AM, Victor Garcia vgarcia...@gmail.com wrote: Hi all, we have found an issue in pivot tables and visualizer. When searching for an indicator using the search bar, the content of custom

[Dhis2-devs] Pivot tables not loading

2013-11-13 Thread Prosper BT
Dear Developers, we are Version:2.14-SNAPSHOTBuild revision:12938Build date:2013-11-14 02:02 But the Pivot tables are not loading, what could be the problem Our IT guys has these errors identified Uncaught TypeError: Cannot read property 'length' of undefined in core.js Line 2421 There is a

Re: [Dhis2-devs] Pivot tables

2010-10-27 Thread Ola Hodne Titlestad
Yes, I casted the Value field to number using the val() function, val(Value). I modified the Query used by the pivot table in: Pivot Tables top menu-Change Data Source-Connection Properties-Definition-Command text Not sure where this query is stored as these changes did not show in the .odc

Re: [Dhis2-devs] Pivot tables

2010-10-27 Thread Bob Jolliffe
2010/10/27 Ola Hodne Titlestad ol...@ifi.uio.no: Yes, I casted the Value field to number using the val() function, val(Value). I  modified the Query used by the pivot table in: Pivot Tables top menu-Change Data Source-Connection Properties-Definition-Command text I'm a bit confused. The

Re: [Dhis2-devs] Pivot tables

2010-10-25 Thread Lars Helge Øverland
Hi thanks for the nice update, interesting. The thinking sounds very reasonable to me. Ola and I will work a bit on the optimization of SQL view. One issue here is that when writing generic sql queries for tables like orgunitgroupsetstructure, one needs to select * (all) columns in order to be

Re: [Dhis2-devs] Pivot tables

2010-10-25 Thread Bob Jolliffe
2010/10/25 Lars Helge Øverland larshe...@gmail.com: Hi thanks for the nice update, interesting. The thinking sounds very reasonable to me. Ola and I will work a bit on the optimization of SQL view. One issue here is that when writing generic sql queries for tables like

[Dhis2-devs] Pivot tables

2010-10-22 Thread Bob Jolliffe
Hi Lars, Ola and all Thinking about exporting pivot tables .. we need to pen up some requirements which we can get into a blueprint. While we are considering that, I've given some thoughts below. My initial thought was that we would construct a pivot table with a jdbc connection like we would

Re: [Dhis2-devs] Pivot tables

2010-10-22 Thread Lars Helge Øverland
Hi Bob Sorry for not returning to this earlier, been battling with windows 64 bit odbc drivers. 2010/10/22 Bob Jolliffe bobjolli...@gmail.com Hi Lars, Ola and all Thinking about exporting pivot tables .. we need to pen up some requirements which we can get into a blueprint. While we are

Re: [Dhis2-devs] Pivot tables

2010-10-22 Thread Ola Hodne Titlestad
2010/10/22 Lars Helge Øverland larshe...@gmail.com Hi Bob Sorry for not returning to this earlier, been battling with windows 64 bit odbc drivers. 2010/10/22 Bob Jolliffe bobjolli...@gmail.com Hi Lars, Ola and all Thinking about exporting pivot tables .. we need to pen up some

Re: [Dhis2-devs] Pivot tables

2010-10-22 Thread Bob Jolliffe
hi 2010/10/22 Ola Hodne Titlestad ol...@ifi.uio.no: 2010/10/22 Lars Helge Øverland larshe...@gmail.com Hi Bob Sorry for not returning to this earlier, been battling with windows 64 bit odbc drivers. 2010/10/22 Bob Jolliffe bobjolli...@gmail.com Hi Lars, Ola and all Thinking about

Re: [Dhis2-devs] Pivot tables

2010-10-22 Thread damilola
BODY { font-family:Arial, Helvetica, sans-serif;font-size:12px; }Hi Bob, Export (ALL) failed with the error below. This began on upgrade from previous to dhis2.0.5. org.hibernate.InstantiationException: Cannot instantiate abstract class or interface: org.hisp.dhis.source.Source at

Re: [Dhis2-devs] Pivot tables

2010-10-22 Thread Lars Helge Øverland
On Fri, Oct 22, 2010 at 2:32 PM, Bob Jolliffe bobjolli...@gmail.com wrote: hi 2010/10/22 Ola Hodne Titlestad ol...@ifi.uio.no: 2010/10/22 Lars Helge Øverland larshe...@gmail.com Hi Bob Sorry for not returning to this earlier, been battling with windows 64 bit odbc drivers.