I am still researching on a dotnet application to automate with QTP, so replies to the below scenarios will be much appreciated.
1) What is the process and if possible generic code for testing "custom built reports" -they can be excel\cognos\BO - generated reports. How to or what is the code for comparing against the expected values.
2)If the value we provide in datasheet or excelsheet is "without comma" (1600.00) but the value generated in reports is "with comma" (1,600.00), then it will fail. How to avoid it.
3) When we compare expected and actual result values in 2 cells and we have to automatically fill pass\fail in the 3rd cell, then what should be the code.
4) What is the process and code for testing" custom made stored procedures".
--if you can provide generic code, that would be helpful. Thanks.
to add on to the above post as I cannot edit the above post --- "the reports can be in excel format or crystal reports format or in pdf format."
1) What is the process and if possible generic code for testing "custom built reports" -they can be excel\cognos\BO - generated reports. How to or what is the code for comparing against the expected values.
2)If the value we provide in datasheet or excelsheet is "without comma" (1600.00) but the value generated in reports is "with comma" (1,600.00), then it will fail. How to avoid it.
3) When we compare expected and actual result values in 2 cells and we have to automatically fill pass\fail in the 3rd cell, then what should be the code.
4) What is the process and code for testing" custom made stored procedures".
--if you can provide generic code, that would be helpful. Thanks.
to add on to the above post as I cannot edit the above post --- "the reports can be in excel format or crystal reports format or in pdf format."