Export Public Defect Report from QC using VBA
I need to export a defect report (saved as public report in QC-Defects) into excel and then apply some pivots, graphs and charts on it.
Can someone help me with the first step to export a public report from defects module using VBA? (I can do it using a query and then choose column I need but I want to make the flexibility of changing the public report and not updating the code in future)
Thanks for your support
Re: Export Public Defect Report from QC using VBA
Refer the Chapter Generating Excel Reports in the User Guide. If you want your report to be flexible, you can use Parameters in your query.