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

riodavid

Members
 View Profile  See their activity

  • Posts

    179

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

  1. riodavid
    I'm not sure "Setting Layouts to Horizontal Layout" will help. Theoritically, it will generate: John Doe01.01.2001 Carpenter Jane Doe01.01.2001 Clerk The best way in my mind is to pivot your select result in SQL, then display it in a normal Jasper table.
  2. riodavid
    Sorry I can't reproduce your issue.
  3. riodavid
    Set Report Property [net.sf.jasperreports.export.xls.detect.cell.type] to [true]
  4. riodavid
    Table -> Appearance -> Location -> Position Type -> Float
  5. riodavid
    "And when I do place the subreports in other sections of the main report, as the posts suggest, the other bands can't accommodate data run-on so it throws and error and that doesn't work. " What error do you got?
  6. riodavid
    Sorry, this is hard to achieve.
  7. riodavid
    Has anyone tried method from @jjcapa? Is it working? I got null values only.
  8. riodavid
    For variable $V{PAGE_NUMBER}: - Set the [Evaluation Time] to [Report] to get the total pages - Set the [Evaluation Time] to [Now] to get current page
  9. riodavid
    What's the information in Details?
  10. riodavid
    Thank you Hozawa. Following your previous advice in https://community.jaspersoft.com/questions/1099816/strange-formating-excel-and-doc, I have set the net.sf.jasperreports.export.xls.remove.empty.space.between.rows setting to true. But the result is what we see in the screenshot - format is still not consistent.
  11. riodavid
    Root cause found, elements were covered by elements. https://postimg.cc/image/55upabtsd/
  12. riodavid
    Hi Folks, I designed a report. In studio if I export it to xlsx format, everything's fine. But if I publish it to the server, and export it to xlsx format from the browser, the format will be changed. Please check the screenshot: https://postimg.cc/image/no7bj57u5/ Jasper Jasper... Any ideas? BR D
  13. riodavid
    @Hozawa Thanks for the sharing. Are these "xls" properties also working for xlsx too?
  14. riodavid
    Hi folks, I have a crosstab report which looks beautiful in html. But if I download it to excel or doc, the format becomes ugly, lots of things are missing. Please check the screenshot:https://postimg.cc/image/uhxcx0tm5/ Do you have any idea why it happens? BR D
  15. riodavid
    I will be happy if some one tells me it's not possible
  16. riodavid
    Hi Folks, Let's say there's a $V{Value_1} in cell A. I want the font color turn to red if the value is below 0. It's easy to set the conditional formatting on it, just create a expression of "$V{Value_1} < 0". But if I have multiple cells that contains multiple values $V{Value_2}, $V{Value_3}... $V{Value_n}, to implement conditional formatting, I have to create the expression for each of them. Is there an easy way, just read the cell values rather than variable values, and decide which formatting to choose? Thank you D
  17. riodavid
    Can you give some sample data of this Scan_timestamp (uint) column?
  18. riodavid
    The internal function SUBSTITUTE works for me. SUBSTITUTE($V{A_DECIMAL_NUMBER}.toString(),".",",")
  19. riodavid
    What is the Class of $P{cal}?
  20. riodavid
    You can use the image uploding website to upload screenshots. Here's a screenshot of my Jaspersoft Studio 6.4.2 https://postimg.cc/image/xt5bkmksn/
  21. riodavid
    I'm here. But can you paste your jrxml file?
  22. riodavid
    Hi mcgovardhan, if i have 5 clients, when i ran my report it should generate 5 reports [/code]Sorry I don't know how to do this. Only 1 report can be generated each time. Error executing SQL statement for .....[/code]Seems you were meeting errors with the [P_Where]. You can print the [P_Where] in your report, and see what's in it, if it is a valid query.
  23. riodavid
    Create a parameter, publish the report with the parameter to the server.
  24. riodavid
    Default: new java.util.Date()
  25. riodavid
    Hi Zonglin, "I tried to replace the UUIDs in my reports with some other random generated UUIDs, the report works fine. "
×
×
  • Create New...

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

Products

Explore