Binding multiple datasets to table
Comments
-
You can only bind one dataSet to a table. The ways around this are to either join your two dataSets into one, then bind that dataSet to the table, or to embed elements from the second dataSet into your table and use a filter or dataSet parameter bindings to limit the data for the embedded element.Warning No formatter is installed for the format ipb0
-
Well the joint dataset idea had to be trashed because i ended up having to add up 3 data items from 3 different datasets. So what I did was create a dataset that unioned the 3 values that I needed and then binded that to the grid. Not a very pretty way..but I am very interested in hearing about global variables.
Thank you.0 -
Sorry for the delay. If you just need to add a couple or few values from different dataSets, you can set the value you need from each dataSet to a reportContext.setGlobalVariable("varName","value");, then, recall those global variables where you need them, for your calculation. If you show me some sample data and what you want your final result to be, I'll make you a quick sample.Warning No formatter is installed for the format ipb0
-
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="102883" data-time="1339520284" data-date="12 June 2012 - 09:58 AM"><p>
Sorry for the delay. If you just need to add a couple or few values from different dataSets, you can set the value you need from each dataSet to a reportContext.setGlobalVariable("varName","value");, then, recall those global variables where you need them, for your calculation. If you show me some sample data and what you want your final result to be, I'll make you a quick sample.<br /></p></blockquote>
<br />
Hi,<br />
<br />
I have the following scenario:<br />
<br />
I am using a flat file data source and don't have the ability to join the data sets.<br />
<br />
Dataset1: Field: Signer_Name - has EMP ID<br />
Dataset2: Fields: EMP ID, EMP NAME, EMP EMAIL.<br />
<br />
I have a need to read the EMP ID (Multiple values) and then display the results for the EMP from the Dataset2. I was able to do this on the report designer using the Nested Tables, but the realtime report takes a lot of time to generate and sometime times out. Is there a way that I can read values from Dataset1 into a Global Variable and then display the matching EMP details from Dataset2 ?<br />
<br />
<br />
Any suggestions will be greatly appreciated.0 -
Dataset1: Field: Signer_Name - has EMP ID ( like 5 digit numbers), Sign_Date - Date and time Stamp.
Dataset1:
Signer_Name, Sign_date
11111, 1/1/2012 10:00:00 AM
11112, 1/20/2012 10:00:00 AM
11233, 10/11/2012 11:00:00 AM
Dataset2:
EMP ID, EMP NAME, EMP EMAIL
11111, TOM CRUSE, Tom_Cruse@gmail.com
11233, Mike Tyndal, Mike@gmail.com
The Dataset1 is being derived from one business process (Employee Signature on purchase orders) and the Dataset2 is being derived from a different business process (Full Company Employee Dataset).
Other fields in the Dataset1:
Order_number, Order_desc, Order_date, Vendor_ID.
My expectation is that when the report is run, it picks up the order details and in the signature details (Table), I want to display the EMP_NAME and EMP_EMAIL by looking at the EMP ID from Dataset2 and Corresponding value if available from Signer_Name in dataset1.
Output:
Signer Name, Signer Email, Signature Date
EMP_NAME, EMP_EMAIL, SIGN_DATE
TOM CRUSE, Tom_Cruse@gmail.com, 1/1/2012 10:00:00 AM
Mike Tyndal, Mike@gmail.com, 10/11/2012 11:00:00 AM
I hope I was able to provide all the information that you asked for.
Thank you0 -
Here's an example where the name and email are stored in arrays in the onFetch of the customer directory, then accessed in the purchases table by using the id field. Take a look. You can also do the same with persistentGlobalVariables, if you'd like. As I put the name and email in the employee id slot of the array, you can name your global variables after the employee id, so you can easily access the correct values. This design was made in BIRT 3.7. Let me know if you have questions.Warning No formatter is installed for the format ipb0
-
<p>I need help for my scenario.</p>
<p> </p>
<p>I have two datasets. and in date parameter i am passing the todays date. If the day is saturday, then dataset1 should be execute else dataset2 should be execute. </p>
<p> </p>
<p>How should i impliment this logic in report???</p>
0 -
<p>There are several ways you could handle this. Here are a couple</p>
<p> </p>
<ul><li>Use two different tables bound to different data sets. Depending on the day, drop the appropriate table from the report in the beforeFactory.</li>
<li>Depending on the changes that you're making with the query, you could use a single data set and change the query in the beforeOpen method of the data set.</li>
</ul><p>Let me know if either of these sounds like it'd work for you.</p>
Warning No formatter is installed for the format ipb0 -
<p>Thank You Williams.</p>
<p> </p>
<p>If possible can you please provide me example for the second one?</p>
<p> </p>
<p>If Business='sales' then dataset1</p>
<p>else dataset2</p>
<p> </p>
<p>" Depending on the changes that you're making with the query, you could use a single data set and change the query in the beforeOpen method of the data set."</p>
0 -
<p>What I believe Michael was indicating in point 2 is not using 2 different data sets, it is dynamically modify the query of a single data set.</p>
<p> </p>
<p>This is where the caveat comes in that Michael indicated about it depending on the changes you are making with the query. If the query changes the data set structure to much, such as different columns with different names/data types, this method may not work for your situation.</p>
Warning No formatter is installed for the format ipb0 -
<p>Hi , I have used <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?app=core&module=attach§ion=attach&attach_id=7137' title="Download attachment"><strong>NameIDLookupKeyField.rptdesign</strong></a> as a reference and created a report . I have created two dataset one order data set containing createdby and few other details and another userDetails dataset with username and email id and I m trying to fetch email ID from UserDetails for the createdby_ in Order dataset.It is working fine for a single record but with multiple record I m getting the same email ID for all the records.</p>
0
Categories
- All Categories
- 108 Developer Announcements
- 53 Articles
- 106 General Questions
- 144 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 899 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 119 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management