Kelechi,
Yeah, that should work just fine and I would stick with that since its the
right version. The RDP is just easier as its an all in one package.
Ryan
On 9/7/10 15:27, "kelechi Micheals" <[email protected]> wrote:
> 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:
>> Re: [Mifos-users] Branch progress report and GL report problems 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> <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
>> <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
