<\/a><\/p>\n Reports are built up using instructions.<\/p>\n Instructions allow you to put text, graphics and analyses in a report. When the report is run, Snap or Snap WebHost will insert the current response data into the analyses.<\/p>\n You can insert references <\/em>in your instructions. These references mean that Snap will replace the reference with data (similar to a mail merge in MS Word). For example, use the reference {cases} to insert the current number of responses in your report. E.g.,<\/p>\n “{cases} people have completed our survey”<\/p>\n In Snap 11 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.<\/p>\n This means that you can use whatever data is in the table in your report, and it will automatically pick up the latest data. You do not need to copy and paste.<\/p>\n You can reference the data you want to insert by row and column number, or by the statistics number.<\/p>\n For example, the table (AN21<\/b>) shown below has row and column data, and two statistics.<\/p>\n You need to know which row, column, statistic or label you wish to reference.<\/p>\n The example shows the instructions needed to insert data from the table. The reference is made up of the name of the analysis you wish to reference followed by a space, then a code to identify the cell to use.<\/p>\n The code is made up of letters representing row (R), column (C), statistic (S) or label, and numbers identifying which item you want.<\/p>\n 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.<\/p>\n You can also find the cell reference details by double-clicking the cell and checking the information in the Override Analysis Value dialog.<\/p>\n When the report is run, it will use the current data, for example<\/p>\n In Snap 11, you can order the table 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. For example, this shows a ranked table.<\/p>\n Using cell references to column 1 label and column 1 row 1, etc. you can insert the ranked values into a report without needing to know what they are.<\/p>\n This worksheet explains how to create a simple report showing satisfaction rankings.<\/p>\n Step 1: Deciding what goes into your report When you create a Smart Report, it is very important to plan your report, as if all goes well, you can use the same report for years. The simple report used in this worksheet will only include:<\/p>\n The report will contain a title, an information line and an analysis.<\/p>\n Adding the title<\/strong><\/p>\n Adding the satisfaction reference<\/strong><\/p>\n Note that the Base row is row 0.<\/p>\n Remember to leave a space after the table name.<\/p>\n Add the gap analysis table to your report<\/strong><\/p>\n It is important to check that your report looks the way you want it and is picking up the correct data.<\/p>\n 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<\/b>.<\/li>\n 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.<\/p>\n Create a sorted table<\/strong><\/p>\n Add the area needing most improvement to the report<\/p>\n If more responses come in, you can simply 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.<\/li>\n<\/ol>\n <\/a><\/p>\n This worksheet has described how to create a Smart Report that you can run at any time. It explained how to put in table cell references so your report automatically uses the most up-to-date data. It also covered creating a sorted table so you could automatically insert information about the best or worst performing area without needing to know which area that was.<\/p>\n If there is a topic you would like a worksheet on, email to snapideas@snapsurveys.com<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"Background<\/h3>\n
How references work<\/h3>\n
![\"Smart](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/08\/tab_ref_ex.png\")
<\/p>\n![\"Smart](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/08\/tab_ref_map.png\")
<\/p>\n![\"Cross](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/08\/xtab_cellref_hl.png\")
<\/p>\n![\"Printer](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/08\/tab_ref_inf.png\")
<\/p>\n![\"References](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/08\/tab_ref_rep.png\")
<\/p>\n![\"Ranked](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/08\/sm_rank_tab.png\"){kind=icon}
<\/p>\n![\"Rank](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/08\/rank_rep.png\"){kind=icon}
<\/a><\/p>\nSummary of steps<\/h3>\n
\nStep 2: Creating the instructions
\nStep 3: Testing your report
\nStep 4: Putting in the best and worst values<\/p>\n<\/a>Step 1: Deciding what goes into your report<\/h3>\n
\n
<\/a>Step 2: Creating the instructions<\/h3>\n
\n
![\"Batches](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/08\/batch.png\")
on the Snap toolbar to open the reports window. You will see the two default reports.\n![\"Default](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/08\/reports_dial_def.png\")
<\/div>\n<\/li>\n![\"add\"](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/09\/add.png\")
\u00a0 to create a new report. By default this will have a Tailor Analysis<\/b> instruction in and nothing else.<\/li>\n\u00a0 on the report dialog and select Information <\/b>from the drop-down menu to add a new Information\u00a0<\/b>instruction.<\/li>\n![\"Information](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/08\/inf_title.png\")
<\/p>\n<\/div>\n<\/li>\n\n
![\"Results](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/08\/results.png\")
on the Snap toolbar to open the Analyses <\/b>window.<\/li>\n![\"Smart](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/08\/grid_cell_hl.png\")
<\/p>\n<\/div>\n<\/li>\n![\"Smart](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/08\/inf_ins_hl.png\")
<\/p>\n<\/div>\n<\/li>\n![\"New](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/08\/ncv_an1.png\")
<\/p>\n\n
![\"Printer](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/08\/inf_cel_ref_hl.png\")
<\/p>\n<\/div>\n<\/li>\n\n
\u00a0 on the report dialog and select Execute <\/b>from the drop-down menu to add a new Execute<\/b> instruction.<\/li>\n![\"List](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/08\/list_dwn.png\")
on the Execute <\/b>dialog and select AN15 <\/b>(the Gap Analysis chart) from the list.<\/li>\n<\/ol>\n![\"Execute](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/08\/ex_an14.png\")
<\/p>\n\n
![\"Report](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/08\/rp1_four_eval.png\")
<\/p>\n\n
![\"Save](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/08\/save.png\")
to save the report.<\/li>\n<\/ul>\n<\/a>Step 3: Testing your report<\/h3>\n
\n
![\"Go\"](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/09\/12258.png\")
\u00a0button on the report window toolbar to run the report.<\/li>\n![\"Report](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/08\/ws_rep_1.png\")
<\/div>\n on the Snap toolbar to open the Analyses <\/b>window.<\/li>\n![\"analysis](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/08\/at_rep_inc_hl.png\")
<\/p>\n<\/div>\n<\/li>\n on the report window bar to and run the report again.<\/li>\n![\"Report](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/08\/ws_rep_2.png\")
<\/div>\n<\/li>\n<\/ol>\n<\/a>Step 4: Putting in the best and worst values<\/h3>\n
\n
![\"Clone](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/08\/clone.png\")
to make a copy of it.<\/li>\n![\"Analysis](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/08\/def_order_mean_hl.png\")
<\/p>\n<\/div>\n<\/li>\n![\"Order](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/08\/ord_mean.png\")
<\/p>\n<\/div>\n<\/li>\n to save the table.<\/li>\n<\/ol>\n\n
![\"Information](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/08\/inf_cel_ref_hl3.png\")
<\/div>\n<\/li>\n\u00a0to save changes and run the report again.<\/li>\n![\"Report](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/08\/ws_rep_3.png\")
<\/div>\nConclusion<\/h3>\n
\n