thanks Ryan,
I have Eclipse Galilio with Birt 2.5.1. (2009 ) version. This should do
I guess, I will download 2.5.2 all the same and try it out.
Ryan Whitney wrote:
Gayl, no -- it doesn't matter what area the GL report is uploaded
under. Categories are just for sorting reports and setting permissions.
Kelechi, ok, that helps in narrowing down the issue. Next area I
would look at is trying to run it in the BIRT Report Designer, and see
if you can see any errors popping up. Might also try looking in the
logs. You can download here:
http://download.eclipse.org/birt/downloads/index2.5.2.php (you want
the RCP Designer)**
Ryan
** Note: We are running 2.5.1 in mifos. I have seen that BIRT isn't
great with different versions, but I'm hoping 2.5.2 will be fine. I
couldn't find a download link for 2.5.1.
On 9/7/10 1:36, "kelechi Micheals" <[email protected]> wrote:
hi Ryan,
I ran the query against the database and it came up with results.
however, with the report it gives blank.
Gayl Kennedy wrote:
Hi Ryan
does it matter what area of reports the new version of the GL
report
was added to in mifos as we added it under performance and it was
originally under analysis. Would it be something simple like
that? We
definitely have transactions in that date period in my test
branch and
we entered the date format correctly.
I need Kelechi to run the report against the db so thanks for
sending it on.
On 06/09/2010, Ryan Whitney <[email protected]>
<mailto:[email protected]> wrote:
Gayl,
The GL report does not depend on the batch jobs. That
shouldn't be the
issue. Double check that you have entered transactions
for the branch in
question between your selected dates, and that you are
entering the dates in
correctly.
Also, you can try running the query directly against your
database to double
check as well:
SELECT financial_trxn.posted_date,
gl_code.glcode_value,
SUM(IF(debit_credit_flag = 0, ABS(posted_amount),
0.000)) AS debit,
SUM(IF(debit_credit_flag = 1,
ABS(posted_amount),0.000)) AS credit
FROM financial_trxn
INNER JOIN gl_code USING (glcode_id)
INNER JOIN account_trxn ON account_trxn.account_trxn_id =
financial_trxn.account_trxn_id
INNER JOIN account ON account.account_id =
account_trxn.account_id
WHERE account.OFFICE_ID = ?
AND financial_trxn.posted_date >= ?
AND financial_trxn.posted_date <= ?
GROUP BY posted_date, glcode_value
ORDER BY posted_date, glcode_value
This appears to run fine on demo.mifos.org.
Ryan
On 9/6/10 20:08, "Gayl Kennedy" <[email protected]>
<mailto:[email protected]> wrote:
Hi Jeff
thanks for the new version. The fix to the GL report
is now allowing
us to select branch and date but no data is showing so
need to check
batch jobs etc.
We still have the issue with the branch progress
report originally
referenced on this thread.
Regards
Gayl
On 06/09/2010, Jeff Brewster
<[email protected]>
<mailto:[email protected]> wrote:
Hi Jeff,
If I use your modified GL report, it works !! :-)
Good to know Binny. Are you having any issues with
the other reports at
this point?
Jeff
----------------------------------------------------------------------------->>
-
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
--
Ryan Whitney
Mifos Technical Program Manager
[email protected]
Mifos - Technology that Empowers Microfinance
(www.mifos.org <http://www.mifos.org> )
Our mission is to enable the poor, especially the poorest,
to create a world
without poverty.
<http://grameenfoundation.org/take-action/ingenuity-fund-challenge/>
P please consider the environment before printing this e-mail.
------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
------------------------------------------------------------------------
------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
------------------------------------------------------------------------
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
--
*Ryan Whitney **
*/Mifos Technical Program Manager
/[email protected]_
Mifos - Technology that Empowers Microfinance (www.mifos.org)
/Our mission is to enable the poor, especially the poorest, to create
a world without poverty.
</_http://grameenfoundation.org/take-action/ingenuity-fund-challenge/_>
P please consider the environment before printing this e-mail.
------------------------------------------------------------------------
------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
------------------------------------------------------------------------
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
