The charts within the Summary and Summary Dashboard reports use a Chart Style that is saved within the Styles folder of Snap XMP Desktop.

In order to edit the format of the charts within these 2 reports, the Horizontal Bar Summary Report chart style needs to be edited.

Steps

1. Create a chart using the Horizontal Bar Summary Report style
2. Make the required styling edits to the chart
3. Save the chart style, replacing the original
4. Run the reports to check the are reports are as expected

1. Create a chart using the Horizontal Bar Summary Report style

2. Make the required styling edits to the chart

Double click on a blue bar, open the Series1 folder and select Datapoint Defaults

Edit the Fill Color, using the RGB (Red / Green / Blue).

3. Save the chart style, replacing the original

Right click to Save Style

Save the chart style (using the original name of Horizontal Bar Summary Report) in the Styles folder of Snap XMP Desktop.

This will replace the original file.

As a backup, you might wish to store a copy of the original file elsewhere, should you wish to go back to the original style at a later date.

4. Run the reports to check the are reports are as expected

The post Changing the colour of the default Summary Reports appeared first on SnapSurveys.

To find more information on all the standard reports, see The standard reports.

Executing the Summary Dashboard report

1. Click Reports  on the toolbar to open the Reports window.

2. Select the Summary Dashboard report in the Reports window.
3. Click the Execute  button on the Reports window toolbar to run the report. This opens the Report Execution dialog showing the report selected in the window title.

4. In To, select Export as the output type. This exports the report to a file.
5. In Type, select the file type as Web Format (HTML).
6. Tailor allows you to set the file details for the exported report
7. Click OK to export the report. This opens the Export file details dialog.
8. Enter the file name giving the location where the HTML file saves.
9. Enter the file numbering, output method, encoding and sizing for the export file.
10. Click OK to export the file.
11. From the file location, open the file. The report opens in a web browser displayed in a two-column layout. Each chart or table image can be saved as an image file to be used elsewhere. (This may depend on the web browser used.)

Changing the standard Summary Dashboard report

You can change the content of the Summary Dashboard report.

1. Click Reports  on the Snap XMP Desktop toolbar to open the Reports window.
2. In the Reports window, double-click on the Summary Dashboard report to open it. It consists of five instructions. There are three instructions laying the report out, an Information instruction giving the title and a brief description, and a Summary Report instruction.
3. Double-click the Information instruction to open it. You can change the default description.

4. Double-click the Summary Report instruction to open it.

5. Specify a Filter to restrict the data used in the report.
6. In the N/A box enter a logical expression that refers to a table cell or context value and for which the report is not applicable. You can use this to test if an analysis is empty. For example, if you have an analysis of visitors AN1, you can use the condition AN1 empty. This would only build the report if there were visitors.
7. In the Content box enter the variables that you wish to include. If the field is left blank, all the question variables will be included. You can include paradata and derived variables in the list.
8. Click OK to save your changes.
9. Click Execute  on the Report toolbar to run the report.

The post Running the Summary Dashboard report appeared first on SnapSurveys.

In Snap XMP, reports are built up using instructions. These instructions allow you to add text, graphics, and analyses to a report. When the report is run, the current response data is inserted into the analyses and text information.

You can insert references in your instructions. When the report is run these references are replaced with data from the survey or responses.

In Snap XMP you can insert table cell references. If you create a table, you can use references to the row labels, column labels and the table cells in the report text, notes on analyses or even in another table. This means that you can use any data that is in the table in your report, and it will automatically use the latest data.

In Snap XMP Desktop, you can create a ranked table and order the columns from highest to lowest. This means that you can automatically place the highest and lowest values in your report without needing to edit them.

This tutorial explains how to create a simple report showing satisfaction rankings. The report uses data from analyses in the report text and shows how to use ranked tables to headline important points. For example, you can automatically include the aspects your customers are least satisfied with.

This tutorial uses the Course Evaluation survey which is distributed as a sample survey with Snap XMP Desktop.

How table cell references work

Cell references are a means of inserting automatically updated data in a report (or in the notes for an analysis). A cell reference is the position of the data in the specified table.

The cell referred to can be:

