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: > Another trick is to download the HT

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 be downloaded as PDF or

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, m

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. > > > [image: Inline imag

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 word or excel? > >

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 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 > dimensions disappe

Re: [Dhis2-devs] Pivot tables

2010-10-27 Thread Bob Jolliffe
2010/10/27 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 I'm a bit confused. The 'command" tex

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 a

Re: [Dhis2-devs] Pivot tables

2010-10-26 Thread Bob Jolliffe
Attached is a simple skeleton overview diagram of how it *can* be done. I'm not sure if I'm 100% comfortable with the approach yet but I can verify that it works (caveat below). >From the diagram, the point ultimately is to populate the pivottablecache of the pivottable within the local excel spr

Re: [Dhis2-devs] Pivot tables

2010-10-26 Thread Lars Helge Øverland
2010/10/25 Bob Jolliffe > 2010/10/25 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 l

Re: [Dhis2-devs] Pivot tables

2010-10-25 Thread Bob Jolliffe
2010/10/25 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 need

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 p

Re: [Dhis2-devs] Pivot tables

2010-10-24 Thread Bob Jolliffe
2010/10/22 Lars Helge Øverland : > > > On Fri, Oct 22, 2010 at 2:32 PM, Bob Jolliffe wrote: >> >> hi >> >> 2010/10/22 Ola Hodne Titlestad : >> > 2010/10/22 Lars Helge Øverland >> >> >> >> Hi Bob >> >> Sorry for not returning to this earlier, been battling with windows 64 >> >> bit >> >> odbc driv

Re: [Dhis2-devs] Pivot tables

2010-10-22 Thread Lars Helge Øverland
On Fri, Oct 22, 2010 at 2:32 PM, Bob Jolliffe wrote: > hi > > 2010/10/22 Ola Hodne Titlestad : > > 2010/10/22 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 > >>> > >>> H

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 org.hi

Re: [Dhis2-devs] Pivot tables

2010-10-22 Thread Bob Jolliffe
hi 2010/10/22 Ola Hodne Titlestad : > 2010/10/22 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 >>> >>> Hi Lars, Ola and all >>> >>> Thinking about exporting pivot tables .. we need to

Re: [Dhis2-devs] Pivot tables

2010-10-22 Thread Ola Hodne Titlestad
2010/10/22 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 > > Hi Lars, Ola and all >> >> Thinking about exporting pivot tables .. we need to pen up some >> requirements which we can get int

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 > 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,