Trial Version for PHP crippled?

tony.tomov · Post by **tony.tomov** » Wed Oct 27, 2010 4:18 pm

Hello,
Sorry to say, but the functions does not do what they should do.
Simple I have defined - Report Title, Group Header, Data, Group Footer and Report Summary Bands.

I have placed a sum function in Group Footer Band. The field is defined in MySQL as decimal(10,4) - The result of this is NaN

Moreover another bug - I have placed the sum function on Report Summary Band - the band does not show any information at all

Regards

fox_224 · Post by **fox_224** » Wed Oct 27, 2010 11:23 pm

Hi Vladimir,
I downloaded latest build and tested it on a mysql table with three records. The column to be totaled has the following values: 3, 2, 9.
Using this syntax for the totals: {Sum(Datasource1.Column_Name)} the result came up as 329 (??) but should be 14 so what is happening man??

Regards

tony.tomov · Post by **tony.tomov** » Thu Oct 28, 2010 3:26 am

Hello,
I confirm what fox_224 say. The field is defined as integer and the function concat the data instead of suming it.
On big integer numbers like 10234,10345, 34987,10456,10345 - I get overflow error ?!?

Regards

Vladimir · Post by **Vladimir** » Thu Oct 28, 2010 5:27 am

Hello,

We confirmed this issue, we will try to resolve it as soon as possible.

Thank you.

tony.tomov · Post by **tony.tomov** » Thu Oct 28, 2010 7:32 am

Hello,
Thanks.
Please do not forget disappearing of the Report Summary band.

Regards

Tony

Vladimir · Post by **Vladimir** » Tue Nov 02, 2010 2:05 am

Hello,

The error with Seport Summary Band is fixed, update will be available in the prerelease build on November, 2.

Thank you.

fox_224 · Post by **fox_224** » Tue Nov 02, 2010 6:37 pm

Hi Vladimir,
Thank you for the new updates. Totals (Sum function) is working now. I tested other functions - Avg function works but Min and Max and Mode does not seem to work.
For the time being this version is enough for us to continue our evaluation.
Just a quick question, is there any formatting functions available? Like if I want to print 1253.55 as $1,253.55 ?
Thanks again for the update.

Vladimir · Post by **Vladimir** » Wed Nov 03, 2010 1:38 am

Hello,

Unfortunately, the text formatting is still in development. We plan to implement this feature in this month.

Thank you.

fox_224 · Post by **fox_224** » Mon Nov 08, 2010 6:52 pm

Hi Vladimir or Andrew,
Another problem with Totals function:
I have a column with following values: 2579.35 , 5457.22 and 123.45. The total comes up as 8160.019999999999. I tried to put the Round() function in the total expression but it does not work and comes up as blank.
Please look into this as tonyt pointed out above, these are very basic requirement in reports.
Regards,

Vladimir · Post by **Vladimir** » Tue Nov 09, 2010 1:20 am

Hello,

All mathematical functions, including the Round() function, will be available in today's prerelease build from November, 9. Also, we will try to solve the issue with rounding results.

Thank you.