phillip.howcroft

I want to take a decimal which has been summed in by a variable to XXX.xx and convert it to YYY:yy where the yy is mins I can do this in SQL using TRUNC(Summary.Actual_Hrs) || ':' || SUBSTR (('00' || TRUNC(((Summary.Actual_Hrs) - TRUNC(Summary.Actual_Hrs))*60)), -2) AS Actual_Hrs but i dont know how to do this in jaspersoft studio (5.6) using expressions. I've trawled here and Google but it only gives references to time in dates not a summing of hours and minutes. Can anyone point me in the right direction Thanks

I have been experiencing similar problem but the other way round. upload with a datasource then amend the report in studio, go back to republish it and null point error. However republish without the datasource works ok. Now we just go on the reports properties and overwrite from workspace its easier than trying to work out what's going on - and no one from Jaspersoft ever replies to the problems listed in this site anyway.

apart from this link http://community.jaspersoft.com/questions/827949/merging-columns-table-jaspersoft-studio-552 has anyone else noticed other problems between 5.5 and 5.6. The table thing is annoying as its effectively stopped me using them now so i'm doing it the long way round with sections in the report. I have tried the bug report section withing japserreports and guess what - that doesnt work either. I donrt have a support package with jaspersoft so i cant see what other bugs have been reported up and solutions if any.

couldnt you place each table in its own details section and then set the section to hide when no data?

when installing japser report server 5.6 it fails on; Error running initdb.exe -U postgres -E UTF8 -D. after trawling throuh google I have found several references to this failure; * 24762: (fixed) Under certain circumstances when installing on a Windows 7 system, the installer failed with an error in initdb.exe. The root of the problem, which originates in a problem between Microsoft Windows and PostgreSQL, is the use of a symbolic link in the path to the installation directory. Jaspersoft has implemented a new feature that prevents this failure.[/code]seems its not so fixed as you claim

I am having the same problem which also extends to other report writers being unable to amend reports writen by others as JS overwrites the report on upload. I have received the following workaround, not tried it though; Assuming that the Jasper repository is in an Oracle database (as opposed to postgreSQL), a workaround is to delete all rows from the 'jiaccessevent' table prior to importing the reports. We ran into this issue a couple weeks back when we were troubleshooting the LRP report issue with BAE. The way we worked around it then was to reload the Japser repository completely... but obviously that's not ideal. Deleting from the 'jiaccessevent' table is less intrusive. From what I've been able to figure out, this is just an auditing table that sits between the user table, and the 'jiresource' table. From what I can tell is it just keeps track of who viewed/touched what report, and when