peter.w

I am not a network specialist. You need to be sure that the domain account you are using has SQL access and that your SQL host machine is a member of the domain. Don't create a local account with the same name as the domain account. (You will then have two seperate user accounts) AFAIK for production systems You dont want to add the SQL user account to the to the local administrators as this would also grant all administrator privileges in addition to granting SQL access. You also dont want to add the domain account to SQL "sysadmin" as that would grant all SQL to the domain user. Ideally you want a "jasper reports user" with role level access.

Hi Can you not connect Jasper Studio to your server ? You should be able to use the "Repository explorer" in jasper studio to connect to your jasper reports server and then access the reports from there. From my past attempts at copying directly fron the database, I think the reports are in the jirepositorycache table and are stored as binary data. When I tried exporting and importing the binary data from an older version of jasper server to a new version of jasper server it failed. You may try with differnet database export formats and get lucky . If you do please post how you did it.

The way I did it was I used jasper studio to set up ready made reports. The reports need to have parameters to run EG a user id and a start and an end date. I then put the reports on the jasper server. Then I build the rest calls to the jasper server in my java application. and I connect to the jasper server using rest calls. You will need to set things in the application like the jasper server URL a jasper username and password a path to report on the jasper server the report format you need eg: "PDF" And in my case the user id and start and end dates. The best guide would be the "TIBCO JasperReports Server REST API Reference"

I had the same problem as Andrew on a windows install. IE org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'keystoreManager': with a final message starting; Caused by: org.apache.commons.configuration2.ex.ConfigurationException: Could not locate: org.apache.commons.configuration2.io.FileLocator@29942be5[ fileName=.jrsksp My fix was as follows: In the windows control panel under: Control PanelSystem and SecuritySystem you need to go too; Advanced system settings Then to the “Environment variables” button and under the System variables you need to add two new variables KS and KSP with the value C:UsersPublic EG: KS = C:UsersPublic KSP = C:UsersPublic Then move or copy Copy .jrsks (Java keystore) and .jrsksp (keystore properties) files from C:Users<myusername> to C:UsersPublic Files in C:UsersPublic automatically have the groups BATCH INTERACTIVE and SERVICE added to them.

Hi Not sure if I understand fully what you are trying to do but.. Is there a reason why you cannot create the AccountPremium as an integer at the start eg: ? <variable name="ACCOUNT_PREMIUM" class="java.lang.Integer"/>[/code] or as an input field <field name="ACCOUNT_PREMIUM" class="java.lang.Integer"/>[/code]Personally I use class="java.math.BigDecimal" for currency eg: <field name="ACCOUNT_PREMIUM" class="java.math.BigDecimal"/>[/code]Then the average would be calculated something like this. <variable name="AVE_ACCOUNT_PREMIUM" class="java.lang.Integer" incrementType="Report" calculation="Average"> <variableExpression><![CDATA[$F{ACCOUNT_PREMIUM}]]></variableExpression> <initialValueExpression><![CDATA[$F{ACCOUNT_PREMIUM}]]></initialValueExpression></variable>[/code]

Hi Not sure if you know about this or if it helps or not but I have used a font from here. http://www.unifont.org/fontguide/

OK that did not look like that when I previewed it

Hi I am not sure if this is relevant or not but I had a similar issue but with shared images. For some reason the images were removed from the base "ROLE_USER" user role so although the user was part of that role, the role itself did not have permission to access the images. ( actually only the administrator had access.)

Hi It would help to know what OS Server versions etc you are using? Here are a few things to look at that might be causing the issue you are having : The height of text field element and the font. : Is the font you are using on the problem server or is it being substituted? : What document format are you producing? If it is MS Word doc you need to be aware that Word will "reformat" some documents when you open them. Hope this give some ideas.

Can we assume that the "user" running the jasper server has permission to read and write to the /target folder? Regards Peter

Hi Is it only the jasper server you updated or did you update the database and jdk as well? Try an empty report. That is one without calls to a database. If you changed the JDK you may need new database drivers. If you changed the database test any SQL seperately. Hope this helps

If the standard format pattern for currency (i.e. "¤#,##0.##;¤-#,##0.##" ) does not work you. You can go down the route of putting the information in the database and then extract it and send it to the report as a parameter. You would then have something like this in the textfield of your report. CONCATENATE( $P{Currency_Symbol}, " ",TEXT( $F{CASH_SALES},$P{Currency_Format})," ") where Currency_Symbol = "£" and Currency_Format = "#,##0.##;-#,##0.##"

Do you know if the subreport detail band being called? Does the main report have a datasoucre that returns something if not you need to just attach it to any datasource and use something like "SELECT 1 as dummy" in your report query.

Hi When you say incrementer factory class name = blank, I assume you mean it is blank in the Jasper studio. Check in the source of the report is there an empty string. EG somthing like this: <subreport> <returnValue incrementerFactoryClass=""/> </subreport> If there is delete the entire incrementerFactoryClass="" element Also check that the value you are assigning back is a system not no calculation function. calculation = System

If the reports are called from the web it is probably via a rest call to the report location. So you will need to add your report to the same folder on the server. Usually via jasperadmin login on the jasper server. If the web-app is set up correctly adding the report in the correct folder will add it to a list available in the web-app and you will not have to do anything else. If not....(ouch) You will need the web server url and port, the user with the permissions to the folder where the report is. You will need to determine the output type in the rest call in the app.