Survey Tabulation > Frequently asked questions
 
Frequently asked questions
This section provides answers to some frequently asked questions about working with UNICOM Intelligence Reporter - Survey Tabulation.
When opening UNICOM Intelligence Reporter - Survey Tabulation I get a message saying: "This page is accessing information that is not under its control. This poses a security risk. Do you want to continue?". What should I do?
Internet Explorer automatically displays this warning message when a page links to another page that is not in the same domain. You can prevent the message from appearing by adding the web site for theUNICOM Intelligence Reporter - Survey Tabulation page to the list of trusted sites in Internet Explorer. To do this:
1 When the above message appears, choose Yes to open the UNICOM Intelligence Reporter - Survey Tabulation web page, then copy the URL for the page.
2 From the Internet Explorer menu, choose Tools > Internet Options.
3 Click the Security tab and select Trusted Sites.
4 Click the Sites button. In the Trusted Sites dialog, enter the URL for the UNICOM Intelligence Reporter - Survey Tabulation web page and click OK.
Note that this adds all pages in the web site to the list of trusted sites, not just the selected page. You may prefer to retain the warning message and just choose Yes when it appears as you open UNICOM Intelligence Reporter - Survey Tabulation.
How do I set up a project for use with UNICOM Intelligence Reporter - Survey Tabulation?
The UNICOM Intelligence Interviewer - Server Admin User's Guide, available from the Index option on the Help menu in the main UNICOM Intelligence window, and the UNICOM Intelligence Developer Documentation Library both include detailed documentation on setting up new projects, including the sample projects.
How can I tell whether I am using the hierarchical or flat view of the data?
You can tell whether you are using the hierarchical or flat view, because UNICOM Intelligence Reporter - Survey Tabulation displays "Hierarchical" or "Flat" next to the project name in the top right corner of the main screen. See Working with hierarchical data for more information.
I have just set up a new UNICOM Intelligence Reporter - Survey Tabulation project and now I am getting errors when I attempt to populate a table. Have you any suggestions about what I should check?
The UNICOM Intelligence Interviewer - Server Admin User's Guide and the UNICOM Intelligence Developer Documentation Library both include tips for testing new projects and what to check when things go wrong. In addition, the UNICOM Intelligence Developer Documentation Library contains detailed documentation on the DSCs that come with the Data Model, including information about their error messages and special requirements.
When I attempt to export tables, there is no visible response in the web browser. What is causing this problem?
UNICOM Intelligence Reporter - Survey Tabulation requires the enablement of Microsoft Internet Explorer's Allow active content to run files on My Computer setting to download and run the tables exports. When this setting is disabled, you will not be able to run exports from UNICOM Intelligence Reporter - Survey Tabulation. Refer to the Internet Explorer help system for information on enabling the Allow active content to run files on My Computer setting. As an alternative, the exports can be manually installed from the UNICOM Intelligence installation media.
I cannot export tables in any format. Have you any idea what is causing this problem?
This problem may be caused by access rights. When you first use one of the different types of exports, UNICOM Intelligence Reporter - Survey Tabulation downloads a component to your computer. For this to succeed, you need to have power user or higher privileges on the computer. When you subsequently export to the same format, UNICOM Intelligence Reporter - Survey Tabulation detects that the component has already been downloaded and does not download it again.
In some cases, the security settings in your browser may prevent UNICOM Intelligence Reporter - Survey Tabulation from downloading export components. .
When I attempt to export my tables to Word, I get a message about a security setting. How do I set it?
The Word Export uses a Visual Basic for Applications (VBA) macro for the export. This requires a security setting to be set. See Microsoft Word export problems for more information.
When exporting to Word, I get "Chart Error" texts in the Word document instead of one or more charts. What causes this error?
The Word Export uses Excel to create the charts, so you must have Excel 2000 or later installed on your computer to export charts to Word. If you get this error text for all charts, check that you have Excel installed. If it is installed, check that it has been installed with the option to embed Excel charts enabled. If this option is not enabled, it would explain the error. Otherwise the chart error is caused by some other problem and may be related to a specific table. See Microsoft Word export problems for more information.
I edited a numeric variable and created a mean element so that I can use the variable in a table. However, when I exported the table to Excel, the chart tab says "A chart cannot be produced for this table". Why is this?
From release 3.1 of UNICOM Intelligence Reporter - Survey Tabulation, charts can be created for special statistical elements, such as a mean or standard deviation, as well as for category, combined, and element expression elements. If a chart is not produced when your table contains a special statistical element, ensure that the orientation of the element in the table matches the setting in the relevant Export Dialog box. For example, if your statistical element is in a table row, select as rows in the Chart series box in the Export Dialog box; if it is in a column, select as columns. See Understanding charts for more information.
When I attempt to export my results to Microsoft Excel, the export fails with the message “Run-time error ‘1004’”. What should I do?
Ensure that you have the latest Microsoft Office service pack installed. To check this, choose the Check for Updates option on the Microsoft Excel Help menu to display the Microsoft Office Downloads page, where you can download the latest service pack.
I am trying to use the <IMG> tag to insert a graphic in a table footer, but the HTML appears as plain text in the HTML export instead of inserting the graphic. Why is this?
You must use well-formed HTML, which has stricter rules than standard HTML. For example, you need to close the IMG tag, like this:
<IMG SRC="C:\MyImages\smile.gif"/>
See also:
http://msdn.microsoft.com/library/ms912456.aspx
I receive a "Maximum Length Exceeded" error when populating numerous tables. What should I do?
This error can be resolved by increasing the jsonSerialization maxJsonLength setting in the web.config file for the UNICOM Intelligence Reporter - Survey Tabulation Frontend and WebService:
The UNICOM Intelligence Reporter - Survey Tabulation Frontend web.config file is:
C:\InetPub\wwwroot\SPSSMR\mrTables\Frontend\web.config
The UNICOM Intelligence Reporter - Survey Tabulation WebService web.config file is:
C:\InetPub\wwwroot\SPSSMR\mrTables\WebService\web.config
1 Open each web.config file and locate jsonSerialization maxJsonLength.
2 Change the value to the following:
<jsonSerialization maxJsonLength="5000000" />
5000000 is the recommended value. This value prevents the error in most situations and does not decrease the web site’s concurrency and performance.
3 Restart the Internet Information Services (IIS) service after modifying the value.
How can I make large projects load faster in UNICOM Intelligence Reporter - Survey Tabulation?
Projects with very large numbers of questions might load slowly or not load at all.
To make them faster, use the Interviewer Server Administration - Project Editor to create a LoadVariableInstances property at the top level for the project, and then set its value to False. This avoids loading variable instances for grids and loops; however, it also prevents you from adding a grid or loop to the table by using the variable list.