Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Data of two data sets in one table(Report show status of certain OrderNo's working steps)
Data of two data sets in one table [message #1774804] Thu, 19 October 2017 18:25
Hans Müller is currently offline Hans MüllerFriend
Messages: 1
Registered: October 2017
Junior Member
Hello,

iIhave the following datasources and querys setup:

Pic1:
[table; datasets]
index.php/fa/31082/0/

Pic2:
[query ord_comp and orders data set]
index.php/fa/31065/0/


The join works fine and i get the data i need in the left side of the table.

Now i want to show the "status" of each of the working step (FE_NO) shown in the right half of the table. (Look at the query on ord_comp data set)
Each [FE_NO] has a status 10, 20 or 30.
Basically i need to show the status of each [FE_NO] for the [orderNo]'s the query on orders returned.
How would i pass the oderNos to the the ord_comp dataset?
And how do i get them to show up in line with the related orderNo in the right side of the table?

I tried to use two tables in a list, but that gives me several sides repeating the first table(basically the left side here) and showing the working steps related to just one of the orderNos per page.

As i need a printer friendly version, that's not what i need. It should show the statuses of the working steps in one row per OrderNo. As shown in the first screen basically.

Thanks in advance.


  • Attachment: birt2.png
    (Size: 26.88KB, Downloaded 55 times)
  • Attachment: birt4.png
    (Size: 37.42KB, Downloaded 193 times)
  • Attachment: birt1.png
    (Size: 13.00KB, Downloaded 133 times)

[Updated on: Sat, 21 October 2017 21:38]

Report message to a moderator

Previous Topic:Birt Viewer Exception
Next Topic:BIRT - Merging Data from 2 Rows
Goto Forum:
  


Current Time: Tue Feb 20 00:20:39 GMT 2018

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

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