H Mendoza

Hi there - I would like to multiply an interger field (for example, $f{salary}) by an interger, say, 2 or 4, or maybe even something like .04. Any idea(s) how to form the correct syntax? I've tried several combinations, but not having much luck. Thank you.

Hi there - Maybe check the following file(s): ireport.conf or ireportpro.conf (varies on version). Look for the following path: c:ireportetc. After you find the file, change your settnigs accordingly. Here's the entry I found in my intance (iReport 5.x): default_options="-J-Xms24m -J-Xmx512m -J-Dorg.netbeans.ProxyClassLoader.level=1000 -J-XX:MaxPermSize=256m -J-Dlog4j.configuration=file:/Applications/jasperreports-server-5.0/apache-tomcat/webapps/jasperserver-pro/WEB-INF/log4j.properties".

Hi there - ETL requires a different license file from that of JRS 5.2--they are not shared. The following link may hep you out, see http://community.jaspersoft.com/wiki/applying-your-jaspersoft-product-licenses.

Hi there - Topics (whether created in iReport or off of a Domain) should always go into the Topics folder in the Organization (one is already set up by default). Also, again by default, there is another Topic folder in the Public folder. If you keep your Topics in these folders, then your users will know not to make an attempt to open them as reports. You probably don't want to hide them since you may want to configure them further in the future. For example, Topics created with iReport or Studio (.jrxml types) can be set up to work with Input Controls. Good luck with your work.

Hi there - A data source is a consumable object that is used for feeding a report only once. As stated in the iReport Ultimate Guide: "For JasperReports to retrieve data and fill the subreport, you have to set the subreport data source. Usually we have three options: Use an SQL query and the same JDBC connection as the parent (super-easy case); or Use a different type of data source (such as an XML file) and some data source elements to create an expression to create or pass the required data source instance. In very special circumstances, we can pass no data at all to the subreport. We will explain with this last option in depth since it provides a way to simulate inclusion of static portions of documents (like headers, footers, backgrounds, and so on)." Good luck with your report.

Hi there - Minor point here, but maybe try the following: &viewAsDashboardFrame=true Good luck with your work.

