gabriel.nadoroski

I don't send the $F{month} as a parameter for another table be cause I don't know how, I need send him for another tables in my report to make another queries, I have 19 others queries, and I'll send the month and year for the all queries, the year I request for the user, and month, that my main query does, will send to the others tables.

Hi everyone, I have a question, I'm trying put a field of the result the query in the parameter to send for the tables of report, I'm trying somethin simple, I KNOW THIS IS WRONG $P{month} = $F{month} I don't have ideia how I can do this, I'm making a report with months, so all the year, so is 12 months, the principal dataset just back to me the months I have events, I can't post the code here because he is too big, about 3000 lines, I have send the parameter for another datasets, and one of this parameters is a month of query return to me, anyone can help me that thing ? Thanks, Gabriel Nadoroski.

Hi, I do a post recently about xls, I'm doing a report was printed every sales of the company in all year and I need divide the pages in months, the report worked but I don't know how I divide the sheets, The solution they gave me does not work, I go to propriets of the report, and I put the net.sf.jasperreports.export.xls.one.page.per.sheet like true, I mark the "no pagination" and put a break in a group, every time the field month change the page was supposed to break, but this don't work, I try dismark the "no pagination" but don't change nothing, he make 16 pages, I'm printing just 2 months, it was right to print only two pages. Anyone knows how this work ? this is the last post: https://community.jaspersoft.com/questions/1111626/sheets-xlsx

Hi Paul Thanks. I tried this once, don't worked, I believe I did the same thing in the article, but my jasper studio has a bug, the lines, and letters are white, i don't see nothing unless I click once in one line, I don't know it is the S.O I use or the software, I was using the ubunto 18. I tried, but don't work, I have a question, after mark the xls.onepagepersheet type like true, in ignore pagination, i let mark this option too ? how I make the page broken ? I put the break, and I criated a group, and a field whit the month, also every time the month change, the idea was broke the page, but don't work

Hi take a look in this post https://community.jaspersoft.com/questions/510881/split-string Hope it Helps Gabriel Nadoroski

Hi, So, you can use this: <textFieldExpression> <![CDATA[($F{Street} != null ? $F{Street} : " " )+" - "+($F{Number} != null ? $F{Number} : " " )+" - "+($F{Complement} != null ? $F{Complement} : " ")]]></textFieldExpression>[/code]I caught this of one part of a report I have in my system, it is like a IF, or TERNARY, if the field is different of null he print the field, else he print just a blanc space, you can do this with a variable (I guess), or change the blanc space for a other field or variable. Hope this helps. Gabriel Nadoroski

Hi, I need help, has been some time I try make a report, the query of report send to me a relation of sales of all the year, and I need to create a new sheet for each month in the excel, I try put the "no pagination" and afther put the break line and every time my variable month change I create a new sheet, but this don't work, anyone know how I can do that ? Thanks Gabriel Nadoroski

Hi andrew_50, I don't know it is helpful, but when I need to use barcode-4j I put the QRcode (It's the only one that works.), and I go to the xml code and modify QRcode for the barcode I need, in the case was the DATAMATRIX. <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.6.0.final using JasperReports Library version 6.6.0 --><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Blank_A4_2" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="0b3c42fb-64b8-4531-b4c5-605d1bb06199"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/> <queryString><![CDATA[]]></queryString> <background><band splitType="Stretch"/></background> <title><band height="79" splitType="Stretch"/></title> <pageHeader><band height="35" splitType="Stretch"/></pageHeader> <columnHeader><band height="61" splitType="Stretch"/></columnHeader> <detail> <band height="125" splitType="Stretch"> <componentElement> <reportElement x="0" y="0" width="99" height="29" uuid="5af81c13-024a-4c4a-b712-cb98a81396a7"/> <jr:QRCode xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd"> <jr:codeExpression><![CDATA["123456789"]]></jr:codeExpression> </jr:QRCode> </componentElement> <componentElement> <reportElement x="450" y="0" width="99" height="29" uuid="22a4923a-4ae4-4c1e-a67c-23fa9550212b"/> <jr:DataMatrix xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd"> <jr:codeExpression><![CDATA["123456789"]]></jr:codeExpression> </jr:DataMatrix> </componentElement> </band> </detail> <columnFooter><band height="45" splitType="Stretch"/></columnFooter> <pageFooter> <band height="54" splitType="Stretch"/></pageFooter> <summary> <band height="42" splitType="Stretch"/></summary></jasperReport>[/code]This is a example, I hope it helped you.

Hi, Anyone knows how I decrypt a parameter in jasper ? I receive a encrypted string in base x64, how I convert this value ?

Hi, I need put some jar in application to the java.io.ByteArrayInputStream?

