[How to sort bars for each value on x-axis defined in Adhoc view in Jaspersoft server]

Dear Team, 

Disclaimer - I have tried changing the sorting order by Crosstab or Table options and it didn't help. 

I am looking for an option to sort the bars for each value on x-axis i.e. if 4 years plotted on x-axis and then for each year value, we have 3 values of  y-axis which will give 3 bars for each x-axis value.

Now, I want to see this 3 bars in descending order based on the value. Note: I have mentiond a string in legend so currently, those bars are just displayed in alphabetical order and the same  was displayed in legend too. 

Once, a solution is found for this issue, I am hoping, the same order will also be displayed in legend. 

Let me know if you need more information. Thanks. 

 

[Not able to publish HTML element to Jaspersoft server]

Hello, 

I am not able to publish HTML element from Jaspersoft studio to Jaspersoft server.

Purpose of using HTML element: I want to set font size in em rather than px or pt. This will enable to fix the font size when browser size is changed for responsiveness. However, I am still struggling to set a pattern for the field enclosed in this element. If anyone know, please let me know. 

I am seeing below error. Do I need to do any configuration settings on it. Please advise.

Error details:

org.apache.http.client.HttpResponseException: illegal.parameter.value.error Invalid JRXML JRXML.content JRXML.content at com.jaspersoft.studio.server.protocol.restv2.RESTv2ExceptionHandler.handleErrorDescriptor(RESTv2ExceptionHandler.java:120) at com.jaspersoft.studio.server.protocol.restv2.RESTv2ExceptionHandler.handleException(RESTv2ExceptionHandler.java:60) at com.jaspersoft.studio.server.protocol.restv2.ARestV2ConnectionJersey.toObj(ARestV2ConnectionJersey.java:49) at com.jaspersoft.studio.server.protocol.restv2.RestV2ConnectionJersey.addOrModifyResource(RestV2ConnectionJersey.java:550) at com.jaspersoft.studio.server.protocol.ProxyConnection.addOrModifyResource(ProxyConnection.java:328) at com.jaspersoft.studio.server.publish.Publish.publishResources(Publish.java:184) at com.jaspersoft.studio.server.publish.Publish.publish(Publish.java:62) at com.jaspersoft.studio.server.publish.wizard.Publish2ServerWizard$3.run(Publish2ServerWizard.java:303) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)[/code]

 

[How to make Jaspersoft reports responsive and scalable]

Hello,

Could you please help with your expertise on below questions,

1) I have created a Jaspersoft report in Jaspersoft studio and published to Jaspersoft server. When accessed, the report is not responsive/scalable when browser size is changed. I tried adjusting the zoom settings to fit page etc. but no luck. Any idea on how to make Jaspersoft server reports responsive/scalable.

2) Tried to embed the same Jaspersoft report on a web application using Visualize.Js API and used scale: "container" code and it works partially as the size of the report is getting shrunk towards top portion of the page leaving empty space in the bottom. Do we have any ways to achieve the responsiveness in a better way.

[How to put short number format for a measure in Jaspersoft studio]

Hello All, 

Can anyone please tell me on how to put short number format for any measure in Jaspersoft studio. See examples below, 

For Currency - I have a value "5,766,576.75" to be shown as "$ 5.77M"

For Number - I have a value "1,255,657.21" to be shown as "1.26M"

Please share a format and sample output. Thanks. 

[How to show drop down inputcontrol/parameter in Title/Summary bands in Jaspersoft]

Thanks your response! Hozawa. Can you atleast suggest me any alternatives besides showing input controls on left side. 

[How to show drop down inputcontrol/parameter in Title/Summary bands in Jaspersoft]

Hello All, 

Can anyone please tell me on how to show drop down inputcontrol/parameter in Title/Summary bands in Jaspersoft. 

I know, you can get input controls in Jaspersoft server which shows at left side of the page but I want to enclosed within the page i.e. somewhere in the bands. 

Hope, I am clear with my request. I have searched online but didn't get one. 

 

[Custom Theme for HTML5 charts in Jaspersoft Studio]

Dear All, 

Is there any way to create custom themes to apply for HTML5 charts. I know, we can do the same by modifying each and every attribute under Advance formatting however I want to do the same in one file and apply the same to all HTML5 charts. 

I searched entire universe but no concrete information found. Any guidance is greatly helpful. 

[How to apply Custom theme to a specific report in Jaspersoft Studio]

Dear All, 

I have created a custom theme and I could see the changes reflecting in preview. I also generated a JAR and added to classpath however I still do not see the new changes especially related to new colors added under Plot of custom theme. 

