Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Subreports with Scripted Dataset using Handiler class
Migrateduser
Hi Friends,<br />
I need help from any BIRT experts in subreport on Scripted Data Source.<br />
<br />
The requirement likes to show the Employee information and employee additional information. <br />
The Employee has many transactions like leave information, Daily Task Information and much other addition information. All addition transaction information is stored in separate tables. The report can show 5000 records for each addition information for an employee.<br />
<br />
The report output like, <br />
1. Employee details<br />
a. If leave flag is ?Yes? then needs to show leave information otherwise no needs to show.<br />
b. If Daily Task flag is ?Yes? then the daily activity needs to show otherwise no need to show.<br />
<strong class='bbc'>The Implementation:</strong><br />
Points 1: <br />
I have created multiple data sets like 1. Employee_DS, 2. Emp_Leave_DS 3. Emp_Task_DS and so... and I have created Hander java class for each DS and implemented beforeOpen(), Open and fetch() methods.<br />
1. beforeOpen():get Input Parameter Value and assign to local property.<br />
2. Open(): fetching the data from DB as based on employee Id and assign to global variable<br />
3. Fetch(): a. reading the global variable data b. setting row data<br />
<br />
Point 2:<br />
My rpt design are like, using many details rows for each additional information.<br />
1. First details row, display employee details<br />
2. Second detail row, Leave information and the visibility condition if (leave_flag ==?Y?) {false;}else{true;}<br />
3. Third and fourth detail row used for other additional info and the 2?nd step is continued for all other additional information.<br />
<strong class='bbc'>The Problem is:</strong><br />
The report is get generated with employee details which is data from Employee_DS? the additiona DS handler classes all methods are get called but the additional information are not display on report. <br />
<br />
<span class='bbc_underline'>Note:</span> I can?t use single data set because the requirement to show 5000 additional information for each employee .<br />
<br />
please help me to correct my code and I don?r know why the additional information are not display even the rows are setting .
Find more posts tagged with
Comments
There are no comments yet