Hi there - Here is the main report: <?xml version="1.0" encoding="UTF-8"?> <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="sampleMainSub" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="fc655f78-6553-4b1a-9418-e98d696de57b"><property name="ireport.zoom" value="1.0"/><property name="ireport.x" value="0"/><property name="ireport.y" value="0"/><parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false"><defaultValueExpression><![CDATA["C:\Users\hmendoza\Desktop\labWork\"]]></defaultValueExpression></parameter><queryString><![CDATA[sELECT department."department_id" AS department_department_id, department."department_description" AS department_department_descriptionFROM "public"."department" department]]></queryString><field name="department_department_id" class="java.lang.Integer"/><field name="department_department_description" class="java.lang.String"/><group name="department"><groupExpression><![CDATA[$F{department_department_description}]]></groupExpression><groupHeader><band height="33"><textField><reportElement uuid="7afed144-ae54-4d66-abc5-dce17eb40a83" x="0" y="0" width="555" height="33"/><textElement><font size="14" isBold="true"/></textElement><textFieldExpression><![CDATA[$F{department_department_description} + ": " + $F{department_department_id}]]></textFieldExpression></textField></band></groupHeader></group><title><band height="32" splitType="Stretch"><textField><reportElement uuid="44f21734-53a3-491a-b7b4-e409fa2e3cbd" x="0" y="0" width="555" height="32"/><textElement><font size="24" isBold="true"/></textElement><textFieldExpression><![CDATA["Main Report"]]></textFieldExpression></textField></band></title><columnHeader><band height="20" splitType="Stretch"/></columnHeader><detail><band height="100" splitType="Stretch"><subreport><reportElement uuid="478ca3c1-6496-46fd-85d7-8b92746c7b92" x="0" y="0" width="555" height="100"/><subreportParameter name="department_ID"><subreportParameterExpression><![CDATA[$F{department_department_id}]]></subreportParameterExpression></subreportParameter><connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression><subreportExpression><![CDATA["C:\Users\hmendoza\Desktop\labWork\subReport.jasper"]]></subreportExpression></subreport></band></detail><pageFooter><band height="54" splitType="Stretch"/></pageFooter></jasperReport> ... And here is the subreport: <?xml version="1.0" encoding="UTF-8"?><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="subReport" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="1896faa6-afcb-4c1c-9e4c-7820cc21c791"><property name="ireport.zoom" value="1.0"/><property name="ireport.x" value="0"/><property name="ireport.y" value="0"/><parameter name="department_ID" class="java.lang.Integer"><defaultValueExpression><![CDATA[1]]></defaultValueExpression></parameter><queryString><![CDATA[sELECT employee."employee_id" AS employee_employee_id, employee."full_name" AS employee_full_name, employee."first_name" AS employee_first_name, employee."last_name" AS employee_last_name, employee."position_id" AS employee_position_id, employee."position_title" AS employee_position_title, employee."store_id" AS employee_store_id, employee."department_id" AS employee_department_id, employee."birth_date" AS employee_birth_date, employee."hire_date" AS employee_hire_date, employee."end_date" AS employee_end_date, employee."salary" AS employee_salary, employee."supervisor_id" AS employee_supervisor_id, employee."education_level" AS employee_education_level, employee."marital_status" AS employee_marital_status, employee."gender" AS employee_gender, employee."management_role" AS employee_management_roleFROM "public"."employee" employeeWHERE employee.department_id = $P{department_ID}]]></queryString><field name="employee_employee_id" class="java.lang.Integer"/><field name="employee_full_name" class="java.lang.String"/><field name="employee_first_name" class="java.lang.String"/><field name="employee_last_name" class="java.lang.String"/><field name="employee_position_id" class="java.lang.Integer"/><field name="employee_position_title" class="java.lang.String"/><field name="employee_store_id" class="java.lang.Integer"/><field name="employee_department_id" class="java.lang.Integer"/><field name="employee_birth_date" class="java.sql.Date"/><field name="employee_hire_date" class="java.sql.Timestamp"/><field name="employee_end_date" class="java.sql.Timestamp"/><field name="employee_salary" class="java.math.BigDecimal"/><field name="employee_supervisor_id" class="java.lang.Integer"/><field name="employee_education_level" class="java.lang.String"/><field name="employee_marital_status" class="java.lang.String"/><field name="employee_gender" class="java.lang.String"/><field name="employee_management_role" class="java.lang.String"/><columnHeader><band height="20" splitType="Stretch"><staticText><reportElement uuid="9b677ff2-0655-43a0-bc6e-037573327a80" x="0" y="0" width="111" height="20"/><textElement><font isBold="true" isUnderline="true"/></textElement><text><![CDATA[First Name]]></text></staticText><staticText><reportElement uuid="823a666b-17b7-44b7-a6d3-4c429fa6e0a2" x="111" y="0" width="111" height="20"/><textElement><font isBold="true" isUnderline="true"/></textElement><text><![CDATA[Last Name]]></text></staticText><staticText><reportElement uuid="1e469b57-c467-4457-939b-f396f979d426" x="222" y="0" width="81" height="20"/><textElement><font isBold="true" isUnderline="true"/></textElement><text><![CDATA[salary]]></text></staticText><staticText><reportElement uuid="8284a3fe-db19-4ba1-a2c9-0904a17b1f50" x="303" y="0" width="106" height="20"/><textElement><font isBold="true" isUnderline="true"/></textElement><text><![CDATA[Marital Status]]></text></staticText><staticText><reportElement uuid="11e18904-9c16-497e-9ab8-3ebab4c1995d" x="409" y="0" width="146" height="20"/><textElement><font isBold="true" isUnderline="true"/></textElement><text><![CDATA[Role]]></text></staticText></band></columnHeader><detail><band height="20" splitType="Stretch"><textField><reportElement uuid="c30abe7b-ad72-4b7d-9fe1-4facef333013" x="0" y="0" width="111" height="20"/><textElement verticalAlignment="Middle"/><textFieldExpression><![CDATA[$F{employee_first_name}]]></textFieldExpression></textField><textField><reportElement uuid="9da4daf3-0ba5-4609-ba86-955a1f4cc862" x="111" y="0" width="111" height="20"/><textElement verticalAlignment="Middle"/><textFieldExpression><![CDATA[$F{employee_last_name}]]></textFieldExpression></textField><textField pattern="¤ #,##0"><reportElement uuid="aff8ecd9-7c2a-4580-ad83-ea8d3405005f" x="222" y="0" width="81" height="20"/><textElement verticalAlignment="Middle"/><textFieldExpression><![CDATA[$F{employee_salary}]]></textFieldExpression></textField><textField><reportElement uuid="38fb7ccb-e928-4876-9194-d9a3152e1f59" x="303" y="0" width="106" height="20"/><textElement verticalAlignment="Middle"/><textFieldExpression><![CDATA[$F{employee_marital_status}]]></textFieldExpression></textField><textField><reportElement uuid="28ced81a-61ff-4db7-98f8-c5d13b2da8e7" x="409" y="0" width="146" height="20"/><textElement verticalAlignment="Middle"/><textFieldExpression><![CDATA[$F{employee_management_role}]]></textFieldExpression></textField></band></detail></jasperReport> Good luck with your work!

Hi there - The community site has a section where the documents are posted, versions 4.7.0 and higher, see http://community.jaspersoft.com/documentation?version=8446. Also, if you own a copy of the commercial edition, then you can go to your support account and download it, see http://support.jaspersoft.com/. Good luck with your research.

