[How to remove blogs from Planet]

Hi, How can we remove blog sites in the Jaspersoft Planet ? 
I don't see "Feeds" section ( so can't edit or delete) in my account as explained here : https://community.jaspersoft.com/wiki/planet-jaspersoft-help-guide.

Someone from Jaspersoft has added my blog site few years ago and now I want this to be removed since the content I post is no longer for Jasper rather automation.
https://community.jaspersoft.com/planet?f%5B0%5D=field_feed_source%3A841187 

Attached image. 

Please help. 

[Drill Down Report Passing Same Value Regardless of What Section is Clicked]

Would this be of any help ? an older post, but details the same concept that you are looking for. 

https://jasper-bi-suite.blogspot.com/2014/04/drill-down-functionality-example-on.html

[How to upgrade/convert old jasper v1.3.0 (i-report) to new v6.16.0 (studio)?]

 Are you looking for downloading the new studio tool, if yes, here you have go : https://community.jaspersoft.com/download

[jasperreport 6.10 crosstab remove null row group]

I have tried with the same data and ended up unresolved  and further research indicated that we can't remove empty rows based on row groups dynamically at cross tab level. 

https://stackoverflow.com/questions/14221656/hide-null-row-groups-jasperreports
https://community.jaspersoft.com/jasperreports-library/issues/4626

I think, the possibility is to modify the result set at SQL level. 

 

[Slow performance when using parameters]

 I would recommend testing the reports in JasperReports server insteqd in the studio since eventually irrespective of DEV or QA or PROD environments, we load or export the reports from the server. 
Coming to the question, which version of studio are you using ? Is it community edition or professional edition ? 
Sometimes it could be poor performance of the studio to load the components with in the report or perhaps it could be memory or report engine issues of the studio. 

[Last page footer is not coming in oracle apex page.]

 I am not really aware of what is  oracle apex 20.1 but I have created a basic video tutorial on bands that includes last page footer. See if that helps you in any way @ 

[Subreport working in Jasper Studio, but not Jasper Server]

Did you try run the sub report as a separate report first in the server see how that's showing up ? 

Normally in a non-complex report, I test the sub report independet of master report then link. 

The other thought on my head is that the paths of the sub-reports should be taken as repo: instead of physical drive paths for the sub reports. 

In recent times, I have created a fundamental video on sub reports that is aviable to watch on YouTube @ : 

Check if this could be of any hlep.!

[Unable to display byte[] image on Report - Database Postgresql]

Hi Community, 
Please help on how to display byte[] data as an image on Japser report.

 1) SQL query : select  * from chart_images where id = 1

2) Filed Name that needs to be displayed as an image  : $F{content}

3) Field data type is : byte[] in jasper reports. 

4) Field type in PostgreSQL is : bytea 

5) Field data looks like 

      ÀÂPNG        IHDR    À          À À J    sRGB  À À  À   xeXIfMM...................................ÀÂP( c À À  À ÀÂ` ÀÂk§À     IEND ÀÂB` ÀÂ

6) Report Design : 

        Taken summary band, Dragged an empty image and put $F{content} feld in the image expression.

Below is the error log. 

Studio Error Log: 

net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Image read failed.
    at net.sf.jasperreports.engine.export.HtmlExporter$CellElementVisitor.visit(HtmlExporter.java:3123)
    at net.sf.jasperreports.engine.export.HtmlExporter$CellElementVisitor.visit(HtmlExporter.java:3095)
    at net.sf.jasperreports.engine.fill.JRTemplatePrintImage.accept(JRTemplatePrintImage.java:417)
    at net.sf.jasperreports.engine.export.HtmlExporter$TableVisitor.visit(HtmlExporter.java:3066)
    at net.sf.jasperreports.engine.export.HtmlExporter$TableVisitor.visit(HtmlExporter.java:3050)
    at net.sf.jasperreports.engine.export.tabulator.ElementCell.accept(ElementCell.java:56)
    at net.sf.jasperreports.engine.export.HtmlExporter.exportTable(HtmlExporter.java:590)
    at net.sf.jasperreports.engine.export.HtmlExporter.exportPage(HtmlExporter.java:490)
    at net.sf.jasperreports.engine.export.HtmlExporter.exportReportToWriter(HtmlExporter.java:391)
    at net.sf.jasperreports.engine.export.HtmlExporter.exportReport(HtmlExporter.java:248)
    at com.jaspersoft.studio.editor.preview.actions.export.AExportAction.exportWithProgress(AExportAction.java:223)
    at com.jaspersoft.studio.editor.preview.actions.export.AExportAction.doPreview(AExportAction.java:347)
    at com.jaspersoft.studio.editor.preview.actions.export.AExportAction$3.run(AExportAction.java:191)
    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)
