java example exception in viewer.jsp

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

Re: java example exception in viewer.jsp

Post by Alex K. » Wed Sep 27, 2017 1:52 pm

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 » Thu Sep 28, 2017 3:30 am

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: 6476
Joined: Thu Jul 29, 2010 2:37 am

Re: java example exception in viewer.jsp

Post by Alex K. » Thu Sep 28, 2017 11:37 am

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 » Mon Oct 09, 2017 9:24 am

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: 7790
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: java example exception in viewer.jsp

Post by HighAley » Mon Oct 09, 2017 3:51 pm

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 » Wed Oct 11, 2017 3:08 am

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 1971 times
meter_report_status.mrt
(38.57 KiB) Downloaded 37 times
pie2.png
pie2.png (60.18 KiB) Viewed 1974 times
pie.png
pie.png (16.01 KiB) Viewed 1974 times
HighAley
Posts: 7790
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: java example exception in viewer.jsp

Post by HighAley » Wed Oct 11, 2017 1:46 pm

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 » Thu Oct 12, 2017 12:42 am

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 » Thu Oct 12, 2017 6:12 am

[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: 219
Joined: Tue Apr 23, 2013 11:23 am

Re: java example exception in viewer.jsp

Post by Vadim » Mon Oct 16, 2017 11:46 am

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