Jump to content
Changes to the Jaspersoft community edition download ×

Ankur Gupta

Members
 View Profile  See their activity

  • Posts

    343

  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Everything posted by Ankur Gupta

  1. Ankur Gupta
    Hi George. The best way is to use the Jaspersoft Studio, but if the sole pupose is just to look at the SQL behind the reports, you can simply edit the JRXML in the Notepad or any text editor and simply look for the tag <queryString> you will find the query directly Hope that this helps. Thankyou, Ankur Gupta TIBCO Certified Jaspersoft
  2. Ankur Gupta
    Hi Folks, I am trying to send email via REST API v2, using the community Jasperserver 7.8.0. I an using postmant to test the request, the JSON request is as below. - I am hitting the REST API endpoint jobs https://localhost:8443/jasperserver/rest_v2/jobs/ The error which I get is - serialization.errorThere was an error on the server. Try again or contact site administrators. Any thoughts on this, maybe I have missed something in the request creation. Thanks Ankur Gupta
  3. Ankur Gupta
    Hi daniels, Can you please let me know what setting you have to do on the server side to make this work, been stuck at the same issue. Thankyou, Ankur Gupta
  4. Ankur Gupta
    Hey Miictog, I think you should definitely move up to Jaspersoft Studio. Jaspersoft have ended development of any further enhancements over iReport 5.6.0, so I think you should be moving to Jaspersoft Studio, as there are tons of new features. There is a community edition as well, so will compliment your model. Hope that this helps. Thanks Ankur
  5. Ankur Gupta
    Hey jin_wq, You can get the dynamic adjustment by selecting the 2 options in the properties as marked in yellow in the attached screenshot. 1. Select the drop down Stretch Type and set it to RelativeToTallestObject- This will increase the height of the Text Field dynamically based upon the data, This Mimics the word wrap functionality as in Excel 2. Check the box Stretch with Overflow- What it does is tells Jasper if the data overflows it will stretch the text field Thanks Hope that this helps Ankur Gupta
  6. Ankur Gupta
    Hey, Do you want to wrap the Text or just increase or decrease the height dynamically. Please if you can elaborate the usage.
  7. Ankur Gupta
    Hey, You should use the crosstab element to produce the desired output. Where you need to define following- Dataset - Main Report Dataset/ Defined Dataset(Whichever produces the data) Column - Month, Cost Type Row - Dept Measures - Amount (Select No Calculation) Creating this element would definitely give you the desired result. Also remember not to put the crosstab in the detail section it should reside in Summary Section. Hope that this helps Thanks Ankur
  8. Ankur Gupta
    Hi Christopher, I tried the code you have pasted, what I can see the issue is that there is not enough space to squezze the amount of data being printed in that band, I would suggest try couple of things 1. Try increasing the height of the Group Footer Band 2. There is property called Keep Together in the advanced Properties in the Footer Band Property, make it true which is currently false- this should work. Let me know if this helps. Thanks Ankur Gupta
  9. Ankur Gupta
    Please enlighten us with your take on the question, so that it helps the community!!
  10. Ankur Gupta
    Hi, Can you please describe the process you are using for the export, for more precise understanding.
  11. Ankur Gupta
    Hi, I am using Jasperserver Commerical edition and Jaspersoft Studio professional edition, the issue I am facing currently is that in my report I am using Series line chart and there is a requirement of datalabels for the end points of each series. Things which I have already tried are - 1. Using the datalabel option under plotoptions and if I set it as TRUE then I am getting datalabels for all the points which is not needed. 2. I have tried using a javascript callback function in the datalabel formatter but it did not worked. Please let me know if there is a way to achive it. Thing I am trying to achieve is Hoping fo a speedy reply. Thanks, Ankur Gupta ankur.gupta.aug@gmail.com
  12. Ankur Gupta
    Hey, Splitting of the summary band is not possible, columns only split the detail band. The workaround for this would be that you can use 1 subreport and have selective data in each of the main report and subreport to form a column like structure and have the summary in one and dont have in one. Hope that this helps. Thanks. Ankur gupta http://ankurthetechie.blogspot.in/
  13. Ankur Gupta
    Hi , Reading your complete explanation, please follow the steps to create a desired output. 1. Create group based on the Store id 2. inside group header place the bar chart, and go the properties of the chart and in the tab chart plot you can find the property Orientation and set it to Horizontal 3. In the chart have two series, Bathroom and Kitchen, of which you have values directly so the plot can be directly created. 4. The format which you have created in the jrxml you can directly paste that into your detail band. So in this way each record of your query will be acting as one group. Hope that this helps. Cheers!! Thanks Ankur Gupta http://ankurthetechie.blogspot.in/
  14. Ankur Gupta
    Hey, The solution suggested by robsil would actually work upto the extent when all the data in a particular column in excel does not exceed the width alloted. But in order to make your excel full proof and the flawless, I would suggest that you can follow these things. 1. Make sure that all the text fields in the detail band have the height same to each of them preferred in case of excel only output. 2. To apply the the word wrap functionality you will have to make following properties true found in the property pane. - Stretch Type (found under appearance) for all the text feilds in the detail band should be made Relative to the tallest object, so that all the fields stretch according to max width column so that uniformity prevails. - Check the box Stretch with overflow (found under the text field in properties) , this will ensure that all the data in the text field gets printed. Hope that this helps!! Thanks Ankur Gupta www.reportlingo.com http://ankurthetechie.blogspot.in/
  15. Ankur Gupta
    Hey, you are probably on a correct path, just remember that new java.util.date() gives the current system time or in your case the phone server time that is why you are getting a vague formatted date. wgat you can do us that that create one mor parameter for the current date and via php code pass the current date and keep the parameter instead of the java expression inside ireport try try this out this should work my email id is ankur.gupta.aug@gmail.com cheers !! ankur gupta
  16. Ankur Gupta
    Hey, Please make sure- 1. That you have provided the correct path of the the previously installed tomcat. 2. Once the installation completes verify that the folder of jaspeserver-pro is created under the weapps folder in tomcat. 3. Please do restart your tomcat post installation. Thanks, Ankur Gupta
  17. Ankur Gupta
    Hey, The solution to your issues are- 1. Related to show today's date into desired format, once you are creating reports in iReport, you can simply write this expression to get this date 10 April 2017 new SimpleDateFormat("dd mmm yyyy").format(new Date()) As soon as you have this expression in report, then this expression will give you the desired results. 2. Related to the second issue, you can use the number formatter. For instance if you do not want any decimal place, then either you can set a feild expression as ### or you can set it through a decimal format .for example new DecimalFormat("###").format(expresssion) Hope this helps. Thanks, Ankur Gupta
  18. Ankur Gupta
    Hi, I have used Jaspersoft Commercial edition. I have created a report in Jaspersoft Studio, and published it on server and used it to create a Dashboard. It is a pretty straight forward report with few image links and a table structure. The issue which I am facing is that when I try to run the dashboard in Google Chrome, then on the first load the dashboard runs fine and loads up everything, but then when I try to apply the filters on the dashboard then I am facing issue of infinite loading. I tried to check what the issue was in Dashboard, I found the issue in jive.js file and the error was - jive.js:1 Uncaught TypeError: o.remove is not a function What is strange is that, if I try to the standalone report on server not in dashboard then everything his working absolutely fine. If I am trying to run the same report in other browsers, like Safari and Firefox then everything is running fine. Can you please help to resolve the issue. Regards,Ankur Gupta
  19. Ankur Gupta
    Hello Everyone, I have a query regarding the euro sign (€) used in PDF Export I am unable to see the sign there all I can see is that instead of Euro sign i get a [] . I have tried several ways, by creating a font and supplying the PDF encoding as CP1252 (Western European ANSI aka WinAnsi) Also added the Jar of the font in the classpath but no luck. Also I have added two report properties. net.sf.jasperreports.default.pdf.encoding - as - Cp1250 net.sf.jasperreports.export.character.encoding - as- ISO-8859-15 I can obtain the correct Euro sign in XLS export, but PDF is still not producing. Can anyone please tell me what I am missing out. Thanks and Regards, Ankur gupta
  20. Ankur Gupta
    This is an error which you get while exporting the data from the Jasperserver in the Excel Format. Something of this sort http://1.bp.blogspot.com/-pUPBuM1JEu4/VdLOg0ImrcI/AAAAAAAAHzM/pisrJx5k47g/s400/image.png For resolving this you should check some of these errors: 1. Number to string cast exception: This means that a number is wrongly appended to a string in which wrongly cast number into string. In order to fix this, you will have to use the command as new DecimalFormat("##,#0.00").format(number).toString() This will cast your number into two decimal places with the thousand separator. 2. Another error that can be checked is of any other cast errors, or formatting of the data in the report. Cheers!!
  21. Ankur Gupta
    Hey, Have you tried using a crosstab, I think that will serve the purpose you need. Hope that this helps. Thanks Ankur Gupta
  22. Ankur Gupta
    http://i.ytimg.com/vi/UKY3scPIMd8/0.jpghttps://youtube.com/devicesupport https://youtube.com/devicesupporthttp://m.youtube.comFrom:YouTube HelpViews:33749260http://gdata.youtube.com/static/images/icn_star_empty_11x11.gif http://gdata.youtube.com/static/images/icn_star_empty_11x11.gif http://gdata.youtube.com/static/images/icn_star_empty_11x11.gif http://gdata.youtube.com/static/images/icn_star_empty_11x11.gif http://gdata.youtube.com/static/images/icn_star_empty_11x11.gif0ratingsTime:03:56More inHowto & Style
  23. Ankur Gupta
    http://i.ytimg.com/vi/AzwVeCyq-UA/0.jpgTutorial to implement Portrait and Landscape orientation in a Single Jasper Report This video will enable you to use different orientations that is Landscape/Portrait or Horizontal/Vertical layout of data in jasper report.You can follow me on - Twitter Handle -- @ankur_augFacebook - https://www.facebook.com/ankur10augLinked IN - http://www.linkedin.com/pub/ankur-gupta/51/895/910 Blog - www.ankurthetechie.blogspot.inG+ - https://plus.google.com/116451164261752827176You can view my Jasper Community Profile - http://community.jaspersoft.com/users/ankur-guptaFrom:Ankur GuptaViews:4385http://gdata.youtube.com/static/images/icn_star_full_11x11.gif http://gdata.youtube.com/static/images/icn_star_full_11x11.gif http://gdata.youtube.com/static/images/icn_star_full_11x11.gif http://gdata.youtube.com/static/images/icn_star_empty_11x11.gif http://gdata.youtube.com/static/images/icn_star_empty_11x11.gif12ratingsTime:08:27More inScience & Technology
  24. Ankur Gupta
    I managed to fix the lnux machine problem by one of the links you mentioned, basically it was related to physical memory Jasperserver 6.0.1 won't run on 1 GB So linux issue resolved , though Mac issue is still intact. I am using Mac 10.10 and error comes in post installation step.
  25. Ankur Gupta
    Hi, Can someone help me in the problem I am facing in the installtion of the Jasperserver 6.0.1 in linux and Mac The exact error I am getting is Warning: Problem running post-install step. Installation may not complete correctly Error running /opt/jasperreports-server-cp-6.0.1/apache-ant/bin/ant import-ce -DimportFile=install_resources/export/js-catalog : BUILD FAILED/opt/jasperreports-server-cp-6.0.1/buildomatic/bin/import-export.xml:262: The following error occurred while executing this line:/opt/jasperreports-server-cp-6.0.1/buildomatic/bin/import-export.xml:158: Java returned: 137 Please help. ThanksAnkur Gupta
×
×
  • Create New...

© 2024 Cloud Software Group,
Inc. All rights reserved.

Products

Explore