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
-
Hi Folks, Do you know how to store the SQL results in to a Collection? For example, a SQL query returned a column named "City", the column values are "Memphis", "Seattle", "Bankok", how can I store these values in a Collection object like Parameters, Variables ? Thank you D
-
spring5已取消JasperReportsViewResolver和JasperReportsMultiFormatView有什么替代方案吗
riodavid replied to 3179352025's topic in Products
I don't know. But maybe you can join our QQ group 871048119 for Jasper discussion -
Hi Folks, I tried to print html symol in my report, for example - "↑" If I export the report to excel or word, it will be printed correctly as well. But if I export it to PDF, it can not be printed, an empty space will be left there. Do you have any idea how to fix this problem? Thank you D
-
What is your query?
-
Hi Folks, When I print the alt codes (for example ▲▼ ↑ ↓ ) to report, they are printing correctly. If I export the report to excel or word, they will be printed correctly as well. But if I export it to PDF, it can not be printed, an empty space will be left there. Do you have any idea how to fix this problem? Thank you D
-
Hi Hozawa, thanks for responding. Can you be more specific on fonts? Is that mean I need to download a font, upload it to Jasperserver, and use it?
-
Hi Guys, Please check my screenshot, is it possible to add indicator like this? In fact I have implemented it by conditionally displaying images. But when export the report to xlsx the display in Excel is terrible. Do you have any better idea to achieve this? BR Dawei
-
No. Studio is a developer faced program. The ultimate destination for the reports is Jasper server. There you will be able to create drop down input controls (filters)
-
Wait... are you answering your own question?
-
$V{Bool}.equals(false) BTW join Chinese Jasper QQ group 871048119, if you are intrested
-
" I want to be the same height as the detail. " So first you have to set your shape height the same as the detail height.
-
The final result can be look like this, fyr
-
Outline -> Right click report name -> Create Group -> Next -> Select "Add the Group Footer" only -> Finish Now you got a Group Footer, put your table in it. The Page Footer will be placed beneath Group Footer.
-
Hi Yinfeng, You can't directly "get" the value of the total page number. I guess you are trying to use the total page number as a Print When condition? If that's the case, there's a imperfect workaround... BTW I have created a QQ group for Chinese Jasper developers, join 871048119 if you are intrested.
-
Rectangle -> Appearance -> Size -> Stretch Type -> Relative To Band Height
-
Why not give the table a header and put your description in?
-
@rstuart Thanks! It works like a charm!
-
Report showing data from Jasper studio but not showing in Jasper server
riodavid replied to gopalb1983's topic in Products
In Jasper report, Detail Band will be printed as many times as the rows returned from the main dataset. We may leverage this feature to achieve what you want. 1. Create a Parameter [PrintTimes], type Integer. 2. In the Main Dataset, write "select top $P!{PrintTimes} * from table_name". 3. Put the text you want to repeat in the Detail Band. Below screenshot is what I got: https://postimg.cc/zy8XDN4G Note, because "Select Top" clause only works for SQLServer, you may need to change it to something that return x rows from your database. For example, in Oracle you may need to use the row number way instead. -
Unfortunately the pattern is from java.text.DecimalFormat class. Fortunately you don't have to learn java to understand the pattern part of it. https://docs.oracle.com/javase/7/docs/api/java/text/DecimalFormat.html
-
I'm not sure if it is a valid cascading input control query cause you used "$P{}". I haven't tried that yet. But usually we use $X{} to pass the parent value to child in a cascading input control.
-
Not the row header.
-
Do not filter on Date, filter on the "A,B,C" column.
-
Filter the null record out in your dataset query.
-
Hi Jahn, have you checked my screenshot in previous comments? I don't see the difference between my screenshot and your result.
-
In m sample table above, "Family-1", "Family-2", "Family-3" use the same fields [family] of the table [test_qa]. Sorry, maybe I didn't understand it correctly?
