Calculating value from a second table

BIRT_REPORT1
edited February 11, 2022 in Analytics #1
<p>I have two tables. First table contains list of users, labs used, date, and hours. Second table contains name of labs and rate details.</p>
<p> </p>
<p>I want to produce a report where it shows the user, labs used, date, hours, rate details, and total charge amount.</p>

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 ipb
  • <p>SQL Table.</p>
  • <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 ipb