>>select [Phone Number] from [other clients details] select `Phone Number` from `other clients details`;
On 30 October 2014 05:19, Lajeo Gloria <[email protected]> wrote: > Hi All, > Can anyone please help me solve this small issue. i want to subtract two > numerica fields value in Pentaho Report. But i don't how to do this. I have > this fields for sumDeposits and sumWithdrawals so i want to get the balance > as at present by subtracting sumWithdrawals from sumDeposits but i don't > know how to do that and where exactly to do it( this function and its > syntax). I was thinking of using a message field to write the function in > and also to display result. > > And what will be the alias for a database table "other clients details" > with spaces and how to query from a table with spaces in the name and also > column name with spaces? > i was using e.g {select [Phone Number] from [other clients details]} but > it throws errors. > > Thanks > Regards > Gloria > > > ------------------------------------------------------------------------------ > > Mifos-developer mailing list > [email protected] > Unsubscribe or change settings at: > https://lists.sourceforge.net/lists/listinfo/mifos-developer >
------------------------------------------------------------------------------
_______________________________________________ Mifos-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mifos-users
