java example exception in viewer.jsp
Re: java example exception in viewer.jsp
Hello
We are always glad to help you!
Please let us know if you need any additional help.
Thank you.
We are always glad to help you!
Please let us know if you need any additional help.
Thank you.
-
- Posts: 34
- Joined: Mon Sep 18, 2017 6:07 am
Re: java example exception in viewer.jsp
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?Aleksey wrote:Hello
We are always glad to help you!
Please let us know if you need any additional help.
Thank you.
2, Where could we found some beautiful .mrt template files?
Thanks.
Re: java example exception in viewer.jsp
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.
> 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.
-
- Posts: 34
- Joined: Mon Sep 18, 2017 6:07 am
Re: java example exception in viewer.jsp
Can we dynamically control the display columns of a report in the viewer page, not by set the report columns in the .mrt files?
Re: java example exception in viewer.jsp
Hello.
Unfortunately, it's impossible to control the columns dynamically in Reports.Java product.
Thank you.
Unfortunately, it's impossible to control the columns dynamically in Reports.Java product.
Thank you.
-
- Posts: 34
- Joined: Mon Sep 18, 2017 6:07 am
Re: java example exception in viewer.jsp
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.
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 (6.54 KiB) Viewed 6312 times
-
- meter_report_status.mrt
- (38.57 KiB) Downloaded 407 times
-
- pie2.png (60.18 KiB) Viewed 6315 times
-
- pie.png (16.01 KiB) Viewed 6315 times
Re: java example exception in viewer.jsp
Hello.
If you need to change the labels, you should set the Value Type and Legend Value Type.
Thank you.
If you need to change the labels, you should set the Value Type and Legend Value Type.
Thank you.
-
- Posts: 34
- Joined: Mon Sep 18, 2017 6:07 am
Re: java example exception in viewer.jsp
Great, it works now.HighAley wrote:Hello.
If you need to change the labels, you should set the Value Type and Legend Value Type.
Thank you.
Thank you so much.
-
- Posts: 34
- Joined: Mon Sep 18, 2017 6:07 am
Re: java example exception in viewer.jsp
[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.
The problem is caused by "concat(round(100 * (count(*) / sum(count(*))
OVER ()), 2),'%') AS Perc"
If the % is removed, the data is retrieved OK.
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
OVER ()), 2),'%') AS Perc"
If the % is removed, the data is retrieved OK.
Re: java example exception in viewer.jsp
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.
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.