Create Report using external data source (ReadCSVfile)

Hi,

I'm trying to create a Backup Client Config report using a .CSV file as external data source.

Basically I'm trying to read from the CSV file the list of clients that the user needs the report for.

I've done the following:

1) Save the ClientName.csv file with the name of the clients on drive C:\ under the Temp folder .

2) This file has only one column with the name of 3 clients (just for the test).

3) Created the report using the default Backup Client Config Report as source.

4) Added the External/ReadCSVFile source to the report

5) Set the READCSVFile source as follow:

Cast String: Text

Field String: ClientName

Filename: C:\Temp\ClientName.csv

Key String: true

Separator: ,

6) Adding a Merge operator to merge both sources

7) Added a condition where Client field (from Backup server mapping Source) must be equal to ClientName (from ReadCSVFile source)

When I run the report I keep getting error message:

C:\Temp\ClientName.txt (The system cannot find the path specified)

I wonder if I'm missing something here.

Any help would be much appreciated

Thanks,