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?