riodavid
-
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
-
I think his suggestion in the last post is OK. Create a parameter to limit the number of rows. Hide this parameter, and give a small number to it as default. When the user runs the report in browser, it will be generated quickly. When the user wants to see the full data in excel, use the schedule functionality, and input a large number for this parameter instead.
-
Use this in your tooltip expression: org.springframework.util.StringUtils.collectionToDelimitedString($P{City},",")
-
What do you mean by "Broken"? Can you paste a screenshot?
-
Hi Folks, Is it possible to use java methods that returns voids? For example, I have a variable of type date, I want to change the timezone of it. In java code I'm able to use setTimeZone, it changes the timezone of that SimpleDateFormat class "isoFormat". SimpleDateFormat isoFormat = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss");isoFormat.setTimeZone(TimeZone.getTimeZone("UTC"));Date date = isoFormat.parse("2010-05-23T09:01:02"); But this method returns void, means I can't directly implement it in Jasper variable. Is there any alternative to do it? Thank youD
-
I noticed you put "Table" in the table columns. Is this design for any special purposes? If not, change these "Table" to "Text Field". https://ibb.co/gf71dy
-
If it's the "Table" elements, the cells of each row should match height. Is your "Table" created by combining multiple textfields?
-
Table -> Appearance -> Location -> Position Type -> Float
-
Hi Gregg, You can implement the manual sort in your query like this: SELECT 3 AS 'VALUE', 1 AS 'SORT' UNION SELECT 4 AS 'VALUE', 2 AS 'SORT' UNION SELECT 1 AS 'VALUE', 3 AS 'SORT' UNION SELECT 5 AS 'VALUE', 4 AS 'SORT' UNION SELECT 2 AS 'VALUE', 5 AS 'SORT'
-
I guess you want to export it to .csv?
-
Hi Jcordingley, java.sql.Time extends java.util.Date. You can't "Sum" Date in Java. But you can sum seconds. Convert the time values to seconds, sum them, then convert the result back. BR D
-
Hi Gregg, Use Query instead of List of Values. Then sort the list in your SQL query. BR D
-
Good to know you did it!
-
I think you can re-write the logic of the 2nd parameter to SQL, and implement it in Input Control. That's how cascading input control works.
-
Storing query and database connection in JRXML using iReport
riodavid replied to hanidraidi's topic in Products
If you publish your report to the server, and export the report file, you will get a zip file. In this zip file you can find a separate xml file defining the data source. Data source won't be stored in the main.jrxml file. -
Usually I will search the number "30" to locate this height of detail setting. It ain't easy sometimes, but just give a lil patience.
-
Looks like a timezone issue. Print you where clause in report to see what happens.
-
Or you can paste a screenshot.
-
Group footer field not printing when overflowing
riodavid replied to christopher.astles's topic in Products
OK. Looks like you have put many expressions(some of the expressions are totally identical?) at the same place, it may cause over lap issue. Try put one textfield only. Float should be the right option. -
Ah, I understand your concerns. Try set the [Evaluation Time] of the variable text field to [Group], rather than [Now], you will see magic happens.
-
Thanks, Hozawa, I'm using Jaspersof Studio Professional 6.3.0 final
-
Not sure if it will work, but try footer section.
-
Hi Jeremy, I tried on my side yes it's almost impossible to achieve.But one workaround works for me. 1. Set the group header cell height to 1. (It have to be 1, not 0. If it's 0 then it will disappear.) 2. Set the group header text expression to IF($F{your_amount} == 0,"",CHAR(13) + $F{Group_Header} + CHAR(13)) CHAR(13) is the space that makes the final display more beautiful. 3. Set the group header text "Stretch With Overflow" to true. The mechanism behind, is to display every header as a 1 pixel height cell, which is almost invisble. If there're values, the 1 pixel will be streched, so values can be seen. Hope it helps. BR D
-
Try to add borders to cells, not text fields.
-
Group footer field not printing when overflowing
riodavid replied to christopher.astles's topic in Products
Hi Chris, I noticed you set [completed analyses] field to be [fixed relative to top]. You should set it to [float]. BR D -
As far as I know, Jasper does not support that. An expert called Mariano of this forum told me it can be achieved by scriptlet. But no further details.
