itservices_3

Using calculation = "Nothing" did the trick. Thanks.

I have a crosstab that represents production status over time periods. I want to get the value for the last time period and show it in the row group. Using a measure, I can do this for the lowest value over the time span. But this time I'd like to get the last value. I don't see that ... first is there but not last. How can I do that?

I'm using iReport 5.6.0. This is required by Fishbowl (grumble). I changed a connector's Database URL from "jdbc:mysql://192.168.50.2:3305/milo" to "jdbc:mysql://192.168.50.25:3305/milo". However, I'm still getting data from the old URL. I also use Studio, made the same change, no problem. Any idea why this is happening?

That's clever. Unfortunately, we're not using the Jaspersoft server; reports are being executed on a Fishbowl installation. There's no way to change the report properties there.

When I'm developing a report in Jaspersoft Studio, it will display and let me change the parameter values when I select preview. These are the is-for-prompt parameters. The not-for-prompt parameters are not shown. However, I need to be able to modify these parameters during testing even if the end user won't see them. I don't really want to be changing default values for these parameters since it's just for testing. Is there some way I can have Studio display these parameters?

Well, this has been educational. Thanks to all. First, I did finally get the report to compile and even produce some plausible results. Parameter "cbShipToState/Province" had default value "%", which after substituting into the SQL, became just plain % (no quotes). Changing it to "'%'" did the trick. I don't yet know why other similar parameters such as "AlternateReportTitle" don't have the same problem. What puzzles me most is why the original report compiles and runs with no problem on the Fishbowl server. I did not know about JDBC prepared statements and ? placeholders. Thanks to @lucianc for the link. @jgust: Your comment on multi-word non-quoted values refers to the parameter description, not the default value expression. In Jaspersoft Studio, there is a convention that if the parameter name starts with "cb" (standing, I suppose, for "combo box"), then the parameter description consists of pairs of substitution value, description. What the user sees is the description, what gets used is the substitution value. @yama818: Your comment about the use of $P! might be right since the parameter is just boolean 0/1 and not a piece of SQL. From a query correctness point of view, I think either usage will produce the same result.

@yama818: I've never seen properly formed SQL with ? symbols in them. Can you send me a link to help me understand? I'm working with a report authored by FishBowl. It works somehow on their server. I've attached the jrxml. @jgust: good catch on the type mismatch. However, I changed the parameter to integer but no difference in the output.

I'm getting errors in a Jasper Studio report. I added logging to Studio so I could see the SQL submitted to the server. I see for example where the original source contains That parameter is defined as Any idea why this is happening?

That line should be year(expense_date) ==${Table_Year}. The way it's written with a single equals sign, it interprets as an assignment statement.

This is an old issue, but I'm having it too. I tried calling Fishbowl support. They don't / won't answer it.

I'd like to show the report's Name property in a report. Is there a way to reference it? Thx, Bill

I'm working with an existing report in iReport. (I have to use iReport.) I seem to be missing a library. For example, it references com.fbi.sdk.constants.setup.CurrencySymbolConst.getConstant. I can't find a library with that method in it. I've seen a proposed solution at https://community.jaspersoft.com/questions/857156/resolved-error-cannot-be-resolved-type, but it seems to require Java and Jasper libraries I don't have. See the attached screenshot.

Ah, found it. Way off to the far right on the preview panel is an icon to "show parameters". Whew. I guess Studio's interface is intuitive after you finally learn it.

In the report preview panel there's a button for "run" that will rerun the report. I have a report with parameters. When I go to the preview panel, it prompts for the parameters and then rungs. I want to rerun the report with different parameters but when I click "run", it reruns the report without prompting. According to https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v71/preview-tab-0, there should be a menu to the right of the run button to select interactive, but I don't see it. See the attached screenshot. Thanks, Bill

Thanks, jgust. How do you handle parameters?

I'm relatively new to Jaspersoft Studio and to MySQL, though I have a decent background in SQL Server and in Crystal Reports. I have a Studio report that needs modification. It contains a large and complex query, with embedded selects. In an effort to understand it, I'd like break the query up and work with it in something like MySQL Workbench. However, the query contains parameters such as $P{dateFrom} which are not part of MySQL I could of course replace all the paramters with constants but that's a hassle. Any suggestions on best way to proceed?

I modified a custom report written for Fishbowl using Jaspersoft Studio. When I try upload it, I get error 50710710 - A Jasper file must be specified. The exception stack is shown, below. I know others have used Studio for this purpose. The only thing I found is to set compatibiity to version 5.5.0, which I did. No joy. Any other ideas? Thanks, Bill com.fbi.util.exception.ExceptionMainFree: A .jasper file must be selected. at com.evnt.client.modules.report.wizards.newreport.ReportNewWizard.loadReportInfo(ReportNewWizard.java:122) at com.evnt.client.modules.report.wizards.newreport.ReportNewWizard.nextStep(ReportNewWizard.java:106) at com.fbi.gui.wizard.FBWizard.nextStepsPrep(FBWizard.java:255) at com.fbi.gui.wizard.FBWizard.access$100(FBWizard.java:34) at com.fbi.gui.wizard.FBWizard$2.actionPerformed(FBWizard.java:72) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.setPressed(Unknown Source) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEventImpl(Unknown Source) at java.awt.EventQueue.access$500(Unknown Source) at java.awt.EventQueue$3.run(Unknown Source) at java.awt.EventQueue$3.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue$4.run(Unknown Source) at java.awt.EventQueue$4.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.WaitDispatchSupport$2.run(Unknown Source) at java.awt.WaitDispatchSupport$4.run(Unknown Source) at java.awt.WaitDispatchSupport$4.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.awt.WaitDispatchSupport.enter(Unknown Source) at java.awt.Dialog.show(Unknown Source) at com.jidesoft.dialog.StandardDialog.show(Unknown Source) at java.awt.Component.show(Unknown Source) at java.awt.Component.setVisible(Unknown Source) at java.awt.Window.setVisible(Unknown Source) at java.awt.Dialog.setVisible(Unknown Source) at com.fbi.gui.wizard.FBWizard.setVisible(FBWizard.java:383) at com.fbi.gui.wizard.FBWizard.setVisible(FBWizard.java:355) at com.fbi.gui.wizard.FBWizard.showWizard(FBWizard.java:141) at com.evnt.client.modules.report.ReportModuleClient.btnUploadActionPerformed(ReportModuleClient.java:786) at com.evnt.client.modules.report.ReportModuleClient.lambda$initComponents$6(ReportModuleClient.java:1219) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.setPressed(Unknown Source) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source) at com.jidesoft.plaf.basic.BasicJideButtonListener.mouseReleased(Unknown Source) at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEventImpl(Unknown Source) at java.awt.EventQueue.access$500(Unknown Source) at java.awt.EventQueue$3.run(Unknown Source) at java.awt.EventQueue$3.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue$4.run(Unknown Source) at java.awt.EventQueue$4.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source)

@glenarvand: the link didn't help me. How exactly did you do it? Thx

I don't think the doc said that this was for the $$ version. That seems rather unkind. Anyway, are there any tutorials for the community edition?

The docs for getting going with Jaspersoft Server show a home page with links to create data sources, domains, etc. None of those show up for me (using v. 7.0.1). I've managed to create a data source by right-clicking on a folder and choosing Add Resource -> Data Source. Here's a link to a screenshot: https://www.dropbox.com/s/kpafyk1e3gkxucj/Jaspersoft%20Server%20view.png?dl=0. What do I need to do?

I just installed iReport (5.6.0) on Win 10. When I start it, I get the logo for a little while and then it disappears without a trace. What can I do?