[How to Store the SQL Result into a Collection?]

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有什么替代方案吗]

I don't know. But maybe you can join our QQ group 871048119 for Jasper discussion

[Export HTML Symol to PDF?]

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

[Error UID: cf09f306-69c2-4005-83b6-d34ddf7a71f3]

What is your query?

[Export Alt Codes to PDF]

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

[Is It Possible to Create KPI Indicators in Table?]

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?

[Is It Possible to Create KPI Indicators in Table?]

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

[Drop down filters]

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)

[When will the Enterprise version of JasperReports IO be released?]

Wait... are you answering your own question? 

[how to judge the values in crosstab ?]

$V{Bool}.equals(false)

BTW join Chinese Jasper QQ group 871048119, if you are intrested

[Shape size]

" 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.

[Tables and Captions/Labels]

The final result can be look like this, fyr

[Table data repeating in the report when placed in Detail Band?]

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.

[How do I get the total page number variable?]

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.

[Shape size]

Rectangle -> Appearance -> Size -> Stretch Type -> Relative To Band Height

[Tables and Captions/Labels]

Why not give the table a header and put your description in?

[Change the Format of "Date Refreshed"]

@rstuart

Thanks! It works like a charm!

[Report showing data from Jasper studio but not showing in Jasper server]

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.

[How can we write pattern in Text field?]

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

[Multi select query shows only one row]

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.

 

[Suppress a blank row in Cross tab]

Filter the null record out in your dataset query.

Not the row header.

[Suppress a blank row in Cross tab]

Do not filter on Date, filter on the "A,B,C" column.

[Suppress a blank row in Cross tab]

Filter the null record out in your dataset query.

[How to display answers of other family members on column-2, column-3, and column-4 on the right side of the column-1?]

Hi Jahn, have you checked my screenshot in previous comments? I don't see the difference between my screenshot and your result.

[How to display answers of other family members on column-2, column-3, and column-4 on the right side of the column-1?]

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?