• A row label (describe by tablename RN label e.g., AN1 R1 label
• A column label (describe by tablename CN label e.g., AN1 C1 label)
• A data cell described by its row and column number (describe by tablename RNCN e.g., AN1 R1C1)
• A statistic value described by its row and statistic number (where its statistic number is its position in the list of statistics, S1 being the top, given by tablename RNSN e.g., AN1 R1S1)

where N is replaced by the row or column number.

Once you have inserted the cell reference into the report, any filters applied to the whole report are applied to the table containing the referenced cell.

You can use any analysis as the basis for the reference. For example, if you wish to insert a reference to data in a chart, view the chart as a table to find the cell reference then redisplay it as a chart.

You can find out what the code for a given cell is by putting the cursor on it or clicking it. The cell reference information will be displayed in the status bar.

You can also find the cell reference details by double-clicking the cell and checking the information in the Override Analysis Value dialog.

Step 1: Deciding what goes into your report

When you create a Smart Report, it is important to plan your report. The simple report used in this worksheet will include:

• a title
• a sentence giving the number of people totally satisfied with course content (from the table AN4)
• a sentence giving the topic that most needs improvement (using ordered gap analysis)
• the gap analysis chart AN15

Step 2: Creating the instructions

The report will contain a title, an information line, and an analysis.

Add the title

1. Click Reports on the Snap XMP Desktop toolbar to open the Reports window.
2. Click New Report   to create a new report. This is created with a Tailor Analysis instruction.
3. In the Report details, click New Instruction   then select Information from the menu to add a new Information instruction.
4. In the Information window, enter the title for your report in the text pane. Leave the Title field blank (this is the title of the Instruction). Style your title text by selecting text and using the format buttons.

5. Click OK to save the instruction.

Create the satisfaction reference

1. Click Analyses on the Snap XMP Desktop toolbar to open the Analyses window.
2. Open the grid table AN4 to check which cells you need. The report uses the label of the first row, and the value in the fifth column of the first row.

3. Close the table and the Analyses windows.
4. Return to your report and add another Information instruction.
5. Enter the text “The number of people who were totally satisfied with the ” then click the Insert button and select Cell Value Field from the menu. This opens the New Cell Value Field dialog.

6. Enter the reference AN4 R1label in the box and click OK. This will put the contents of the label for row 1 of analysis AN4 in your report. When it appears in the report, it will be in curly braces. Note that the Base row is row 0.
7. Add the text ” was: ” and then insert another cell value of AN4 R1C5. Style the text and references.

8. Click OK to save the Information instruction.

Insert the gap analysis table in your report

1. In the Report details, click New Instruction   then select Execute from the menu to add a new Execute instruction.
2. In the Execute dialog, select AN15 (the Gap Analysis chart) from the Execute list.

3. Click OK to add the Execute instruction to the report.

4. Click Save to save the report.

Step 3: Testing your report

It is important to check that your report looks the way you want it and is picking up the correct data.

1. Click the Execute  button on the Report toolbar. This opens the Report Execution dialog with options to Check, Preview or run the report.
2. It is a good idea to check and preview your report on screen before sending it to a printer. Click the Printer button to select to print to a pdf file or to paper.
3. Click OK to close the printer window and then click OK to run the report. Your report will look something like this.

4. Check that the data that appears in the report is from the correct table cell. The chart includes the description, title and notes. You can stop those appearing by changing the Analysis Definition.
5. Click Analyses on the Snap XMP Desktop toolbar to open the Analyses window.
6. Open the chart AN15 and select Properties to open the Analysis Definition.
7. Select the Report Styles tab and clear the Reports Include options: Description, Notes, Analysis Text, and Title.

8. Click OK to save your changes.
9. Click Save to save the analysis
10. Click Execute on the Report toolbar to and run the report again. Your report will now look something like this.

Step 4: Putting in the best and worst values

You can put the highest and lowest values in a report automatically. This step shows you how to put the area needing the most improvement in the summary line by using a sorted table.

Create a sorted table

1. Select AN15 in the Analyses window.
2. Click Clone Analysis to make a copy of it.
3. In the Analysis Definition window showing the cloned analysis, change the Type to Table and the Order to Mean. This sorts the columns in order by the mean value, so the highest value will always appear in the first column and the lowest in the last.

4. Click OK to display the table.
5. The lowest value in this table is in the fourth column. You can reference the column label to show which area is most in need of improvement.

6. Click Save to save the table.

Add the area needing most improvement to the report

1. Open your report.
2. Open the second Information instruction (instruction 3).
3. Add the text “The area most in need of improvement is :”.
4. Insert the cell reference AN19 C4label to insert the label of the fourth column.
5. Click OK to save the changes.
6. Click Execute  to save changes and run the report again. Your report will now look something like this:

When more responses come in, you can run the report again, and it will be updated with the new data. If the outcomes are different, that will automatically be carried through to the report.

If there is a topic you would like a tutorial on, email to snapideas@snapsurveys.com

The post Creating reports that include automatic text appeared first on SnapSurveys.

In Snap XMP, you can include the filter and the number of filtered cases in a report instruction using a Survey field. When the filter is changed, the filter survey fields in the instruction will show the updates when the report is run.

In this tutorial, the Summary report is used. The Summary report is supplied with Snap XMP Desktop and each questionnaire contains this report. This report can be customised as required in the questionnaire.

Step 1: Inserting the survey field in your report

1. Click Reports  on the Snap toolbar to open the Reports window.
2. Select the Summary report and click  to make a copy of it. This will ensure that you can go back to the original if you make any mistakes.
3. Close the copy and open the Summary report.

4. Double-click the Information instruction to open it. The text may vary depending on the version of Snap or survey template used to create the questionnaire. The instruction shown is from a questionnaire created in Snap XMP Desktop using the Blank Template. This instruction already includes a sentence showing the number of filtered cases. The following instructions show how to add this sentence.

5. Click in the text area where the text will start and type ‘A total of ‘
6. Click the Insert button and select Survey Field from the options.

7. In the New Survey Field dialog, select Cases(Filtered) as the Field. In Modify case, select Normal as the case.

8. Click OK to insert the field.
9. Enter the remaining text ‘ cases fall into this category.’
10. Click OK to save your changes to the instruction.
11. Click Save to save the changes to the report.

Step 2: Applying the filter

1. Add the filter to the Filter field at the top of the report window. For example, using the question Q1. Are you a member of Activate Swimming Club?

2. To create a report on all the members of the club, enter Q1=1 in the Filter field.

3. Click the Execute  button on the report toolbar to run the report.
   The data that you have referenced will be filtered, so that when you run the report, you will see the number of filtered cases.

4. When you are happy with the new version of the report, delete the cloned back-up report.

If there is a topic you would like a tutorial on, email to snapideas@snapsurveys.com

The post Including the number of filtered cases in a report instruction appeared first on SnapSurveys.

The analyses used for each question:

• Multiple and single response questions are displayed as horizontal bar charts
• Literal (free text) responses are displayed as lists.
• Quantities are displayed as statistics tables

This worksheet describes how to adapt the Summary Report to reflect your organisation’s needs and branding. This worksheet covers how to:

• Change the report description
• Change the default headers and footers
• Choose the content that appears in the report
• Filter the response data
• Add a weight to your data

Step 1: Changing the report description

1. Click Reports on the Snap XMP Desktop toolbar. This opens the Reports window.
2. In the list of reports, select the Summary report.
3. Click Clone to make a copy of it. This ensures that you can go back to the original if you make any mistakes. The cloned report contains five instructions; the first three set the defaults and page layout of the report, an Information instruction giving the title and a brief description and a Summary Report instruction which displays the analysis charts, tables and lists.

4. Double-click the Information instruction. This opens the Information dialog where you can edit the description. The default description uses survey fields to insert information automatically. The Insert button on the toolbar can be used to insert an image, variable fields, survey fields, date and time fields, HTML fields or cell values.
5. Click OK to save your changes and return to the report details.
6. Click Execute/Check report on the report toolbar to check and run the report.

Step 2: Changing the report headers and footers

If you wish to have graphics in your header or footer, it is best to create them at the correct size before you start creating your report.

You can place a running header or footer in your report by using a page layout instruction. This also allows you to put thumb text in your report. (This is text that runs vertically in the margin of your report.)

1. Open your cloned summary report.
2. Double-click the Page Layout instruction to open it.
3. Select the Page Setup tab.
4. Select Headers, Footers and Thumb Text. This enables the Header/Footer button.

5. Click Header/Footer to open the Headers/Footers dialog. It opens showing the default values.

Inserting header, footer and thumb text

The header and footer each consist of three areas (left, centre and right). The thumb text runs from bottom to top in the margin and can include titles for different parts of your report. By default, it appears in the right margin of every page.

Click inside the appropriate area and enter any free format text. Use the format toolbar to set the font name, size, style and color. The header and footer justification is fixed for each area. Select the Margin value to set the thumb text justification. Right edge places it on the right hand edge of every page; Left edge is the left edge of every page (suitable for single-sided reports). Outside edge alternates between the left and right starting on the right edge, Inside edge alternates starting on the left edge (suitable for double-sided reports).

Inserting images and survey information

In addition to free format text the header and footer and thumb text may also contain:

• images (header and footer text only)
• variable fields
• survey fields
• date and time of publication

These are inserted using the Insert button

• To add an image: Click Insert and select Image from the menu. Images can be graphics files with.jpg, .gif or .bmp format
• To add a variable field: Click Insert and select Variable Field from the menu. Using the [Insert] button gives more flexibility in the way the text is displayed. Select a variable, aspect and case to insert from the lists in the New Variable Field dialog.
• To a survey field: Select the survey field from the drop-down list in the top left corner in the toolbar, or click Insert and select Survey Field from the menu. Using the Insert button gives more flexibility in the way the text is displayed. Select a field property to insert from the list in the New Survey Field dialog.
• To add the date/time: Click Insert and select Date/Time Field from the menu.

When you have set up the headers, footers and thumb text, click OK to leave the Headers/Footers dialog. Click OK to close the Page Layout instruction.

Step 3: Choosing the content of the report

In the default Summary Report the Content field is blank and this setting includes all the variables that are visible in the questionnaire. You can choose which variables are in the report by listing them in the Content field. You can add any variable to your report except date and time variables. This includes derived variables and system variables known as paradata.

You can enter:

• A list of variable names, where the names are separated by commas (e.g. Q1, Q2, Q4, Q5).
• A range of variables, where you have the first and last variables separated by the character ~ or the word TO.

1. In the Summary report details, double click the Summary Report instruction. This opens the Summary Report instruction details dialog.
2. In the Content field, enter the variables required or leave blank to show all the visible variables. This example will show questions Q0 to Q4, Q5 to Q12 and Q14. The analyses will always appear in the order they are in the questionnaire, rather than the order that you enter them in the Content field.

3. You can limit the contents of your analyses by setting the maximum number of bars in bar charts and items in lists. If you limit the number of codes, bars are shown for the codes with the most responses. You can choose whether to limit list entries to the earliest or most recent responses.
4. Select Describe limits with the report to add a line to your report describing the limits you have set.
5. Click OK to save your changes and return to the report details.
6. Click Execute/Check report on the report toolbar to check and run the report.

Step 4: Changing your report data

You can change the data in your summary report using filters and/or weights. If you add a filter to the whole report, the default Information instruction will include a reference to it. If you add a weight, you should edit the Information instruction to describe how your data has been weighted.

Adding a filter to the whole report

1. Open your cloned report.
2. Add the filter to the Filter field at the top of the report window. For example, using the demographic question Q12. Are you male or female?
3. Enter Q12=2 in the Filter field to create a report using only the data from women.

Weighting your data

1. Open the Summary Report instruction.
2. Apply the weight to the report by entering it in the Weight field and click OK. For example, WT1 has been created to balance the numbers of men and women and then applied to the gender variable (Q12). This weights the data supplied by men and women.

3. Add the information about the weight that you have applied to the Information instruction and save your changes.
4. Click Execute/Check report on the report toolbar to check and run the report.

Further information

If you would like to find out more about Snap reports, see the help section Introduction to Smart Reporting.

For information about the report instructions see Adding report instructions.

To find out about filtering your data, see Filter expressions.

For more information about weighting your sample data, see Using weights.

If there is a topic you would like a tutorial on, email to snapideas@snapsurveys.com

The post Adapting the Summary Report appeared first on SnapSurveys.

This worksheet shows you how to run the Summary report to context and produce a report output for each context.

Step 1: Open the Summary report

1. Click on the Snap XMP Desktop toolbar to open the Reports window.
2. Double click the Summary report. This opens the Report Summary, including the instruction list, for the Summary report.

Step 2: Set up the context

1. In Context, enter the question name that contains the context. In this example, the question Q1 contains a location and the report will be created for each location. (It makes life simpler if your variables have meaningful names. For example, you can change the name from Q1 to Location in the Variables Details window.)
2. In Filter, enter Q1=Q1@Context. This filters each report using the current context.

3. Click to save the changes.

Step 3: Choose the questions that appear

You can set the questions that are displayed in the report. This can be useful to exclude any questions that ask for personal details, such as, name or email address.

1. In the Report Summary, double click on the Summary Report instruction (number 5).
2. In Content, enter the list of questions that are shown in the report. In the example, Q1 and Q3 to Q5 and Q7 to Q9 are included.

3. Click OK to save the content to the instruction then click to save the report.

Step 4: Create a document for each context

You can create a document, for example, as a PDF, for each context by editing or adding a Page Layout instruction. This instruction should be at the start of the report.

1. In the Report Summary, double click on the Page Layout instruction (number 2).
2. In the Page Layout, select Start New Page, Restart Page numbers and Start New Document. This sets the report up to create a new document for each context.

3. Click OK to save the Page Layout instruction then click to save the report.

Step 5: Run the report

1. In the Report Summary, click to open the Report Execution dialog.
2. Choose your preferred output, either printing to a printer or to files, or exporting to one of the available formats.

3. Click OK to run your report. This produces a copy of your output for each context, such as location.

The post Running the Summary report to context appeared first on SnapSurveys.