How do we check the data is correct or not in the report after generating the query?

Interview Candidate
Nov 9th, 2006
2
2077

First
Prev
Next
Last

Showing Answers 1 - 2 of 2 Answers

Babs

Nov 13th, 2006

Check and run the query in backend(Toad/PLSQL Developer)
Cheers,
Babs

sumesh

Mar 7th, 2007

Step1: First run the same report query in TOAD or SQL Navigator. Take the count of rows.

Step2: Run the report in BO client and after getting the results click on data manager. Under results tab click on Export button.

Step3: Click on radio button Export to local format. Give format as microsoft excel files.

Step 4: Count the rows in excel. check with the count of rows from TOAD. If it is same then the report is correct.