g.denyer

I develop and test reports using a MySQL database which I publish to my JasperServer which has a datasource setup to point to the MySQL database. Some of my clients use a SQL Server database with exactly the same structure and have a datasource with the same name setup, but using a SQL Server JDBC driver. Whenever I export the reports out of my server all of the datasource details is included even though I have unticked 'Data Souces' in the 'Resources to Export' section, so when the client imports them then thir SQL Server driver is swapped to the MySQL driver. Is there anyway the reports can reference the data source by name but NOT export the full data source details? Thanks.

I'm intending to create a class that extends java.util.resourceBundle which will use Google translate to convert text into various languages (and also save the translation to file for future reference). I already have a library contained in a single JAR file used for some additional formating, which already works, so I have added the bare bones of an extended resourceBundle to this. My problem is that when I run the report I keep getting MissingResourceExceptions : Can't find bundle for base name etc. etc. etc In JasperSoft Studio in the reports resource bundle setting I have put my class name in (i.e. myTranslator) but I read it needed the fully qualified name so I have also put 'com.companyName.myLibrary.myTranslator' but still it is throwing up the same exception. I noticed that nothing appears in the open resource lookup, am I missing something to get my resourceBundle class to appear here? What am I doing wrong? Please note, whilst I've been a developer for many years Java is definitely NOT my first language, I only know enough to make me dangerous! Many thanks in advance.

When I view it in Studio in html format then the report is *not* aligned, however if I export from Studio into html then it *is* aligned perfectly. When I export from Server indo PDF is is also aligned perfectly.

I have a detail band together with two groups, the detail contains 5 numbers formatted as strings (using an external library I have written), the group totals of these numbers are also in the footers of both groups. All fields in the footers are vertically alligned with their respective fields in the detail band. All fields are right aligned. When I preview the report in Jaspersoft Studio it all looks correct but when I publish it to the server the footer records creep to the left (in fact the fields on the left hand side are more out of alignment than those on the right). Like this: 1.000 2.000 3.000 4.000 5.000 <- Detail Band 1.000 2.000 3.000 4.000 5.000 <- Inner Group Footer Band 1.000 2.000 3.000 4.000 5.000 <- Outer Group Footer Band If I left align all the fields then the left column lines up but the second column is out of alignment (the alignment improves for subsequent data fields). 1.000 2.000 3.000 4.000 5.000 <- Detail Band 1.000 2.000 3.000 4.000 5.000 <- Inner Group Footer Band 1.000 2.000 3.000 4.000 5.000 <- Outer Group Footer Band All fields use the same font (in fact I copied and pasted them from the detail band into each footer and amended the expressions. Has anyone else seen this? Jasper Studio Designer v6.5.1 final JasperReports Server Product Version : 7.1.0 Build: 20180504_1307