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

luked

Members
 View Profile  See their activity

  • Posts

    49

  • 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 luked

  1. luked
    Have you tried enclosing your case inside a parentheses?
  2. luked
    Have you tried creating a new style? Click on the style field in the report outline and create a new style, then once you have created that, right click on that new style and create and conditional style. In there you can put in an expression to make the field bold. then in your report text field in the properties window you can select the style you created.
  3. luked
    Have you tried making a style. In your outline under styles right click and ad new style. In the properties of that syle change it to the font you would like. Then go to the text field on your report which you want to have that font and in the style tab select the style you created.
  4. luked
    You could try adding this into a text field - new SimpleDateFormat("dd-MM-yyyy HH:mm").format($V{Your Variable})
  5. luked
    You should be able to select what you want in the group header section. You said you have got a group called headlines. You can create the group header (if you have not already) and in that band properties you can choose to start new page, reprint header on each page.
  6. luked
    It looks like you have placed your static text in the group band of your report. You can add a column header or page header and place your static text (Director, Favor, Percentage) in one of those bands.
  7. luked
    You can try using new date - new Date(new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss").parse(dateField))
  8. luked
    Have you tried converting your date format in your SQL query? I use the below in Oracle - cast(iuv.time_out as date) betwen to_date($P{START DATE}, 'YYYYMMDD') and to_date($P{END DATE}, 'YYYYMMDD')
  9. luked
    Morning, You can try ticking the remove line when blank box in SF{COUNTRY}.
  10. luked
    Morning, without seeing your entire report all I can say is check the order of your variables, as ireport will calculate them in that order. Hope this helps.
  11. luked
    Hi there, Sorry I am unable to see your attachment. Can you try using a print when expression, for example print when $V{ANIMALS_MEASURE}>=1.
  12. luked
    Morning, 2 ways you can try. 1 is to change the formatting of the date in the textfield as per attached picture. 2 is try the following - $F{signDate}.substring($F{signDate}.length() - 2)
  13. luked
    Hi there, Have you tried formatting your Oracle date select to_char(date_column,'dd.mm.yyyy') from table;
  14. luked
    Hi there, You can try the following - java.lang.Double.valueOf($F{YourString})
  15. luked
    Hi there, I had a similar situation where I needed the report to return the previous month. What I did was create a date parameter and then a second parameter which i have - DateUtils.addMonths($P{Date},-1) as the expression. Hope this can help you out.
  16. luked
    Hi there, When I have columns and rows in a crosstab I don't want visible I change the width or height of that row column to hide it from the resulted crosstab.'This might help you in your scenario.
  17. luked
    Morning, have you tried using the report count variable and then selecting average as the calculation?
  18. luked
    If you right click the cell on your report you have an option of order where you can bring to front etc. Have you tried this?
  19. luked
    Hi there, In your text field Properties/Text Field you can select the Pattern, this will allow you to choose which date format you would like the text field to reutrn.
  20. luked
    Hi there, Sounds like you need to create a variable, below is the link to the Wiki - https://community.jaspersoft.com/wiki/variables When you crate the variable you can have the option in the Calculation field to have count or sum etc. So for example you can create a variable with the Expression - Boolean.valueOf($F{your field goes here}.contains ("closed") ? 1 : 0 This will give your field a value of 1 if it contains closed. Its hard to give an indepth example with what information you have given but hopefully this can point you in the right direction.
  21. luked
    In the Palette there is a compostie element called current date. You can add this to your report as a text field and it will populate with the current date - new java.util.Date().
  22. luked
    As gustavofarias stated above if you have a variable with a calculation you must ensure this is at the botom of your variable list as variables will be calulated in the order they are placed.
  23. luked
    Try substring, $F{yourfieldgoeshere}.substring($F{yourfieldgoeshere}.length() - 6) Regards Luke
  24. luked
    Try the below, What it does is when the st_ctry_name is not Switserland and the seller is RET1 then return TEST MESSAGE else " " blank. (!(Boolean.valueOf($F{st_ctry_name}.equals ("Switserland")) && Boolean.valueOf($F{seller}.equals ("RET1")))) ? "TEST MESSAGE" : " " Regards Luke
  25. luked
    Double check you are opening the file saved in the MyReports folder C:UsersxxxJaspersoftWorkspaceMyReports. You can always look at the details of the file and check the timestamp to ensure it is the latest one.
×
×
  • Create New...

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

Products

Explore