gheryosti
18th April 2008, 14:06
Situation: Baan ERP LN 6.1, WebTop 8.4.1.
Hi,
we are trying to use and improve usage of report viewer, the latest reporting tool released by infor, but we found some problems.
First, the settings of enviromental variables it's a strange task, and we are not still able to recover a standard procedure of setting them up in order to install the same settings in every systems we need. I mean we found a lot of problems especially in the automatic process of loading java class and running of jvmi.
Second, finally we found a solution after thousands attempts, then we tried to convert some reports, conversion works fine, but the problem now it's exporting and importing of the generated .rptdesign file.
I mean, first time we convert from a 4gl report and export it to locale, modify it and import it on the server again, then print the report converted from webtop session and goes ok.
Now suppose we would like to modify it again in reporting studio, so repeat the procedure (export-import) print it again. Here is the bug, we are not able to see the last modification we made in the second process of export - customization - import of the report.
Maybe webtop store somewhere the old one? Maybe we have made mistake?
Please help me if you can, i'm getting crazy trying to understand why.
NOTE: I know that the only modifications allowed in the report converted from baan are layout modifications.
tese112
8th May 2008, 15:05
I mean we found a lot of problems especially in the automatic process of loading java class and running of jvmi.
gheryosti, can You explain how You solve that? I'm traing to do the same thing, but it's not working :( after running sesion for enable reports on the windows event viewer I can see log like: Unable to start JavaVM - JVMI not available
Do You have the same problem?
Concerning Your bug, chceck the latest solutions for 7.6_b4_tt and also if session for import replace oryginal files in ${BSE}\application\*\*.rptdesign with Your modified report.
Second, chceck for newest version od reportviewer, reading the changes history there is a couple bug concerning showing and refreshing BIRT reports.
Finally try to delete content of folder (or selected files) in Tomcat server: \webapps\reportviewer\reportdesigns\HOST_NAME\erp6ln\application it's cache for reports reading from LN, check if there is Your modified report. This should help.
tese112
12th May 2008, 10:55
OK, I solve all problems. Problem concerning JVMI was in not proper PATH and CLASSPATH variables. Now I have the same problem as yours with not refreshing customized report but when I delete reportviewer cache it hepls :).
I already register an inquiry for that in Infor.
gheryosti
12th May 2008, 11:13
Great, now we have the same situation. We are in contact with Infor too, i propose now to keep the link between our progresses in order to reach faster results.
For the moment we are in stand by, but meanwhile we noticed another question: when you print a report in Report Viewer, despite of his original size and orientation, it's printed with a landscape orientation and a window(screen)-sized dimension, do you know what's the problem?
Thanks a lot for the support, best regards.
zardoz
13th May 2008, 12:56
Do you mean print in BWprint? If this is the case, keep in mind that bwprint always uses your default (windows client) printer settings...
gheryosti
13th May 2008, 15:45
No, i mean print in the RPT device, expressly built for printing rptdesign file.
It looks like a landscape page printed in the BWprint, but it's a completely different matter, i think.
In any case any suggestions are welcome.
thanks, bye.
tese112
15th May 2008, 13:07
Yes, after couple emails I get the answer from Infor concerning not updated reports:
What I know this feature will be available in the next version. Rigth now you have to deleted the old reports, sorry.
Check the new WebTop (NS0122) there is couple new fixes concerning homepages and reports:
- Resize is sent far too often if session is running in a homepage
- A close of a homepage also gets the unopened reports
- Memory leaks in home pages
Now, I don't know error with landscape orientation, but I try convert some more reports and check it, I will inform You about progress.
gheryosti
15th May 2008, 15:50
Thanks again Tese,
At least i've learned i've to wait for a fix in the report update, now still remain resizing problem...hope will be fixed.
Anyway keep update, as usual.
Best Regards.
bye.
indrabrata
26th July 2008, 03:21
hi..could someone help me where can i get the reporting studio?thank you in advance
tese112
28th July 2008, 10:37
Infor reporting studio is nothing more then regular eclipse with plugins for BIRT (available on the eclipse page) and one more plugin with ERP LN (the las one You should download from Infor) but You can work without this plugin as well.
If You have access for infor.subscribenet.com there is new versions of studio and there is 3 version of them in one ISO image:
1. Infor ERP LN Application Studio
2. Infor ERP LN Business Studio
3. Infor ERP LN Reporting Studio
The one with interesting for You is 3 it's newest version, I just started to test that environment.
rajesh_bamane
29th May 2009, 09:20
Hi ,
I have developed report using Eclipse tool, the report is running fine with eclipse tool.now i am trying to run the report using report viewer but i am facing following error while running the report
The following items have errors:
ReportDesign (id = 1):
+ Cannot open the connection for the driver: com.infor.reporting.bdb
Failed to get connection.
SQL error #1: Client unable to create connection: Connection failure (login failed); could not connect to remote bse on host C:\Infor\ERPLN\bse\birt-runtime\ReportEngine\configuration (note: environment variable BSE_REM is set to C:\Infor\ERPLN\bse\birt-runtime\ReportEngine\configuration)
Please suggest me the solution to resolve this issue.
Thanks
Regards
Raj