beverleym

Thank you so much for this workaround! It's kind of crazy that we need to use it, you would think that the "Choose visible fields" option would be smart enough to go back to the original domain and refresh itself.

Ah hah! That's exactly what I needed for the Advanced tab of my ad hoc chart. It would be great if the various options shown in this screen shot were on the page at https://community.jaspersoft.com/wiki/advanced-chart-formatting -- I had no idea that .distance was an option, let alone all of the other ones shown on this screen shot.

Maybe check your log files and see if an error is being recorded that isn't showing up in the interface?

I would like to put an annoucement banner similar to how you can do it in Jira (example screen shot attached) to let my users know of some upcoming maintenance. Is that possible in JasperReports Server 7.1? I can't find a way to do it in the documentation but perhaps I'm searching for the wrong terms.

In step 10 it says add parameter at the end "like below" -- but the image doesn't show anything and that's the part I'm trying to figure out. I can get it to open the other report, but it doesn't pass a parameter.

Sigh, I was hoping I'd see the answer to this question when it came up in my search results I'm here 5 years later with the same issue. I'm a user, not a sysadmin.

I tried running this report as both myself logged in via SiteMinder, and directly as superuser. It doesn't pick up logged in SiteMinder users... only SuperUser itself. Which isn't helpful when you want to reboot the server and see who is using it.

Did you ever find a way? I'm looking for the same thing

I am trying to create an ad hoc crosstab view. I just want to know how many records there are in total per year with particular values, and the average over the multiple years. E.g. Cause20192020AverageCause #151510Cause #2100050Cause #3000Electrical502.5Fire Use Escape1312377But since the way I'm counting how many of each cause there are in a given year is by using a calculated measure with a formula of 1, I just get the average of 1 each time. I am using JasperReports Server Professional 7.1 (web interface)

@C-Box I sure wish I could comment directly on the answers. I don't think I can use that Java code in the web interface. There aren't categories, etc. Only Columns and Rows. See screen shot link in previous comment.

what I've got so far..... Screen shot should be below but it's not showing up.... you can also see it at https://ibb.co/6FZ97qg

Ugly final formula. Concatenate(IF(MonthNumber("Ignition Date/Time") <= 9, '0', ''), MonthNumber("Ignition Date/Time"), '-', MonthName("Ignition Date/Time")) Is there a better way??

Nope. that doesn't help my sort issue. Now I get 1-January, then 10-October etc. Sigh.

@danoldenkamp I thought I had done that, but perhaps I hadn't done all the things at the same time. What I've got now is a calculated Field for year with formula = Year("Ignition Date/Time") in the Columns section, along with a calculated Measure for Num with formula = 1. In the Rows section, I have another calculated Field for month with formula MonthNumber("Ignition Date/Time"). This seems to be pretty close to what I was looking for. I was hoping for "January" rather than 1, but if I use the MonthName formula instead, it puts them in alphabetical order so it starts with April and August and ends with September. So I guess I can do a concatenate of both to do 1-January etc.

After posting the above, I found "Time Series" but it won't allow me to select Month, only Day or less. I need to compare 10 years of data so Day will be very messy .. and it still seems to want to do it as a series of days from first to last rather than multiple lines.