k.Herkt

Has anyone an idea how to fix this? Kind Regards

It seems to be an iOS specific problem

Hello I have a problem with all multi-select lists and all single-select lists in the input control dialog (after i selcted a report). The selection is working fine if I use Firefox or Chrome on a Desktop PC via mouse, and it also works if iam using a Browser in an Android Smartphone. I touch (smartphone) or select (with a mouse on desktop) a single entry of a selection-list and it immediately gets selected. On the desktop PC i can also hover over each entry. It does not work as expected if i am using for example an iPad or the touch-display of my lenovo notebook. I have to touch a single entry of a selection-list 2 to 3 times until it gets selected. Most of the time after the first 1 to 2 touch, the color of the entry only changes to a gray background, which seems to be the hover-function. I need to change the behaviour on iPad and touch-display notebook, to be the same as on my Andriod smartphone: One single touch means immediate selection of the list entry. Can i change this behaviour via CSS, JavaScript or anything else? Where in the source do i have to look? I need to use the JasperServer, not the mobile App. Kind Regards

I have a main-report with several sub-report. All sub-reports and the main-report are using the same connection, except ONE sub-report. I created 2 Data Sources on 'JasperReports Server', but i can only specify ONE data source for the main-report and its sub-reports. The "bad solution" for this is to manually add a second java.sql.Connection in the main-report.jrxml. But is there a more safe and dynamic solution, than doing this by hardcoding the db credentials? http://community.jaspersoft.com/wiki/multiple-datasources-ireport-lists-tables-and-subreports The "bad solution" in the main-report.jrxml from the provided link: <parameter name="MS_SQL_CONNECTION" class="java.sql.Connection" isForPrompting="false"> <parameterDescription><![CDATA[java.sql.DriverManager.getConnection("jdbc:sqlserver://SERVER_IP;databaseName=DB_NAME","USER_NAME","USER_PASSWORD")]]></parameterDescription> </parameter> Only one sub-report is using this MS_SQL_CONNECTION, all other sub-reports + the main-report are using the "primary" connection (PostgreSQL). Thanks

You can use several sub-reports in your main-report. Each of this sub-report could connect to a different database. You can provide this sub-reports a different $P{REPORT_CONNECTION} But i dont know if the only way to achieve this is by hardcoding the credentials: <parameter name="MS_SQL_CONNECTION" class="java.sql.Connection" isForPrompting="false"> <parameterDescription><![CDATA[java.sql.DriverManager.getConnection("jdbc:sqlserver://host_ip:1433;databaseName=db_bane","username","password")]]></parameterDescription></parameter> Then pass this to your subreport <subreport overflowType="Stretch"> <reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="842" height="40" isRemoveLineWhenBlank="true" isPrintInFirstWholeBand="true" isPrintWhenDetailOverflows="true" uuid="d3eda5ac-f656-4af0-bf6b-392c075c8e08"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <connectionExpression><![CDATA[$P{MS_SQL_CONNECTION}]]></connectionExpression> <subreportExpression><![CDATA["subreport.jrxml"]]></subreportExpression> </subreport>

Without sub-report: If you dont want to use sub-reports, you could create a view in your database were you join your needed data. Or use subqueries, or something like WITH-Queries (https://www.postgresql.org/docs/9.4/static/queries-with.html) With sub-report: You can use several sub-reports in your main-report (optional: each of this sub-report could connect to a different database)

Thank you very much. This seems to be a good workaround for me. Is there still a way to set a "default" font and font color for the XLS exporter? This default setting should overrule the settings in the report because: * Some of my reports are using WHITE as font color (some headers), if you export them as XLS you wont see much, because the cells are also white. * I also would like to use ONE font size for the XLS export (like the CSV export), even if my report contains several sizes (e.g 12, 16 and 24 with bold) thank you

Hello, i have several problems while exporting my reports (Jasperserver 6.1.0) as an Excel-File. I tried several settings and properties, but most of them did not help. Note: i can NOT set the properties in each report, because i have to manage about 25+ reports - and future property-changes would end horrible if i have to set them in each report ... So i tried to use the 'jasperreports.properties' in the 'apache-tomcatwebappsjasperserverWEB-INFclasses' folder and the 'applicationContext.xml' in the 'apache-tomcatwebappsjasperserverWEB-INF' What do i need? Short form: something like the CSV exporter does ==> no font colors, no wierd column or row size changes but i cannot use the CSV exporter, because the encoding does not work for french characters, Umlaute and so on (example: 'Erlöse') SOLUTION for CSV: net.sf.jasperreports.export.csv.write.bom=true setting: net.sf.jasperreports.export.character.encoding=ISO-8859-1net.sf.jasperreports.default.xls.encoding=ISO-8859-1net.sf.jasperreports.default.xlsx.encoding=ISO-8859-1net.sf.jasperreports.default.csv.encoding=ISO-8859-1[/code]in 'jasperreports.properties' did not help Long form: * i would like to disable all kind of formatting (ignore the report specific formatting): all fonts are black, all fonts use the same size (in contrast to the normal PDF report) * no column or row merging current settings in jasperreports.properties: net.sf.jasperreports.export.xls.column.width=100net.sf.jasperreports.export.xls.collapse.row.span=truenet.sf.jasperreports.export.xls.remove.empty.space.between.columns=falsenet.sf.jasperreports.export.xls.ignore.cell.background=truecom.jaspersoft.jrs.export.xls.paginated=false[/code]and the 'applicationContext.xml': <bean id="xlsExportParameters" class="com.jaspersoft.jasperserver.api.engine.jasperreports.common.XlsExportParametersBean"> <property name="detectCellType" value="false"/> <property name="onePagePerSheet" value="false"/> <property name="removeEmptySpaceBetweenRows" value="true"/> <property name="removeEmptySpaceBetweenColumns" value="true"/> <property name="whitePageBackground" value="false"/> <property name="ignoreGraphics" value="true"/> <property name="collapseRowSpan" value="false"/> <property name="ignoreCellBorder" value="true"/> <property name="fontSizeFixEnabled" value="false"/> <property name="maximumRowsPerSheet" value="0"/> <property name="xlsFormatPatternsMap" ref="formatPatternsMap"/> </bean> thanks for help

Hello I just tryed the jasper repository guide on the following link: http://community.jaspersoft.com/documentation/tibco-jasperreports-server-ultimate-guide/v610/repository-api I want to access my reports via the 'RepositoryService', but i was not able to compile the code in the given link under the title 'Working with Folders'. So i tryed to look up the required libraries. I use 'JasperReports Server Community Edition (v6.1.0)' - and all potential libraries i found, to make this code working are: * jasperreports-6.1.0.jar (packages starting with net.sf....) * jasperserver-api-metadata-impl-6.1.0.jar (and this one is hard to find, because it is not under 'http://community.jaspersoft.com/project/jasperreports-library/releases') But i am still not able to find the following classes: * com.jaspersoft.jasperserver.api.common.domain.ExecutionContext * com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryService * com.jaspersoft.jasperserver.api.metadata.common.domain.client.FolderImpl I found similar classes in the libraries i mentioned some lines above: * ExecutionContext (no similar class found) * com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryService * com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFolder I am still not able to compile/execute the following line, because of missing and/or incompatible classes (ExecutionContext): hibernateRepositoryService.saveResource( . . . , myFolder); repositoryService.saveFolder( . . . , myFolder); Am i missing something? Is this documentation correct/up-to-date? How can i access my reports via java (for example RepositoryService)? And, IF this code is working, how can i get an (or the) instance of RepositoryService? Thanks