Hello,

I have had some experience with Pentaho Reporting, so let me give you a
brief tutorial.

FIrst when you open up the designer, you have to add Data Source. Click
Data, Add Data Source, JDBC.

Choose the type of your DataSource and click on the pencil icon above to
Edit it. After entering the details, you can click Test to see if it really
connects to the Database.

Then on the right click the Add Query button ( a green + ), choose the
query and write your SQL syntax on the bottom. ( You can click Preview to
see what the query will return ).

Then Click OK, and on the right side of the designer on the Data Tab you
will see that your query was added to Data Sets. In that query are the
fields that the query returned, and you can work with them.

Now on to your question about formulas.

In the Data tab on the right, right click on Functions, Add Functions.
Choose Common, Open Formula. Press OK. A new Formula will be added.
Function name field is the name of the formula. The Formula field is the
formula itself.

In this field,write =[yourField1]-[yourField2] and press enter. Then just
drag the formula on the designer and it will display the formula as the
usual fields.

See this for more information.

http://wiki.pentaho.com/display/Reporting/Formula+Expressions

Best Regards,

Tengiz Merabishvili

FINA Ltd |   ORACLE   Gold Partner

On Thu, Oct 30, 2014 at 3:49 AM, 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