BIRT report with RQM. How to create a join query for one data set ?
I wanted to create a extensive report PDF which is in UI from BIRT with some modification. In BIRT I am not able to use a join query for a single data set.
my requirement is that for a particular plan-id , i wanted to extract all the data consisting test cases , test scripts , categories in one report .
Please suggest me on how to do the same.
my requirement is that for a particular plan-id , i wanted to extract all the data consisting test cases , test scripts , categories in one report .
Please suggest me on how to do the same.
One answer
In BIRT, you can always join multiple data sets together to achieve a combined/joint data set. If the two data sets being joined happen to contain the same data, you can create _two_ data sets with the same settings (hence containing same data).
If you still have difficulties in do so, can you please clarify what is "a join query for a single data set"?
If you still have difficulties in do so, can you please clarify what is "a join query for a single data set"?
Comments
I am trying to create a extensive report for Test Plan , which needs Category information , owner information , test cases and test script. I have a query with me , like "Select C.* from test Plan Table TP , Category C where TP.category name = c.category name" , I want this query for single data set and not two
Have you created any BIRT reports for RQM before? The Jazz Data Source is not really a traditional SQL Data Source and I doubt that you can use any complex SQL statements against it.