Jump to content
We've recently updated our Privacy Statement, available here ×

rajesh.sirsikar

Members
 View Profile  See their activity

  • Posts

    135

  • 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 rajesh.sirsikar

  1. rajesh.sirsikar
    Hi Raul, I have addressed your perticular problem in my blog http://www.rajeshsirsikar.com/creating-running-total-in-jaspersoft-studio/ Check it out !! Thanks, Rajesh Sirsikar
  2. rajesh.sirsikar
    Hi Bob, check my blog http://www.rajeshsirsikar.com/conditional-query-using-parameter-value-in-the-query-to-fetch-data/ you will get a better idea to resolve your issue. Thanks, Rajesh S
  3. rajesh.sirsikar
    Hi, The way to convert a date into unixtime stamp is (Day difference from the date to 01/01/1970) x 86400 = UnixTime Thanks, Rajesh S
  4. rajesh.sirsikar
    Hi, Changed a paranthesis position and it worked for me. Expression is (new SimpleDateFormat("'This report was generated on' EEEE, MMMM d, yyyy 'at' h:mm:ss a.").format(Calendar.getInstance().getTime()))
  5. rajesh.sirsikar
    Hi, I created the stacked bar the way you want it. But for which you need to change the dataset as follows Then the stacked bar will be as follows
  6. rajesh.sirsikar
    Hi, In the Outline window of Jaspersoft STudio, when you right click on the Group Nmae you will find the option to move down and up.
  7. rajesh.sirsikar
    What was the issue?? Did you have ignore pagination ticked???
  8. rajesh.sirsikar
    Hi, Please check my blog here http://www.rajeshsirsikar.com/jaspersoft-studio-ignore-pagination/ Hopefully this helps. Thanks Rajesh Sirsikar
  9. rajesh.sirsikar
    Hi Saikiran, After looking at your question, i worked on a possible solution and the result is here http://www.rajeshsirsikar.com/change-the-chart-axis-dynamically-jaspersoft-studio/ Thanks, Rajesh Sirsikar
  10. rajesh.sirsikar
    Hi there was a typo...it is www.rajeshsirsikar.com
  11. rajesh.sirsikar
    Ill come up with a blog on this soon...:)
  12. rajesh.sirsikar
    Hi, Its pretty simple. Use the below expression DATEFORMAT($F{ORDERDATE},"dd-MMM-yy") (Change teh date field to your field) and see teh magic :-) Regards Rajesh Sirsikar www.rajeshsirsika.com (for most of your jasper questions)
  13. rajesh.sirsikar
    Hi, Please check my blog http://www.rajeshsirsikar.com/increment-a-variable-in-jaspersoft-studio/ This will solve your issue. Thanks, Rajesh S
  14. rajesh.sirsikar
    Hi, Refer to this blog of mine where I have explained how to use multi axes chart to display bar chart and a line chart with values. http://www.rajeshsirsikar.com/display-total-on-each-column-of-stacked-bar-in-jaspersoft-direct-approach/ If you have further questions let me know in teh comment. Ill get back to you. Thanks Rajesh Sirsikar
  15. rajesh.sirsikar
    Hi, Please find the info here http://www.rajeshsirsikar.com/increment-a-variable-in-jaspersoft-studio/ www.rajeshsirsikar.com Rajesh
  16. rajesh.sirsikar
    Hi brggabat, Simplest way to achieve it is by creating two variables. Variable 1 will have the expression to find the current date : 2) Another Variable with Class as Integer with expression Rajesh www.rajeshsirsikar.com
  17. rajesh.sirsikar
    Hi, Refer to my blog http://www.rajeshsirsikar.com/how-to-create-a-sql-server-database-connection/ for detailed step by step approach for the same.
  18. rajesh.sirsikar
    Hi, Please check my blog http://www.rajeshsirsikar.com/conditional-query-using-parameter-value-in-the-query-to-fetch-data/ for the answer Rajesh SIrsikar
  19. rajesh.sirsikar
    Hi jndh9, The Best possible way to achieve what you are looking for is to create a parameter driven SQL to run your report. For detailed explanation, check my blog http://www.rajeshsirsikar.com/?p=286 Rajesh SIrsikar
  20. rajesh.sirsikar
    Hi Anshul, I am assuming here that you already have a report which has a Variable which Calculates the Total of a column. 1) edit the Variable Expression and add something like this.(Here I have created a report with Sample DB in Jaspersoft Studio and created a Group on SHIPCOUNTRY. and then dragged the column TOTALORDER variable on to Group footer and selected Sum as my calculation, this created a variable TOTALORDERS1. and I Manually created TOTALORDER2 and added the below expression) IF(EQUALS($F{SHIPCOUNTRY},"Argentina"),SUM($V{TOTALORDERS1}.doubleValue(),100),$V{TOTALORDERS1}.doubleValue()) Now For further explanation. Check the Report here. https://www.dropbox.com/s/atidrkzvjuo2sds/ColumnsOnASumCondtion.rar Thanks, Rajesh Sirsikar For more tips tricks check http://www.rajeshsirsikar.com
  21. rajesh.sirsikar
    Hi Sreeni, Check this http://www.rajeshsirsikar.com/?p=286 Thanks, Rajesh S
  22. rajesh.sirsikar
    Hi maine, If you are checking the chart for the data between 01 Jul 2014 to 05 Jul 2014 (As mentioned in your example), then using " will fetch you record for only one week and hence one dot. I am just thinking aloud here. Try Changing to then you shd get 5 Dots for 5 days data.
  23. rajesh.sirsikar
    Hi Maine, As per your description, I created the scenario for my testing and got it confirmed that the problem for your issue is that you have placed your Chart in the Detail section of the report. Charts Must be kept either in the Title Bar or in the Summary Bar. In your case place it in teh Summary Bar and you will see the issue getting resolved in seconds. Thanks, Rajesh S
  24. rajesh.sirsikar
    Hi Ram15, Please check my blog http://www.rajeshsirsikar.com/?p=272 for detailed explanation of how to use Multi Select Parameter in jasper studio. Thanks Rajesh S
  25. rajesh.sirsikar
    Hi pluralprnoun Please check my blog on how to create and implement subreports from main report. http://www.rajeshsirsikar.com/?p=329 Basically you need to have the query in your main report to enter the parameter values. If your answers are not answered from my blog, please let me know, I will help you out.
×
×
  • Create New...

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

Products

Explore