A red "x" appears over a Selected Data path in the Data Selection page

Problem

After a path is added to the Selected Data section, using a CSV (Comma-separated value) file, a red "x" appears, but the report is still able to run.

Example:

1. A CSV file is added as a resource path to the Data Selection page. The entries in the CSV file are formatted without a "type" specified, as shown in Figure 1.

Figure 1 - Example of a entry in a CSV file

http://Sharepoint1/sites/Marketing

2. From Selected Data, a red "x" appears over the path (see Figure 2).

Figure 2 - The Data Selection page, with a red "x" listed over the entry in Selected Data

Cause

A "type" is required, along with the path.

Solution

When using a CSV file to import paths, specify the input type along with path name.

Here are the supported path types:

• Filer
• DFSFiler
• WebApp
• DFSPathPartial
• Share
• DFSPathLink
• SiteCollection
• Folder
• Site
• File

After adding the input type to the CSV file, the red "x" is removed from path.

Example:

Add the "SiteCollection" type to the entry in the CSV file (Figure 3). The specific type will vary, depending on the entry.

Figure 3 - Example of a CSV entry, with the "SiteCollection" type added

http://Sharepoint1/sites/Marketing,SiteCollection

Notice that a red "x" is no longer visible (Figure 4).

Figure 4 - The Data Selection page, with no "x" over the paths in Selected Data