java example exception in viewer.jsp

Jump to: Board indexJS, Java, PHP, FlexStimulsoft Reports.Java

Stimulsoft Reports.Java discussion

Re: java example exception in viewer.jsp

Post 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.
Alex K.
 
Posts: 6300
Joined: Thu Jul 29, 2010 2:37 am

Re: java example exception in viewer.jsp

Post 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.
xiaohaoxifei
 
Posts: 30
Joined: Mon Sep 18, 2017 6:07 am

Re: java example exception in viewer.jsp

Post 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.
Alex K.
 
Posts: 6300
Joined: Thu Jul 29, 2010 2:37 am

Re: java example exception in viewer.jsp

Post 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?
xiaohaoxifei
 
Posts: 30
Joined: Mon Sep 18, 2017 6:07 am

Re: java example exception in viewer.jsp

Post Mon Oct 09, 2017 3:51 pm

Hello.

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

Thank you.
HighAley
 
Posts: 7579
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: java example exception in viewer.jsp

Post 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 258 times
meter_report_status.mrt
(38.57 KiB) Downloaded 5 times
pie2.png
pie2.png (60.18 KiB) Viewed 261 times
pie.png
pie.png (16.01 KiB) Viewed 261 times
xiaohaoxifei
 
Posts: 30
Joined: Mon Sep 18, 2017 6:07 am

Re: java example exception in viewer.jsp

Post 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.
HighAley
 
Posts: 7579
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: java example exception in viewer.jsp

Post 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: 30
Joined: Mon Sep 18, 2017 6:07 am

Re: java example exception in viewer.jsp

Post 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.
xiaohaoxifei
 
Posts: 30
Joined: Mon Sep 18, 2017 6:07 am

Re: java example exception in viewer.jsp

Post 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.
Vadim
 
Posts: 209
Joined: Tue Apr 23, 2013 11:23 am

PreviousNext

Return to Stimulsoft Reports.Java

Who is online

Users browsing this forum: No registered users and 2 guests