Hi, I made some questions here to make a report using the json, the report are running on the software, but, the framework I use in php, Yii2, he use the chrmorandi to comunicate to the jrxml file, he use the escapeshellcmd, and put two inverse bar " " every time when json crack the line, and I have a error in jasper, because the parameter not expected the other one " ", if I send only one it works, but the framework everytime send me two, and I dont have nothing to do about this, anyone knows how I make the parameter ignore that second caractere? This is the parameters I use: <parameter name="jsonString" class="java.lang.String"/><parameter name="JSON_INPUT_STREAM" class="java.io.InputStream"> <defaultValueExpression><![CDATA[new java.io.ByteArrayInputStream($P{jsonString}.getBytes("UTF-8"))]]></defaultValueExpression></parameter>[/code] This is the other question I do: https://community.jaspersoft.com/questions/1108701/printed-json-values Thanks! Gabriel Nadoroski

I found the solution, if you using JasperStarter only atualize the files, just do this he come it work again. Here is the link where I do the download: https://sourceforge.net/projects/jasperstarter/ Thanks !

I found the solution, if you using JasperStarter only atualize the files, just do this he come it work again. Here is the link where I do the download: https://sourceforge.net/projects/jasperstarter/ Thanks !

Hi, I have a bug or a error when I try to use a DataMatrix code in my report in the php, in jaspersoft studio the report works normaly, he print the DataMatrix but when I put in de php, I have a error, I tested without the code of DataMatrix and it works. This is the code of DataMatrix: <componentElement> <reportElement x="232" y="37" width="75" height="66" uuid="162f75f3-5070-4402-9650-ea6342d1997e"/> <jr:DataMatrix xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd"> <jr:codeExpression><![CDATA[$F{CodigoDeBarras}]]></jr:codeExpression> </jr:DataMatrix></componentElement>[/code] This is the errors: Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. Tue Oct 30 11:00:13 BRT 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. Warning: Could not get charToByteConverterClass! Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/batik/bridge/FontFamilyResolver at net.sf.jasperreports.renderers.util.SvgDataSniffer.<init>(SvgDataSniffer.java:57) at net.sf.jasperreports.renderers.util.SvgDataSniffer.getInstance(SvgDataSniffer.java:68) at net.sf.jasperreports.renderers.util.RendererUtil.getSvgDataSniffer(RendererUtil.java:148) at net.sf.jasperreports.renderers.util.RendererUtil.isSvgData(RendererUtil.java:107) at net.sf.jasperreports.renderers.util.RendererUtil.isSvgData(RendererUtil.java:137) at net.sf.jasperreports.engine.export.JRPdfExporter$InternalImageProcessor.process(JRPdfExporter.java:1575) at net.sf.jasperreports.engine.export.JRPdfExporter$InternalImageProcessor.access$300(JRPdfExporter.java:1532) at net.sf.jasperreports.engine.export.JRPdfExporter.exportImage(JRPdfExporter.java:1472) at net.sf.jasperreports.engine.export.JRPdfExporter.exportElements(JRPdfExporter.java:1090) at net.sf.jasperreports.engine.export.JRPdfExporter.exportFrame(JRPdfExporter.java:3117) at net.sf.jasperreports.engine.export.JRPdfExporter.exportElements(JRPdfExporter.java:1098) at net.sf.jasperreports.engine.export.JRPdfExporter.exportPage(JRPdfExporter.java:1053) at net.sf.jasperreports.engine.export.JRPdfExporter.exportReportToStream(JRPdfExporter.java:917) at net.sf.jasperreports.engine.export.JRPdfExporter.exportReport(JRPdfExporter.java:537) at net.sf.jasperreports.engine.JasperExportManager.exportToPdfFile(JasperExportManager.java:155) at net.sf.jasperreports.engine.JasperExportManager.exportReportToPdfFile(JasperExportManager.java:503) at de.cenote.jasperstarter.Report.exportPdf(Report.java:327) at de.cenote.jasperstarter.App.processReport(App.java:230) at de.cenote.jasperstarter.App.main(App.java:102) Caused by: java.lang.ClassNotFoundException: org.apache.batik.bridge.FontFamilyResolver at java.net.URLClassLoader.findClass(URLClassLoader.java:381) at java.lang.ClassLoader.loadClass(ClassLoader.java:424) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349) at java.lang.ClassLoader.loadClass(ClassLoader.java:357) ... 19 more I'm using the jdbc most current and the other reports I have in the code they works, this is not a problem, but he appoint that, the error is the second code. Anyone knows how fix that ? I'm using php with Yii2 FrameWork and the chrmorandi for jasper. Gabriel Nadodoski

Hi, I found a solution, I made some changes, I will make a post explaining everything and helping anyone that need thanks!