java example exception in viewer.jsp

Stimulsoft Reports.JAVA discussion
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: java example exception in viewer.jsp

Post by Alex K. »

Hello

We are always glad to help you!
Please let us know if you need any additional help.

Thank you.
xiaohaoxifei
Posts: 34
Joined: Mon Sep 18, 2017 6:07 am

Re: java example exception in viewer.jsp

Post by xiaohaoxifei »

Aleksey wrote:Hello

We are always glad to help you!
Please let us know if you need any additional help.

Thank you.
1, I've noticed that the viewer page fetch all data defined by the sql. I think in case the data amount is huge, the loading procedure should be very long and that's not acceptable for the customer. Is there a way to solve this? Can we retrieve the data from DB every time for per page display?

2, Where could we found some beautiful .mrt template files?

Thanks.
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: java example exception in viewer.jsp

Post by Alex K. »

Hello,

> Can we retrieve the data from DB every time for per page display?

Unfortunately, this feature is not available in Java product.

> 2, Where could we found some beautiful .mrt template files?

You can find sample reports in our demo from installation pack.

Thank you.
xiaohaoxifei
Posts: 34
Joined: Mon Sep 18, 2017 6:07 am

Re: java example exception in viewer.jsp

Post by xiaohaoxifei »

Can we dynamically control the display columns of a report in the viewer page, not by set the report columns in the .mrt files?
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: java example exception in viewer.jsp

Post by HighAley »

Hello.

Unfortunately, it's impossible to control the columns dynamically in Reports.Java product.

Thank you.
xiaohaoxifei
Posts: 34
Joined: Mon Sep 18, 2017 6:07 am

Re: java example exception in viewer.jsp

Post by xiaohaoxifei »

I'm add a pie chart to my report and the arguments are displayed as the value of the data, but not the text columns, please help.
The value and argument are set from two columns of the same SQL data source. The value is displayed OK, but the argument is not OK.
The sql query result is attached.
Please help, thanks in advance.
Attachments
data.png
data.png (6.54 KiB) Viewed 6188 times
meter_report_status.mrt
(38.57 KiB) Downloaded 389 times
pie2.png
pie2.png (60.18 KiB) Viewed 6191 times
pie.png
pie.png (16.01 KiB) Viewed 6191 times
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: java example exception in viewer.jsp

Post by HighAley »

Hello.

If you need to change the labels, you should set the Value Type and Legend Value Type.

Thank you.
xiaohaoxifei
Posts: 34
Joined: Mon Sep 18, 2017 6:07 am

Re: java example exception in viewer.jsp

Post by xiaohaoxifei »

HighAley wrote:Hello.

If you need to change the labels, you should set the Value Type and Legend Value Type.

Thank you.
Great, it works now.

Thank you so much.
xiaohaoxifei
Posts: 34
Joined: Mon Sep 18, 2017 6:07 am

Re: java example exception in viewer.jsp

Post by xiaohaoxifei »

[quote="HighAley"]Hello.
I have this sql for data source, which is test OK for database connection. but failed to get any data through the viewer. I think it's a bug.

Code: Select all

SELECT
  CASE dev_status
  WHEN 1
    THEN 'Wait Install'
  WHEN 2
    THEN 'Install Offline'
  WHEN 3
    THEN 'Online'
  WHEN 4
    THEN 'Running'
  WHEN 5
    THEN 'Wait Release'
  WHEN 6
    THEN 'Wait Repaired'
  WHEN 7
    THEN 'Scrap'
  ELSE 'NULL' END    AS status,
  count(*)           AS Total,
  concat(round(100 * (count(*) / sum(count(*))
  OVER ()), 2),'%') AS Perc
FROM G_AR_METER
GROUP BY DEV_STATUS
The problem is caused by "concat(round(100 * (count(*) / sum(count(*))
OVER ()), 2),'%') AS Perc"

If the % is removed, the data is retrieved OK.
Vadim
Posts: 362
Joined: Tue Apr 23, 2013 11:23 am

Re: java example exception in viewer.jsp

Post by Vadim »

Hello.
We tested your query on Oracle with last version (2017.2.2.1 https://search.maven.org/#search%7Cgav% ... ts-libs%22)
everything works fine
Can you provide your error full stack trace log.
Post Reply