Hi there - This is a good question. I don't have a solution for you, but maybe consider leveraging the frame id (&fid) for the report in the Dashboard. If you can find the frame id, it might just work. It is not a documented feature, so it is unclear whether it works or not. To find the frame id, try exporting the dashboard and then scanning the code for the frame names. Once you have the frame id, you may be able to apply the three-way operator (in some creative way) to switch from true to false, or vice versa. Here's the format (maybe) for referencing the frame: '&fid=contentFrame_' + frameName; By the way, use the following to get to the available export options: js-export.bat --help.

Hi there - Maby this willl help: You will need to publish the report to the server, and then set up the input control for the parameter in your report. The pop up you see in iReport (or Studio) is only used for testing and not the actual input control. You can set up input controls from the server or from iReport, provided you have the server plug-in. Studio also has a plug-in that you can use.

Hi there - This might help: After dragging the Chart element into the designer, select a Chart type from the pop up. In your case, I think you are trying to define a Bar chart, so select that one. Next, click the Ok button. From the Category Chart Wizard, select cancel. Don't worry, the chart is still added to the designer. Right-click the chart and select Chart Data from the fly-out menu. From the Chart details pop up, select the Details tab. Use the Add button on the interface to add the Category series to your chart. When you are finished, click the Close button on the Chart details pop up window.

Hi there - Commercial versions provide auditing. If you don’t see some of the monitoring options, your license may prohibit you from using them. To find out what you're licensed to use, or to upgrade your license, contact Jaspersoft. Here's some additional information that may help you out: http://community.jaspersoft.com/documentation/jasperreports-server-administration-guide-beta/server-diagnostics. Also, by default, the auditing and monitoring subsystem is off, so you might check the status on your system.

Hi there - A report cannot use any resource that belongs to another organization. Also, maybe consider using the Public folder. However, the Public folder should contain only content that is shared across all organizations--nothing private or sensitive belongs in the Public folder. Background: If a report that references resources in various folders (like images or input controls) that is native to multiple organizations, then those organizations must share identical folder structures, or the paths to some of the report dependencies will be invalid and the reports will not execute. But don't forget that while this can be done, your report cannot use a resource that belongs to another ogranization.

Maybe check out the following: http://community.jaspersoft.com/questions/800405/how-install-and-start-using-ubuntu-1204. It is for a different version, but the site may help. Also, you can check the JasperReports Server Install Guide, which covers Windows, Linux, and Mac.

Tough to say without more information. There's detailed information on working with users and roles in the JasperReports Server Admin Guide, Release 5.0. See Chapter 2: Organization, User, and Role Management. Of course, I am assuming that you are using Version 5.x. If you are not, then please reference the appropriate documentation for the version you are using.

Here's a little bit more information that may help you out: The iReport Ultimate Guide has a section on Subreports that addresses passing parameters. I don't know which version of iReport (or Studio) you are using but for iReport 5.0, it is in Chapter 17, titled, Subreports. For information on parameters, go specifically to Chapter 17.1.4: Passing Parameters.

Just a thought -- you might consider using the column feature in iReport. I created name tags using this option and it worked out well. You may have to experiment a little bit to get the exact size you want (in terms of find the fold area), but I think this might be an appropriate approach since the you can control the vertical distance and how data fills across each column. You can get to the Columns properties by right-clicking the root file within the Report Inspector, and then selecting Properties from the fly-out menu. From the pop up window, scroll down to Columns and set the number of columns that you need, in this case maybe two. Also, maybe use the Landscape paper orientation from the wizard.

In this case, from your own custom application, for example, you could provide hyperlinks to your dashboards via the HTTP API. This way, the user does not see the repository view or the Jaspersoft frame, but only the dashboard. As a matter of fact, the user won't even kow that the dashboard is in Jaspersoft. You could also further configure the repository itself, since what a person sees in the repository is managed via system roles, users and permissions. These are two ideas to consider to help you get started, based on my understanding of your requirement listed above.

This may help, too: There is an article that I found very helpful--read through this and see if it helps: http://www.jaspersoft.com/how-set-role-based-jasperserver-home-pages. Once you are finished, log in as your target user and the dashboard should appear on the user’s home page.

Maybe this will help you out: For a cascading input control you need a query in your report that includes a WHERE clause and references to the parameters that you have in your report. So, for example, you might have the following in your main report (the two parameters are country and state_list): WHERE store_country = $P{country} AND $X{IN, store_state, state_list} ORDER BY store_country, store_state, store_name You will need a Single-select Query for the country parameter, which requires both a db connection and a query. Your query might look like this: SELECT DISTINCT store_country FROM store ORDER BY store_country. You will need a Multi-select Query for the state (state_list) since countries can have more than one state or district. Again, you will need a db connection configured and a query. The query for the state parameter might look like this: SELECT DISTINCT store_state FROM store WHERE store_country = $P{country} ORDER BY store_state. When you run the report you will be prompted to select a country (single select) and the states associated with that country will load underneath. Pick the state or states that you wish to include in your report, and then click the Ok button.