FAQ Database Discussion Community


In Jaspersoft Studio, how do I use the DATEFORMAT() function?

jasper-reports,jaspersoft-studio
Here's a screenshot. I'm trying to turn the current date into July 1st of the current year using DATEFORMAT(). I learned how to do that in MySQL from this question, and I hoped it would work similarly in Jaspersoft Studio- turns out date_format( curdate(), '%Y-07-01' ) doesn't translate into DATEFORMAT(...

SQL if statement with more conditions

sql,jasper-reports,jaspersoft-studio
I'm creating a automatic raport generator, hes getting al hes information out an database. You can see the progress in the pdf, in that progress you have an specific status, wich is always 0, 1, 2 or 3. If the status is 0-1 he should change an image to an...

How to use object of a class which contain object of another class as datasource in jasper report?

jasper-reports,jasperserver,jaspersoft-studio
I have two different classes, One is Person and another one is Address. The Person class has an object of Address class as one of its property. For example class Person{ String name; Address address; } I cannot change the structure of the class and cannot add any new collections...

d3 with Highchart Jasper Export Issue using Custom Visualization Component(CVC)

javascript,d3.js,highcharts,jasperserver,jaspersoft-studio
I'm developing a Grouped Stacked Bar chart refer this Fiddle, the chart is rendering on jasperserver but it is not exporting to PDF and Excel. I'm receving following Exception: net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRRuntimeException: Error while executing the javascript file to generate the SVG image: External process did not end properly; exit value:...

Multiple Subreports in Main Report using same datasource

jasper-reports,jaspersoft-studio
I have a main report with 2 subreports. I am using a custom datasource to fetch the report contents. But only one subreport gets displayed when the main report is previewed in jasper studio (whichever subreport comes first). For eg. only report1.jrxml gets displayed.If I remove that subreport then report2.jrxml...

Passing parameters to `In` clause

sql,jasper-reports,jaspersoft-studio
I am trying to pass parameters to Jasper report In clause. Below is what I tried in Jasper reports. SELECT * FROM `medication` WHERE $X{IN,idMeidication,$P!{parameter_name}} However it is keep on saying the parameter_name does not exists. If I convert my Jasper SQL to normal SQL, it will look like this...

Font embedded in main jasperreport but not in subreport when exporting to PDF

java,fonts,jasper-reports,ireport,jaspersoft-studio
When previewing my report in jasper studio everything looks fine, both mainreport and subreports use the correct font. Whenever I export the report to pdf it only displays the correct font in my main report and my header subreport. The footer subreport is using the standard font. The title in...

how to log mysql queries fired in jasper reports server?

jasper-reports,jasperserver,jaspersoft-studio
i have seen many results with same query in Google some i understood/tries and some not working and some suggests a solution which start from the middle. like this and tried this one made change in log4j.properties not working and this i have tried making those changes and saw catelina.out...

Jaspersoft - Can end user write data back to database?

sql,sql-server,jasper-reports,jasperserver,jaspersoft-studio
Is it possible to allow a Jasperreports/Jasperserver end user to write data back to the source database? For example, if a user is viewing a report that lists customer information, could the report be designed to allow the user to edit or write to a database field, such as a...

updating variable when passed into visualizejs method angularjs

javascript,angularjs,jaspersoft-studio,visualize
So what I want to do is show my loading directive when I clicked the generate button and hide the loading directive when the report is completed. Since visualize.js has a "reportCompleted" event I updated my fetching variable their as false to hide the loading directive. <button class="btn btn-default" data-ng-click="vm.generateReport(filter)">Generate</button>...

Jasper Report — Resource not found

php,jasper-reports,jasperserver,jaspersoft-studio
I am developing a jasper report in PHP I have tried embedded jasper library 0.9d -- PhpJasperLibrary-master After fixing part of the code in the library, It works normally but it cannot display table format which is very important for me to develop Jasper report so I give up in...

How to call a jasper report through REST_V2 service with a specification what dataSource from repository should be used?

jasper-reports,jaspersoft-studio
I have this scenario: Created a jasper report and uploaded to JasperSoft Server: "MyTestReport" Uploaded report does not have a link to dataSource in JSS In JasperSoft Server I have defined two datasources: AGD and AGL I would like to call report through "rest_v2" service from database. My URL to...

Is there a way to have a placeholder when select returns no rows?

sql,postgresql,jaspersoft-studio
I have a table, report_total, that contains calculated values for some of the total_types_cd (codes) but not necessarily all of them. If there is no corresponding row, I'd like to have a placeholder in the select such that the renamed total_amt (unitem_cntrib/total_contrib...) has a value of 0 and I always...