tchen_1

I'm using JasperSoft studio, and I have a query that returns a record, and I want it displayed like this: Static Text label 1:$F{field_1}......Static Text label n:$F{field_n}So I want the usual table component, but transposed. How do I do this? Thanks.

I have a web application that displays a jasperreport containing a pie chart as a PDF in an iframe. This report is stored in JasperServer. I'm wondering if it's possible to link other reports to the chart so that when you click on the slices of the pie chart, it dynamically generates (perhaps with parameters) the other reports. I was thinking of perhaps a hidden subreport in the main report such that the main report contains an anchor to the subreport and when the anchor is clicked it displays the subreport. Does anyone know how to implement this? Ideally, the anchor/hyperlink should also work even after the user downloads the report, so that it doesn't depend on the web application it's in. I tried configuring a "ReportExecution" hyperlink in the pie chart by following the instructions here (https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v71/anchors-bookmarks-and-hyperlinks-0), but that link doesn't work when the report is a pdf living in my web application. I'm using JasperServer 7.1 community edition and version 6.5.1 of JasperSoft Studio. Thanks!

We can retrieve reports from JasperReports Server by calling a url like: http://<host>:<port>/<context>/flow.html?_flowid=viewReportFlow&reportUnit=/public/Samples/Reports/SalesByMonthReport&startMonth=7&output=pdf[/code]My question is what are all the possible values the output parameter can take? This link (https://community.jaspersoft.com/documentation/tibco-jasperreports-server-ultimate-guide/v710/repository-http-api) says: output (optional) – specifies the output format. Values for this parameter are keys for the report exporters configured in the server. By default, the server recognizes the following output types: pdf for PDF, xls for Excel (Paginated), xlsNoPag for Excel, xlsx for XLSX (Paginated), xlsxNoPag for XLSX, rtf for RTF, csv for CSV and swf for the Flash report viewer. When this parameter is not specified, the default format is HTML displayed in the report viewer. But I tried output=docx and it also worked. I'm using version 7.1.0 of the community edition of JasperReports Server. Can anyone provide a list of all the possible values for the output parameter? Thanks!

Do newer versions of JasperReports Server support oracle database? In the version 6.3.0 release notes, it says: [NOTE: You can use the js-install command-line shell scripts if you are installing to the following databases: PostgreSQLMySQLDB2Microsoft SQL ServerOracle ]But from that version onwards the release notes and installation guides only say that Postgres and MySQL are supported.

So I have a java servlet called MyServlet that returns xml data when I call http://localhost:8080/MyJavaApp/MyServlet, and I would like to use this as a data source. The documentation for remote xml data sources (https://community.jaspersoft.com/wiki/remote-xml-datasource) seems very out of date, so I was wondering if there's documentation for doing so for the latest version of jasperserver and jasper studios? In particular, the old documentation says: [by default JasperReports Server does not ship with the xpath2 query executer, for this we'll need a jar file that comes with iReport. Copy jasperreports-extensions-3.5.3.jar from /ireport/modules/ext to JasperReports Server/jasperserver-pro/WEB-INF/lib/jasperreports-extensions-3.5.3.jar (or if using Jaspersoft Studio plugins/com.jaspersoft.studio.data_5.6.0.final.jar and plugins/com.jaspersoft.studio_5.6.0.final.jar)Add the following line to /jasperserver-pro/WEB-INF/classes/jasperreports.properties net.sf.jasperreports.query.executer.factory.xpath2=com.jaspersoft.jrx.query.JRXPathQueryExecuterFactory Restart Tomcat]Is this still the case? If so, what jars from jasper studios are needed now? Thanks!

I created a user with username tokenUser and I want to be able to authenticate him with just his username; that is, I want the URL "http://localhost:8080/jasperserver?pp=u=tokenUser" to log him in. I edited the sample-applicationContext-externalAuth-preAuth xml file so that the preAuthenticatedManager bean looks like: <bean id="preAuthenticatedManager" class="com.jaspersoft.jasperserver.api.security.externalAuth.wrappers.spring.JSProviderManager"> <property name="providers"> <list> <!-- This bean calls upon preAuthenticatedUserDetailsService to create user details based on a token extracted from request by proxyPreAuthenticatedProcessingFilter --> <bean class="com.jaspersoft.jasperserver.api.security.externalAuth.wrappers.spring.preauth.JSPreAuthenticatedAuthenticationProvider"> <property name="preAuthenticatedUserDetailsService"> <bean class="com.jaspersoft.jasperserver.api.security.externalAuth.preauth.JSPreAuthenticatedUserDetailsService"> <!-- Token format configuration example for token: u=obama|r=PRESIDENT,HUSBAND|pa1=USA,Kenya|pa2=Washington --> <property name="tokenPairSeparator" value="|"/> <property name="tokenFormatMapping"> <map> <entry key="username" value="u" /> </map> </property> <property name="tokenExpireTimestampFormat" value="yyyyMMddHHmmssZ"/> </bean> </property> </bean> </list> </property> </bean> I did not edit anything else in the xml file. Then I renamed it as applicationContext-externalAuth-preAuth and put it in "C:Jaspersoftjasperreports-server-cp-7.1.0apache-tomcatwebappsjasperserverWEB-INF". After restarting JasperServer, the URL "http://localhost:8080/jasperserver?pp=u=tokenUser" gives me a 404 error. I also tried "http://localhost:8080/jasperserver?pp=u%3DtokenUser" and "http://localhost:8080/jasperserver?pp%3Du%3DtokenUser" and also simply "http://localhost:8080/jasperserver"; they all give me the 404 error. I also tried tokens with the default users that come with JasperServer and they also don't work. As soon as I delete the preAuth xml file in WEB-INF and restart the server, everything works again (no 404 when I navigate to "http://localhost:8080/jasperserver"). Any ideas?

Is there a way for me to call a procedure that populates a temporary table and then grab data from that table using a select statement? I tried: <queryString language="plsql"> <![CDATA[{call my_procedure(some_input)} select * from temp_table]]> </queryString> but it doesn't work. I also tried calling the procedure in the main report and using a subreport to do the select statement, but that doesn't work either. I know that I can pass the ORACLE_REF_CURSOR to my_procedure and have it populate the temp table and return a resultset with my data in it, but the question I have about this is: do I need to close the cursor myself or does pl/sql or something else take care of this for me automatically? I'm concerned about this because I read about people encountering the "maximum open cursors exceeded" error. Thanks!