m.kamran

Hi pong, This will sure help, https://community.jaspersoft.com/wiki/custom-font-font-extension Just recently implemented adding a custom font to my reports in jasper studio and then on jasper server. Thanks.

I see, would it be possible for you to please share your jrxml? Thanks.

Hi, Can you please explain your problem in more detail since I am unable to figure out what you are trying to achieve? Thanks.

I think this problem usually arises because of the use of a custom font, I have experienced the same using a standard font and a custom font both for the same report and the custom font text shows, disppears and then re-appears. Can you please try using a standard font and see if the problem happens again on the same report? Thanks.

You either need to optimize your query so it returns data in less than a minute (recommended solution) or increase the timeout in your MarkLogic server.

Hi dia, Not entirely sure if it would work in case of multiple labels on the same axis but the "rotation" properties are worth a try, please check the following, https://community.jaspersoft.com/wiki/advanced-chart-formatting Hope this helps.

Hi, You can handle this all within the query so no need to add any additional expressions. e.g. for parameter name $P{dept}, you can do this in your query, select * from company where dept = ISNULL($P{dept},dept) This will take value from your input and if it is null it is going to return you all records excluding null records. Hope this helps.

Hi Nitesh, Most probably it is your antivirus blocking it, can you please disable the av software and then try launching studio? Thanks.

Hi, If you are looking for a solution while only working within Jasper Server, here is what you would do, - add a column to your resultset which refers to the parameter values, e.g. If you want to select data for country 'UK', you can add a column with heading 'Country' with all possible values in it (coming from DB possibly) - add a filter operating on this column The limitation here is that Jasper Server does not allow filters for non-existing data in the resulting report/ad hoc view so you would need to make the relevant column part of the resultset. Alternatively, if you do not want the 'Country' column added and yet want data filtered by country, you can use Jasper Studio to create the report and then upload to Jasper Server. JStudio will allow you to add an external parameter not bothering about if its relevant column exists in the report or not. Hope this helps.

Hi dia, I do not think that would be possible since the input controls are a way to capture filter value for a field already part of the ad hoc view, measures work on top of the available fields and therefore cannot be bound to an input control, hope this helps. Thanks.

Hi, If you can embed jasper reports application within your web app via external authentication, you can expose the complete dashboard designer view which should allow users to drag and drop ad hoc views and reports. Please make sure you use the correct user roles for authentication. Hope this helps. Thanks. P.S. Apologies I have not tried the AWS version yet.

Thanks, my mistake :).

Hi brandon, If I understand your question correctly, calling a report URL (with params) from a web-page is similar to calling a report from another report poiting to a URL. From your web page, you can add your parameter to the URL and use it within your jasper report, i.e. Target URL: [your_jasper_server]/[report]?param1=test In your jasper report, please have a parameter created named param1 (to match the parameter on URL) and it should be able to pick the given value 'test' which will act as a filter value. Please make sure you uncheck "Is For Prompting" from your parameter settings in Jasper for obvious reasons. Hope this helps. Thanks.

Hi, This should help, http://www.rgagnon.com/javadetails/java-0426.html Thanks.

Can you please share the query you have used?

Hi samara, HTML5 charts are only available in the commercial edition. Thanks.

Usually that happens when you do not have required rights/permissions to access the target database. Can you try connecting to the database via any client appliciation?

Hi Frank, I set it up some time ago so cannot remember much but one thing is for sure, you do not have any issues with jasper in this case, you will have to fiddle with nginx to make it work. I would suggest the following to rule certain out certain possibilities, - point to google rather than jasper and see if you can reach it (if you can't you know it's nginx issue) - assuming you have both nginx and tomcat on the same server, try reaching jasper via browser on the same server (this will definintely get you to the core of the issue) - try accessing jasper directly on port 8080 form the browser on the same server to ensure it is up and running Thanks.

Hi Samara, You do not need to upload the resource separately. I understand the appraoch you have tried should have worked ideally but the actual solution is to upload the image along with the report. Please note when you export the report, you would see the cherry image on the list as well, please select that too. For subsequent report uploads, you would always have to set the report resources to "overwrite" because if you do not, jasper assumes the report does not need the resource anymore and breaks, hope it helps. Thanks.

Issue happening trying to open commercial platform report on community version, resolved.

Hi Tisha, This won't be possible while just staying within jasper since reports do not allow dynamic input except for parameters but even the input parameter would show up as a prompt and once per report and not per row. What you need is possible but needs a lot of tweaking and adjustment. Perhaps the most likely approach (as suggested by joseng62) is to use visualize.js, pull in all report resources, controls and ouput and then attach a text-box to each row. And if you are working within a CMS to integrate Jasper reports, making use of iframe elements and adjusting the input component could be another way to go but again it wonn't be a quick job. Thanks.

Hi ferguson, Please GROUP BY ACT_ACTION and it should be okay, hope this helps. Thanks.

Hi Gonzalo, You are right, please convert it into decimal rather than integer. Presumably it crashes because PDF export has a separate logic than report rendering and in your case the former is working while the latter does not. To cover both scenarios, please convert value to decimal and it should be okay. Also, please make sure the string value being converted has been trimmed already. Hope this helps. Thanks.

Hi mariyam, You can achieve this using UNION in your SQL query, i.e. Get deparment count for BASIC UNION Get deparment count for HRA . . . Hope this helps.

Hi Justin, Of course you should be using a number data type for such comparisions. Use Integer, Decimal etc. depending on the type of data you are expecting. Thanks.