Calculating value from a second table
Comments
-
<p>Hi,</p>
<p> </p>
<p>when you say "<span style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;font-size:13.63636302948px;">I have two tables" : Are you talking about SQL table or a table component in BIRT?</span></p>
<p><span style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;font-size:13.63636302948px;">BTW, how many datasets do you have ?</span></p>
<p> </p>
<p><span style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;font-size:13.63636302948px;">If SQL Table </span></p>
<p><span style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;font-size:13.63636302948px;">modify your SQL query and join table 1 and table 2</span></p>
<p> </p>
<p><span style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;font-size:13.63636302948px;">if BIRT Table</span></p>
<p><span style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;font-size:13.63636302948px;">Create a nested table </span></p>
<p> </p>
<p><span style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;font-size:13.63636302948px;">if (?) 2 differents data sets </span></p>
<p><span style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;font-size:13.63636302948px;">Create an union data set</span></p>Warning No formatter is installed for the format ipb0 -
<p>SQL Table.</p>
0 -
<p>Hi,</p>
<p> </p>
<p>so, if possible, you only have to modifiy the query. It should be more or less something like this</p>
<pre class="_prettyXprint _lang-">
SELECT A.list_of_users,
A.labs_used,
A.date,
A.hours,
B.rate_details
FROM TABLE1 AS A
INNER JOIN TABLE2 AS B
ON A.lab_name = B.lab_name
</pre>Warning No formatter is installed for the format ipb0
Categories
- All Categories
- 107 Developer Announcements
- 53 Articles
- 105 General Questions
- 142 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 898 Cloud Fax and Notifications
- 76 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 118 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management