Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » BIRT report to create the csv file and report generation(Using BIRT report to create the csv file and normal process to run the report)
BIRT report to create the csv file and report generation [message #1842172] Thu, 10 June 2021 18:09
T K is currently offline T KFriend
Messages: 1
Registered: June 2021
Junior Member
BIRT report Requirement:
I need to create Labor report and display the columns such as (laborcode, startdatetime, finishdatetime, regularhrs,craft etc) with below mentioned 2 parameters and when run the report from Maximo application, the report generates in browser view. At the same time, the CSV file should be generated in server path(C:/report) with the same data.
Parameters:
1. Numberofdays ->(This parameter is used in the finishdatetime field- finishdatetime
BETWEEN ( CURRENT DATE
"+params["NumberofDays"]+" DAYS) AND
( CURRENT DATE) " )
2. FTP Folder -> (This parameter is used for specifying server Path: "C:/report")
NOTE:
 When User Enter both the parameters from application (Example: Numberofdays -> 20 and FTP Folder ->C:/report ) , The CSV file should be generated in server path and also report should generate in application browser view.
 OR if user Enters only one Parameter: Numberofdays ->20 and they leave FTP folder as empty, The CSV file should not be generated in server path and report should generate only in application browser view.

And I have the below questions:
 For placing the file in server path, I have tried with the automation script using below runreport method. But, in Maximo we have the following file format options (PDF, XLS, XLSX) not having any CSV option.
reportService.runReport(userInfo, "Laborreport.rptdesign", "LABREP", parameterData,"C:/report", "xls")
 Do we have any option to create the CSV file from the report rptdesign itself and not from automationscript?
Kindly guide me to achieve the above-mentioned requirement in report rptdesign itself? Or any other possibilities available. Thankyou!
Previous Topic:Error 500: java.lang.NoClassDefFoundError com.ibm.icu.impl.ICUResourceBundle(initialization failure)
Next Topic:AWS for BIRT
Goto Forum:
  


Current Time: Sat Oct 16 13:22:40 GMT 2021

Powered by FUDForum. Page generated in 0.01419 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top