Caused by: net.sf.jasperreports.engine.JRException: Image read failed.
    at net.sf.jasperreports.engine.util.JRJdk14ImageReader.readImage(JRJdk14ImageReader.java:70)
    at net.sf.jasperreports.engine.util.JRImageLoader.loadAwtImageFromBytes(JRImageLoader.java:164)
    at net.sf.jasperreports.renderers.WrappingImageDataToGraphics2DRenderer.getImage(WrappingImageDataToGraphics2DRenderer.java:76)
    at net.sf.jasperreports.renderers.WrappingImageDataToGraphics2DRenderer.getDimension(WrappingImageDataToGraphics2DRenderer.java:86)
    at net.sf.jasperreports.engine.export.HtmlExporter$InternalImageProcessor.process(HtmlExporter.java:1400)
    at net.sf.jasperreports.engine.export.HtmlExporter.writeImage(HtmlExporter.java:1021)
    at net.sf.jasperreports.engine.export.HtmlExporter$CellElementVisitor.visit(HtmlExporter.java:3115)
    ... 13 more
 

  Have been trying with below data types and expressions but unable get the image displayed and none worked so far. Please help in providing some inputs. 
 java.io.InputStream
 java.awt.Image
 java.lang.Object
 java.sql.Blob

(java.sql.Blob)$F{content}.getBinaryStream()
new java.io.ByteArrayInputStream(javax.xml.DatatypeConverter.parseBase64Binary($F{content}))

new java.io.ByteArrayInputStream(org.apache.commons.codec.binary.Base64.decodeBase64($F{content}.getBytes()))
new java.io.StringBufferInputStream(new org.w3c.tools.codec.Base64Decoder($F{content}).processString())
new java.io.ByteArrayInputStream(Base64.getDecoder().decode($F{content}))

Thank you in Advance. 

Sadakar Pochampalli 

[.jrxml-file i can not generate a report]

Could you provide more details into your issue ? 

[How print a array in jasper ?]

If your need is to remove square brackets I think below should be of help

https://community.jaspersoft.com/blog/tip-remove-and-collection-parameter-jasper-reports

[Using LISTAGG WITHIN GROUP in Report (Oracle Statement)]

Did you give a try on below ? 

webapps/jasperserver/WEB-INF/classes/esapi/security-config.properties  

security.validation.sql.on=false

https://community.jaspersoft.com/questions/541509/error-has-occurred-6632-sql-validation-stored-procedure-45-breaks-all-report

[Subreport using db2 server - Help please]

I think, the driver jar file is missing. Did you have it for the server ? 

[Setting textElement background color by style tag]

I think this will helpful for future readers 

http://jasper-bi-suite.blogspot.in/2018/03/tip-text-only-background-color-in.html

[Styled Text only background color is not working in PPTX export]

found similar usecase but with excel export of styled elements 

https://stackoverflow.com/questions/17196423/styled-text-in-jasperreports-does-not-show-when-exported-to-excel#new-answer

[Styled Text only background color is not working in PPTX export]

+

Using Markup=Styled the text field. 

[Styled Text only background color is not working in PPTX export]

Hi Community, 

I am able to get background color for only text in Text field expression using below expression but when I export the output to pptx it is missing. Its working fine in PDF export. 

"<style backcolor="yellow">24/12</style>"

Did anyone face this issue ? Any help would be appricated. 

