Looking for example BIRT RQM reports

HI Mark.

I have done some reports in RQM using BIRT. What kind of report do you want to do? what involved?

E-mail me or post it here maybe i could help you :)! I see you are an ibmer (you could chat to me on ST)

Hi,

I'll post here for now so none ibmers can see also. I am specifically interested in RQM and testcases/testscripts which seems particularly light in decent reports.

Also, have you and instructions of creating and joing datasets? Also what all the tables relate to?

Ta

Mark

HI Mark.

I have done some reports in RQM using BIRT. What kind of report do you want to do? what involved?

E-mail me or post it here maybe i could help you :)! I see you are an ibmer (you could chat to me on ST)

Sharing the concern... ...please keep us posted on developments on this thread

I have raised a similar investigation under: http://jazz.net/forums/viewtopic.php?t=15652

I was advised (by IBMer) to keep BIRT use down to tweaking existing reports. If you want a new report use RRDI/RCR.

Input on this topic would be gratefully recieved

Hi,

I'll post here for now so none ibmers can see also. I am specifically interested in RQM and testcases/testscripts which seems particularly light in decent reports.

Also, have you and instructions of creating and joing datasets? Also what all the tables relate to?

Ta

Mark

Hi, Mark.

I followed this guide in the developers works website : http://www.ibm.com/developerworks/rational/library/10/creatingcustomreportswithbirtandrtc-part1/index.html?ca=drs-
its about BIRT and RTC Reports, but its the same for RQM just that you have another information in the tables.

For joining data sets you must select 2 data sets that have one value in common, for example test case item id.

You are looking for scripts and test cases? like just show all test cases with their respectively test script?

Hi,

I'll post here for now so none ibmers can see also. I am specifically interested in RQM and testcases/testscripts which seems particularly light in decent reports.

Also, have you and instructions of creating and joing datasets? Also what all the tables relate to?

Ta

Mark

Hi, Mark.

I followed this guide in the developers works website : http://www.ibm.com/developerworks/rational/library/10/creatingcustomreportswithbirtandrtc-part1/index.html?ca=drs-
its about BIRT and RTC Reports, but its the same for RQM just that you have another information in the tables.

For joining data sets you must select 2 data sets that have one value in common, for example test case item id.

You are looking for scripts and test cases? like just show all test cases with their respectively test script?

Yes please, we would like to just show all test cases with their respectively test script(s).

Hi, i made a simple report with the test cases and the test scripts like this

TestCase ID- Test Case - Script ID - Script


You will find blank spaces because there are cases with no scripts and scripts with no cases.

What i did was first look into the tables for the test case , and i used the Versioned_TestCase table, there i got the Test Case Id and name along with the script item id but no name. Then i found the script table and got item id, id and name. So then i joined both table with the itemId as the connector.

Will send you by e-mail because i dont know how to upload files here!.
Oh you have to change your project area name. I used the default 'Quality Manager' project area.

Thank you

My e-mail is irelandm@uk.ibm.com

Thanks

again.

Mark

Hi, i made a simple report with the test cases and the test scripts like this

TestCase ID- Test Case - Script ID - Script


You will find blank spaces because there are cases with no scripts and scripts with no cases.

What i did was first look into the tables for the test case , and i used the Versioned_TestCase table, there i got the Test Case Id and name along with the script item id but no name. Then i found the script table and got item id, id and name. So then i joined both table with the itemId as the connector.

Will send you by e-mail because i dont know how to upload files here!.
Oh you have to change your project area name. I used the default 'Quality Manager' project area.