Currently I m trying to create a RTM. Now I want to export a report from QC 'Dashboard' which should display-
1. Requiremet ID
2. Requirement Name
3. Corresponding Test Case ID
4. Corresponding Test Case Name
5. Test Case Latest Run Status
6. Test Case Latest Execution Date
7. Associated Defect ID (in case of TC Run Status = Failed)
8. Defect Status
9. Defect Severity
10. Defect Assigned To
What do you know about the options available in the Dashboard module?
You should be able to do this by creating an Excel Report in the Dashboard module. Those types of reports require that you create a SQL query to extract the data you want, and the results are put into an Excel file. You must have Excel loaded on any workstations where you want to generate the report.
What do you know about SQL and the database schema for QC projects? There is a Database Reference document available from the QC Documentation Library.