Primary Content The Primary Content page is default category. You need to configure one or more elements in this page to get started using this web part. Primary Content contains the following: Table 1. Primary Content Element Description Title Allows you to enter a title for the Web Part, or accept the default. This field is mandatory. Session Name Allows you to enter the name of the Session variable where the Excel Viewer expects to find all the information that has been set by a qListView. This name must match the Search Session Name in qListView. Show Header Allows you to show the column name in the first row. Display Fields See Display Fields. Child View Display Fields Defines the fields that should be displayed in the view for the child record. For more information, see Child View Display Fields Display Fields This property defines the fields that should be displayed in the Excel spreadsheet. This property is optional if the properties in the Custom Display section are specified. In that case, the default display for the search results is turned off and the custom display is used. You can also combine a custom display with the Display Fields; for example, if you want to display the data in the grid and to provide the summary of the data or disclaimer using the custom display. The Display Fields section contains the following: Table 2. Display Fields Element Description Advanced Mode Turn on if you want to edit Display Fields in XML format: <Fields LookupThresholdControlSetting=”On”> <Field Name="fieldName" [optional attributes]/> <Field Name="fieldName" [optional attributes]/></Fields> Query All Fields Controls how Web Parts behave in relation to the Excel View Lookup Threshold in SharePoint Resource Throttling. The options are: • Default — uses the level set in the Configuration Editor. If you have selected Query All Fields check box in the Configuration Editor, the Web Part will query only those fields that are not included in the Excel View Lookup Threshold. If the Query All Fields check box is cleared, the Web Part will query all fields. • On — If the Web Part level is On, the Web Part queries all fields in lists, except Lookup fields. • Off — If the Web Part level is Off, the Web Part queries all fields in lists, including Lookup fields. • Explicit — If the Web Part level is Explicit, the Web Part queries only those fields selected in the Display Fields. This option renders the best performance for your Web Part. Title Allows you to set the title for the field header. This is useful if the real field name is too long and you want to abbreviate the title in the field header, or if you simply want to display a different title in the field header. If this attribute is not specified, the value specified in the Name attribute is used in the field header. Field Type Indicates the type of the field selected. This is a read-only field and displays for all available list templates. Align Allows you to set the alignment for the field. Display Field Name Allows you to specify the name of a field in the cross-site list. You only specify this if the field that you are trying to display is a cross-site lookup field. If you want to display multiple fields from the cross-site lookup field, use the Display Format. Display Format Allows you to set the format of the value that is displayed in a cross-site lookup field. You use this attribute if you want to display values from multiple fields. NOTE: You can use the field replacement expression <%Field%> to refer to a field. If you are using Advanced Mode, you must use the encoded form of the < and > characters, which are < and >, respectively, unless you use the Excel Viewer Editor which will encode it automatically for you. For more information, see Display Format