Thanks for your response.
Jointy, Yes From the QTP results file.
I am using the Yaron's report manager and came up with the following issue.
If you run one script at a time it would be fine and you will see result on the (TopView.xls) excel document. But when you run a batch, even you add his demo script on each of the scripts in the batch and you will get the result for last test script in the batch. that means qtp is overwriting the TopView.xls.
Is there any way to stop overwrite the TopView.xls? to get result for all tests in a batch. Please let me know.