[Kmymoney] Select transactions in a report by security

[Volker Paul]

On Monday, November 05, 2012 01:28:49 Jack wrote:
> On 2012.11.04 17:55, David Houlden wrote:
> > On Sunday 04 November 2012 21:28:53 Volker Paul wrote:
> >>> The first thing I would do is to upgrade.  1.0.4 is very old.  The
> >>> latest released version is 4.6.3.
> >>> 
> >>> I only have one other suggestion right now (I don't have access to
> >>> KMM, so this is from memory.)  There is a configuration setting to
> >>> list each security.  If you turn that on, then the security might
> >>> be listed in the list of accounts when you configure the report.
> >>> 
> > > On a different computer I have 4.6.1 but found no solution either.
> > 
> > Not sure if it was in 4.6.1 but the setting you want is "Show equity
> > accounts" under General on the Filter tab. That enables me to select
> > individual securities on the reports.
> 
> That's the one I was thinking about.  Thanks for the exact name.
> 
> >> But it seems KMyMoney can use an SQL DB. Would that be a solution?
> >> I'm quite familiar with SQL (PostgreSQL). Can SQL expressions be
> >> used for reporting?
> 
> If you are really good with SQL, I'm sure you could figure out an
> appropriate query directly against the database to extract the data you
> want, but that's not really a report, and I don't think there is any
> way to combine that with the actual KMM reports.
Thanks for the advice. I think I'll try an SQL-based reporting tool.

Regards,

Volker Paul