Page 3 of 7
Re: java example exception in viewer.jsp
Posted: Wed Sep 27, 2017 1:52 pm
by Alex K.
Hello
We are always glad to help you!
Please let us know if you need any additional help.
Thank you.
Re: java example exception in viewer.jsp
Posted: Thu Sep 28, 2017 3:30 am
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.
Re: java example exception in viewer.jsp
Posted: Thu Sep 28, 2017 11:37 am
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.
Re: java example exception in viewer.jsp
Posted: Mon Oct 09, 2017 9:24 am
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?
Re: java example exception in viewer.jsp
Posted: Mon Oct 09, 2017 3:51 pm
by HighAley
Hello.
Unfortunately, it's impossible to control the columns dynamically in Reports.Java product.
Thank you.
Re: java example exception in viewer.jsp
Posted: Wed Oct 11, 2017 3:08 am
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.
Re: java example exception in viewer.jsp
Posted: Wed Oct 11, 2017 1:46 pm
by HighAley
Hello.
If you need to change the labels, you should set the Value Type and Legend Value Type.
Thank you.
Re: java example exception in viewer.jsp
Posted: Thu Oct 12, 2017 12:42 am
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.
Re: java example exception in viewer.jsp
Posted: Thu Oct 12, 2017 6:12 am
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.
Re: java example exception in viewer.jsp
Posted: Mon Oct 16, 2017 11:46 am
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.