1) Could anyone please tell me, how would I apply my recent colors part of newly created Custom theme to my report within Jaspersoft Studio. 

2) After #1, please tell me same how would I see in Jaspersoft server, here, I uploaded the Jar file and also set as Active Theme but still no luck. 

Up on my research, all I see is below, 

To use the chart theme in Jaspersoft Studio, you must add the JAR to your project's classpath: in the Project Explorer, right-click the JAR and choose Build Path > Add to Build Path. If you're Project Explorer isn't displayed, click Window > Show View > Other > Project Explorer. Once Jar is uploaded, you can use the repo: syntax in a report to specify this JAR as your chart theme.

Any guidance is greatly helpful. 

[How to implement Box plot in Jaspersoft studio]

Dear Team, 

I see boxplot attribute in advance chart formatting under plotOptions however I did not find a box plot chart directly in charts. Can anyone tell me how to implement box plot or at least get a chart which resembles it. Thanks. 

[How to implement Volume with confidence Intervals in bar chart]

Dear Team, 

Please advise on how to implement Volume with confidence Intervals in bar chart in Jaspersoft studio. Any guidance is greatly helpful. 

[How to show error bars in bar chart or any chart in Jaspersoft studio]

Dear Team, 

Can anyone tell me on how to show error bars in bar chart or any chart in Jaspersoft studio. An example or a working copy would be greatly helpful. 

I tried digging in HTML5 charts related attributes like series.errorbar, plotOptions.errorbar etc but not sure how to set it up to see in graph. Please advise. 

[Dynamic change of X & Yaxis on any chart in Jasperstudio 6.4.2]

Dear Team, 

Need your input/suggestion to figure out a way to implement dynamic change of fields set on both X & Y-axis of any chart in Jasperstudio 6.4.2.

Thanks in advance!

[Hyperlink navigation on click of a Tooltip content in Jasperstudio 6.4.2]

Dear Team, 

Could anyone confirm if there is a possibility to implement a hyperlink navigation on click of a Tooltip content for any chart in Jasperstudio 6.4.2.

Any suggestions/guidance would be greatly helpful. Thanks. 

[How to show multiple values of one field in tooltip using Jaspersoft Studio]

Thanks for the response! Apologies for asking this question again, I am using version 6.4.2 and I do not see "hyperlink tooltip expression", unfortunately, I do not have an option to attach few screenshots for your reference. Also, in your provided expression, you gave $P{City}, paramater, I did not create any, can you provide some screenshots to help me with. 

[3D Summary reports in Jaspersoft studio]

Thank you so much! Tiru. I would definitely explore it as a starting point and revert to you if any further questions.

[How to show multiple values of one field in tooltip using Jaspersoft Studio]

Thanks for the response. Could you please elaborate a bit i.e. which place, I need to put as I already have below, 

I have a pie chart where category is Country and on tool tip, I want to show list of cities concatenated and with their shipment values if hover. 

Ex: If mouse is hover on India then tool tip should show "Hyderabad:10, Mumbai:50, Delhi:40"

Here is my current tooltip.pointFormat attribute :  {series.name}: <b>{point.y}</b><br/>City:{point.City}<br/>Value:{point.Value}

City is showing last value only. Please advise the place to put in. Thanks much! 

[How to show multiple values of one field in tooltip using Jaspersoft Studio]

Hello, 

I would like to show multiple values of one field in tooltip using Jaspersoft Studio. Please see below example. 

I have a field 'City' whose values are London, New York, SFO, Cincinnati etc. In tooltip, I want to see "City: London, New York, SFO, Cincinnati", currently, it just shows last value in the column i.e. 'City:Cincinnati'. 

Yes, I followed to customize tooltip.pointFormat however still, it shows last value as stated in 2nd line above. I know, I am doing something wrong and it could be a simple change. 

Any suggestions/code would be highly appreciated. 

[3D Summary reports in Jaspersoft studio]

Hello All, 

Can anyone tell me if there is a way to acheive graphs enclosed in below links. Wants to show business activities on a high level as a summary to leaders. 

https://flowingdata.com/2015/12/15/a-day-in-the-life-of-americans/

 

https://untappedcities.com/2018/05/15/fun-maps-see-the-population-of-manhattan-hour-by-hour/

[Menu & Submenu option in Jaspersoft Studio in latest version]

Dear Team, 

I wanted to see if there are any options to get a Menu with sub menus in report. Any info/guidance is greatly appreciated.