>>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

Reply via email to