Thank you

Sadakar

 

[Unable to install 6.4.2 pro in Windows 10]

Thank you hozawa for the inputs. It is helpful. 

I found other way at : https://community.jaspersoft.com/wiki/getting-connection-refused-error-when-installing-tibco-jasperreports-server-bundled-package

By uncommenting  below  line  in windows hosts file at C:WindowsSystem32driversetc solved the issue. 

127.0.0.1       localhost

Thank you

Sadakar 

[Unable to install 6.4.2 pro in Windows 10]

Hi folks, 

While installing 6.4.2 pro in Windows 10, I got below error message and unable to complete installation. Did any one come across it ? 

Error running C:Jaspersoftjasperreports-server-6.4.2/postgresql/bin/psql.exe -U postgres -p 5432 -h 127.0.0.1

- c "ALTER USER postgres PASSWORD '****":psql:could not connect to server: Connectin time out(0x0000274C/10060) 
Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432? 
The application will exit now. 

Thank you in Advance. 

Sadakar

 

[AWS - EC2 Intallation for Jasperserver Community Edition]

1) Create an AWS EC2 instance (linux flavour or windows). - AWS is free as in speech,not free as in beer. 

2) Follow the usual approach to install studio or server as per user guides. 

I hope it helps.!

[Level1Index in TOC report]

Hi Community, 

Did anyone try level1Index in TOC report ? By default there is a variable called "level2Index" to display level-2 but there is no a variable to display level-1 index. 

The out of the box expression for level2Index is $F{level} == 1 ? 0 : ($F{level} == 2 ? ($V{level2Index} + 1) : $V{level2Index})

Tried creating level1Index as similar to above one as $F{level} == 0 ? 0 : ($F{level} == 1 ? ($V{level1Index} + 1) : $V{level1Index}) but it doesn't work and thrown null value.

In other words, from below I need the bold ones in level1 index in TOC. 

{

1. leve1

         1. level2

          2. level2

2. level1

        1.level2

        2.level2

}

Any help would appricated on this. 

Thank you in advance. 

Sadakar Pochampalli

[custom marker symbol for html 5 line chart]

I've tried with below code but it doesn't work 

<hc:chartProperty name="plotOptions.series.data.marker.symbol">
                            <hc:propertyExpression><![CDATA["function (){ if(this.y==194.1) retrun "url(https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcREREQtiHarOyb4r2bo6vPeAb3wrOOo-BKXoIHRCy4jnHQr5mZ1)" else return "circle"}"]]></hc:propertyExpression>
                        </hc:chartProperty>

[custom marker symbol for html 5 line chart]

Hi, 

Did any one try this http://jsfiddle.net/mt9qmtga/ ?

I was wondering how to set the the symbol for specific data value in high charts advanced properties ? 

If anyone come across it, please shed some light on it ? 

Thank you

Sadakar

[HighCharts Advanced property expression(s) are not taking data set values]

Hi Forum, 

I have a data set created and would like to use the fields in HTML-5 bar chart advanced properties but unfortunately I couldn't find the data set is showing up to select instead looking for fields from main data set. 

Did any one try this earlier ? Please share your experience on this. 

Thank you in Advance. 

- Sadakar Pochampalli

[Image BLOB postgres]

I'm also having the same problem. In my scenario the table in postgres is as follows

create table category_images4  (
"id_category" int primary key,
"category_name" TEXT,
"category_image" oid
)

and the insert statement is : 

insert into category_images4(id_category,category_name,category_image) values(1,'tablette', lo_import('C:UserssadakarPicturesSaved Picturespics1.png'));

I could see that data is stored in table without any issue and the selection of the data : 

select * from category_images4;

id_category category_name category_image

1  tablette 19902
 

In jasper reports I have changed the category_image type to java.io.InputStream but this doesn't work for me. 

I(we) will be very grateful if someone could shed some light on this thread. 

Thank you in advance. 

 

[JasperReports Server (v6.2) Dashboard doesn't work with HTML5 chart report]

Did you check jasperserver logs ?