Hi Santosh,


I have noticed that the select concat queries that run in stretchy reports and 
pentaho do not run in the database directly. They produce errors there. All the 
queries in the pentaho reports in Mifos perform the same way.



I have a simulation attached for active client loans as at a date report that 
you can test attached for inclusion into fineract.



I have more if you would like to test and include, if you’re interested.



Kind regards,



Sifiso





From: Santosh Math <[email protected]>
Sent: Saturday, June 23, 2018 2:49 AM
To: mifos-users <[email protected]>
Cc: Mifos software development <[email protected]>; Dev 
<[email protected]>
Subject: Re: [Mifos-users] hi , i have created the DayBook report, Active 
clients on date report and also Demand sheet for for JLG loans .



Hi Ramesh,



Could u share the query which I can run in my database?



Thanks

Santosh



On Fri 22 Jun, 2018, 11:42 PM Ramesh Ram, <[email protected] 
<mailto:[email protected]> > wrote:

Hi santhosh..,



We have modified the database for our business model. So it didn't run in demo 
site.,but you can alter the query  for your database.. Some tables are  
varried..but rule is same. Kindly you review your database.



Thanks.,

Ramesh



On Fri 22 Jun, 2018, 6:44 PM Santosh Math, <[email protected] 
<mailto:[email protected]> > wrote:

Hi Ramesh,



I need to test your following reports on https://demo.openmf.org ( I created 
stretchy reports  with same name). However, after running the reports , I am 
not getting any output.





1) Active Query

2) Demand Sheet Query

3) DailySheet query.



Could you check there?



Thanks

Santosh



On Fri, Jun 22, 2018 at 12:21 PM, Ramesh Ram <[email protected] 
<mailto:[email protected]> > wrote:

ok Abiy



On Fri, Jun 22, 2018 at 6:06 AM, Abiy Atsbha <[email protected] 
<mailto:[email protected]> > wrote:

I will skype you Ramesh.



On Fri, Jun 22, 2018 at 9:33 AM Ramesh Ram <[email protected] 
<mailto:[email protected]> > wrote:

Hi Abiy,
I can't  understand  this concept., Do you want to create a new report or 
Implement the  these report., Please elobarate this .

Thanks,

Ramesh



On Thu, Jun 21, 2018 at 1:00 PM, Abiy Atsbha <[email protected] 
<mailto:[email protected]> > wrote:

Corrected Mail,



Dear Ramesh,



Hey bro, I am glad you are doing this.
And Since Ed, wants to review this and add it to standard Mifos X report, I 
have BROUGHT you sample DAILY TRANSACTION LIST report of T24-Temenos Banking 
Software, this report was not shipped with it originally, it was locally 
developed. It records all the daily transactions including Accounts, Funds 
Transfers, Teller Transactions, Loan, Deposits & Pastdue Loans. All 
transactions that have effect on the accounting are recorded inside this report.


I am attaching this report with this mail, so as to help you in designing the 
report layout and its inside components.

Good Luck bro.

Abiy A.





On Thu, Jun 21, 2018 at 11:38 AM Ramesh Ram <[email protected] 
<mailto:[email protected]> > wrote:


I am  glad to on work with you on this process, please let me know the timings 
for our discussions

Thank you,
Ramesh



On Wed, Jun 20, 2018 at 3:41 AM, Ed Cable <[email protected] 
<mailto:[email protected]> > wrote:

Can we work on reviewing this and potentially adding as another standard report 
in Mifos X?


Thanks,


Ed



On Sat, Jun 16, 2018 at 8:12 PM solomon anaman <[email protected] 
<mailto:[email protected]> > wrote:

Hello can you please help me with a report on transactions by a cashiers where 
each cahiers report will be pulled separately?

Thank you



On Mon, Apr 30, 2018 at 11:16 AM, Ramesh Ram <[email protected] 
<mailto:[email protected]> > wrote:

im happy for your reply. please askme if you have any doubts. i also  have  
code for group find group status  which is renewal or new group.



On Mon, Apr 30, 2018 at 6:00 PM, Abiy Atsbha <[email protected] 
<mailto:[email protected]> > wrote:

Dear Ramosh,



That is very helpful. I will use it for my production.



Thanks & Regards,

Abiy A.

Ethiotechs Innovative Solutions



On Mon, Apr 30, 2018 at 2:59 PM, Ramesh Ram <[email protected] 
<mailto:[email protected]> > wrote:

I have use the mifosx application for jlg loans.  so these reports are very 
help full for daily activities.So i'm sharing these  code .if you need this you 
will use it.



Thank you.


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Mifos-users mailing list
[email protected] <mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/mifos-users




------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Mifos-users mailing list
[email protected] <mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/mifos-users




------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Mifos-users mailing list
[email protected] <mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/mifos-users



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! 
http://sdm.link/slashdot_______________________________________________
Mifos-users mailing list
[email protected] <mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/mifos-users






--

Ed Cable

President/CEO, Mifos Initiative

[email protected] <mailto:[email protected]>  | Skype: edcable | Mobile: 
+1.484.477.8649



Collectively Creating a World of 3 Billion Maries | http://mifos.org  
<http://facebook.com/mifos>   <http://www.twitter.com/mifos>




------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Mifos-users mailing list
[email protected] <mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/mifos-users



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! 
http://sdm.link/slashdot_______________________________________________
Mifos-users mailing list
[email protected] <mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/mifos-users


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Mifos-users mailing list
[email protected] <mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/mifos-users



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! 
http://sdm.link/slashdot_______________________________________________
Mifos-users mailing list
[email protected] <mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/mifos-users


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Mifos-users mailing list
[email protected] <mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/mifos-users




------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Mifos-users mailing list
[email protected] <mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/mifos-users







--

Thanks & Regards

Santosh Math

QA Engineer

 <http://www.confluxtechnologies.com/> Conflux Technologies Pvt Ltd

| Office: +91-080-41208662 |

Address: #304, 2nd Floor, 7th Main Road, HRBR Layout 1st Block, Bengaluru, 
Karnataka, 560043 INDIA

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! 
http://sdm.link/slashdot_______________________________________________
Mifos-users mailing list
[email protected] <mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/mifos-users

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! 
http://sdm.link/slashdot_______________________________________________
Mifos-users mailing list
[email protected] <mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/mifos-users



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

Attachment: client loan report.sql
Description: Binary data

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users

Reply via email to