Shulou(Shulou.com)06/03 Report--

Report test

Report testing varies from large to small according to the definition of the project, sometimes it is only tested as a part of the software, and sometimes the whole project tests various reports. But no matter what. The function of the report is always to calculate, process, sort out and summarize the data that already exists in the system according to the settings of the user / finally show it to the user in a clear format. So that users can do further data analysis or statistics.

The report implementation in the software is generally divided into two parts: defining the required data of the report (generally, you can narrow the data range by selecting or manually entering conditions) and defining the report format. In addition to the fixed format specified in the national industry standards, the report format is mostly customized according to the needs of enterprises or users.

Therefore, when doing report testing, you should pay attention to the following aspects:

1. The correctness of the data

Users use reports in the hope that they can quickly find the data they need through a simple and convenient platform. Therefore, when testing the report, we should first check whether the data in the report is the data needed by the user, if there is no processed data, whether it has maintained the original appearance, and whether the processed data is consistent with the results of manual processing. In short, you need to test the following:

1) the source of the data: which table, which field, the corresponding values in the database and the interface data. For example, if the gender data in the database may be 0 or 1, but the interface is displayed as male or female, is this corresponding relationship correct?

2) the scope of the data: whether only the corresponding range of the report settings is displayed; pay special attention to the boundary data, to be clear about the requirements of the report, whether it is necessary to filter out the selected data. If the time is selected as 2006-9-27, 2007-9-27, should 9-27 be included?

3) the correspondence of the data: whether the fields in the database correspond to the information in the report. Data format: whether decimal places, thousand places, rounding, etc., are consistent with the report settings; whether the unit or tax rate conversion is correct; whether the data displayed in the combination is reasonable

4) sorting of data: whether the sorting method is consistent with the report settings (if not, is there a clear default sorting method, such as alphabetical or numeric sorting)

5) serial number: if the report has a serial number, whether the generation and format of the serial number is correct. Whether canceling the operation will generate a serial number

6) consistency of details and totals: whether the details or sections of each part are consistent with the final sum

7) other

(1) to test this part, you need to be familiar with the business logic and the design of the database. If necessary, you can view the data by writing your own query statements.

(2) some reports have more or less conditions, but the test methods are all the same. According to the conditions, various combinations of conditions are set up through the division and permutation and combination of equivalent classes. Do not test blindly, otherwise it will cause the test to be untested and a lot of extra tests will be done. Generally speaking, there are categories (the general interface is shown as a drop-down box), and each category should be tested, such as men and women in the gender. The input can be divided into data to be tested by equivalence classes.

two。 The correctness of the format

After the data is verified correctly, you need to see if the output format of the report meets the requirements. It can be checked from the following aspects.

1) the overall style of the report: whether the report conforms to the specified or user-set format

2) report title: whether the report title is the correct report name; for example, there is embedded data in the report (which will change according to the user's choice). You need to check whether the data are correct, such as XX Enterprise's financial statements for September, which is selected by users, or XX's website visits from September 2007 to September 27, which is also selected by users.

3) whether some logos of the company, such as logo, name, address, etc., are correct.

4) Page header and footer of the report: whether consistent rules are adopted

5) paging: whether paging is correct when there is a lot of output. Is the page turning function correct?

6) friendliness: whether the data or charts are clear and clear at a glance, whether the display of the data is in line with the user's habits; whether the data that need special reminders (such as totals, abnormal data) are highlighted; whether there are comments in complex algorithms that users do not understand or are easy to confuse; whether some default formats make people feel comfortable, such as alignment, boundaries, intervals, etc.

3. Control of authority

For systems with permission control, the report should, of course, be consistent with the permissions the user has. The control of permissions needs to be verified from two aspects.

1) conditional definition of the report: in the conditional selection area, some drop-down boxes should not be able to display data outside the scope of user permissions. For example, when an ordinary clerk uses a report, the report name drop-down box cannot display the report that can only be viewed by the manager. When some text boxes are divided according to the level of input, you should test the corresponding input of data that exceeds permissions. Note that each entry must be tested here.

2) report content: the content in the report cannot display the data that the user does not have permission to view.

4. Output of report

After the report is generated on the computer, it is not the end of the report. Reports generally need to be printed out for other purposes, such as meetings or submission for approval. So the printing function of the report is also very important. The test is mainly divided into several parts:

1) print Settings

2) print Preview

3) actual printing effect

4) in addition to printing, users may need to export reports for further analysis or comparison with other reports. Therefore, the ability to export reports should also be provided. You can generally export to CSV,Excel,pdf,html,xml format. Look, the company needs it. The main thing here is to check whether the default property of the exported report is read and write, and then whether the exported content is correct, consistent with the generated report.

5. The relationship between report and report

Some reports use the same data, but they are handled differently for different needs. So do some tests between reports and similar reports to see if the data are consistent.

6. Performance of the report

1) after setting the conditions, users hope not to wait too long for the report, of course, sometimes it is reasonable to wait longer when the amount of data is large. But when developing the report or the tester can put forward some ideas to improve the performance of the report.

2) the condition setting area of the report should set the default value to avoid the long wait caused by the user generating the report directly without entering any conditions. For example, the start and end times can default to the current month, and some input text boxes can default to a numeric value based on the user's identity.

3) use similar progress bars to show progress when generating reports to avoid users waiting blindly

4) the statement to generate the report uses the best query statement as far as possible, and debug it several times to check the performance of the statement.

7. The uniqueness of report controls

In general, companies will use special report controls to generate reports, such as MS Report service, Crystal reports and so on. Therefore, it is best to understand the general report generation process and the characteristics of this kind of report controls, so that you can be targeted in the test, rather than blind comparison.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.