After running a search you can view the results in a columnar report including all question type responses. For searches where the data comes from category or integer questions, you can also choose to view frequency and cross tabular reports.
The search queue displays all reports that have been run or scheduled. More info on managing the search queue...
To view a search report, locate the search in the queue and click the Columnar, Frequency or Cross Tabular button in the View column. Only searches with the status of Complete can be viewed.
The search name and study name are displayed at the top of each report.
Columnar reports show a column for each piece of data that was specified by the search creator. Separate columns are created for different cycles of a visit, eForm or question but question cycle numbers are only shown if there is more than one row in the repeating question group. A row is created for each subject, with the mostly recently added subject at the bottom.
Columns are displayed in study order (visit/eForm/question). You can click on a column heading to re-order the data. Click once to change to ascending order, click twice to change to descending order, and click a third time to return to the default order.
If your report exceeds the maximum number of columns then before the report is displayed you will be asked to choose which columns to include. Select a column from the left panel and use the right arrow button to move it to the right column. You can select multiple columns and move them together. All columns in the right panel will be included in the report. You can order the columns in the right panel by using the up and down arrows. The top column will be the first column in the report and so on.
When viewing a columnar report, you can filter it by typing into the column filter underneath a header, then clicking the filter icon and choosing the type of filter. The report is refreshed to only show data that matches your request. For example, if you have three subjects with subject labels TLR4, LPV8 and LTS2, and you enter 'T' into the filter in the Subject Label column, then choose 'Contains', the report will be refreshed to show only TLR4 and LTS2, as they both contain a 'T'. You can add multiple column filters to a report. To remove a filter, click the filter icon and select 'No filter'.
You can choose to view category question responses as just the code, just the description, or both code and description. To change this, right click anywhere within the column itself (not the header) and select your preferred option.
All date values are shown in the international date format 'YYYY/MM/DD', even for questions where the study designer has specified a different format for data collection.
Clicking on a value in the report will open the eForm containing that value. You can navigate through the study and view, change and save data as required. When you close the current eForm, you will return to the search report.
Columnar reports only display data to which you have access, as defined by your user role.
By default, a maximum of 50 records can be displayed on each columnar report page. You can change this 'Number of records per page' in Tools > Options > Environment > General.
Your administrator may have set a maximum number of columns that can be viewed in a web browser. If you see a message alerting you that the report you are viewing has a restricted number of columns, you can download it to view the full content. How to change this
You can export a columnar report in CSV, Excel or SPSS format.
CSV and Excel reports are downloaded as a .zip file containing the report file and a separate metadata file. SPSS reports are downloaded as a .sav file.
When exporting to CSV and Excel you can choose to display category question responses as codes or descriptions. When exporting to SPSS they are always displayed as codes.
When exporting to SPSS, the variable
type for integer number questions is set to Numeric. The variable
type for number questions using decimals (real number and laboratory
questions) is based on the machine regional settings and will be set
to either Comma or Dot accordingly. The variable type for full dates
is set to Date, and the variable type for partial dates is set to
String, or Number if only yyyy is given.
Full dates display in SPSS in the following formats only, regardless
of the date format specified in MACRO:
dd.mm.yyyy
dd-mm-yyyy hh:mm
dd-mm-yyyy hh:mm:ss
See example of a columnar report
Frequency reports show a count of category or integer questions with the same response value (including Missing, Not Available and Not Applicable values. See explanation of these statuses...). For example, if the question 'sex' has been answered four times; three times with 'male' and once with 'female', and has two occurrences of the Missing status, then three rows will be included for the question, once for each response value, and a count of each value is displayed in the Frequency column: 3 (male), 1 (female) and 2 (Missing).
The top row shows the total number of responses for the question, and the total number of subjects who answered the question.
In each following row, the percentage of the response frequency compared to total responses for the question is displayed in a % Total column (rounded to two decimal places).
You must select a question to use in the on-screen report. Note that when downloading a frequency report, all category and integer questions in the study will be included.
Clicking on a row will switch the report to columnar view to show the subjects with this value. For example, clicking a question with a frequency count of 6 will show all 6 rows in the columnar view, one row for each subject with the same value.
Frequency reports can be set to show all study data in the counts, or to only show data for sites you have permission to access. If they have been set to show all data, this may result in discrepancies between the counts in the frequency and columnar reports as columnar reports only show data you have permission to access. For example, a frequency report may show 10 occurrences of a particular question response. 6 of these are from site London and 4 from site Paris. If you only have access to site London then the frequency report will show all 10 responses but when you switch to the columnar report, only 6 rows will be displayed. Administrators can change the count access setting by editing the web.config file.
You can export a frequency report in CSV, Excel or SPSS format.
In a CSV file, the following values are converted: Missing becomes -7, Not Available becomes -8, and Not Applicable becomes -9.
When exporting to SPSS, variable types for integer number questions are set to Numeric.
See example of a frequency report
Cross tabular reports (also known as cross, pivot or multi-dimensional tables) enable you to compare response values from two category or integer questions.
You choose a question to be displayed vertically (as rows) and a question to be displayed horizontally (as columns). Every occurring value is listed for each question, enabling you to summarise the data and identify any possible patterns.
As well as response values, counts of Requested, Missing, Not Applicable and Not Available responses are included. See explanation of these statuses...
A total count for each row and column is displayed. Clicking on a response value, status count or total count will switch the report to columnar view showing data for the appropriate subjects. For example, if a category question response has 1 value of Missing, 3 values of Male and 2 values of Female, clicking the total count of 6 will show 6 rows in the columnar view, one row for each subject. However, there may be discrepancies between these two reports for the following reasons:
Cross tabular reports can be set to show all study data in the counts, or to only show data for sites you have permission to access. If they have been set to show all data, this may result in discrepancies between the counts in the cross tabular and columnar reports as columnar reports only show data you have permission to access. For example, a cross tabular report may show a total count of 6 but if 2 of these are from site London and 4 from site Paris and you only have access to site London then when you switch to the columnar report, only 2 rows will be displayed. Administrators can change the count access setting by editing the web.config file.
If the same question occurs in multiple eForms, the count in the cross tabular report will include all instances of the question but the columnar report will treat each instance separately within its context. For example, if a question occurs in both the screening eForm and the treatment eForm and has been answered in both places by 4 subjects, the cross tabular report will show a total count of 8 but the columnar report will only show data for 4 subjects.
You can export a cross tabular report in CSV or Excel format (not SPSS).
In a CSV file, the following values are converted: Missing becomes -7, Not Available becomes -8, and Not Applicable becomes -9.
See example of a cross tabular report
To export the results of a search, click the CSV, Excel or SPSS button in the Download column.
Choose the type of report.
Depending on the report type, you may be prompted to select further options.
Click Download. The file is placed in your standard downloads folder. Files are named with the search name followed by the timestamp.
All date values are exported in the international date format 'YYYY/MM/DD', even for questions where the study designer has specified a different format for data collection.
