Creating a File Report - Reportizer Documentation

File report is a report which is based on your file system instead of a database. It operates with your folders and files in a way similar to database tables with a limited set of fields, but it does not use database connections at all.

It is possible to create a new report either by cloning an existing report or by creating a new report from scratch. Here, the latter option is described.

Click Create Report button.
Specify the database. In the list of registered database, select the database of FileSystem type which point to the needed folder in your file system. If the database not in the list, register it using these steps:
1. Click '...' button to invoke a Open Data Source dialog.
2. Choose FileSystem interface.
3. In the table of the connection parameters below, specify the Database parameter. It must be a root folder which your report will work with.
4. Choose a friendly alias for your database and click OK.
Choose XML Description as the dataset type. The following XML code will appear:
```
 <Source>FILES_AND_FOLDERS</Source>
   <Options>
    <FileMask>*.*</FileMask>
    <IncludeReadOnly>0</IncludeReadOnly>
    <IncludeHidden>0</IncludeHidden>
    <IncludeSystem>0</IncludeSystem>
    <IncludeSubFolders>0</IncludeSubFolders>
   </Options>
  </Dataset>
```
This code tells the application which folders and files inside the root folder must be processed by the report:
- Source Specifies which item types of the root folder must be processed. Possible values:
  - FOLDERS
  - FILES
  - FILES_AND_FOLDERS
- FileMask Specifies the mask of files to process. For example: *.png;*.jpg;*.jpeg.
- IncludeReadOnly Specify 1 to include read-only files and folders and 0 to not include them.
- IncludeHidden Specify 1 to include hidden files and folders and 0 to not include them.
- IncludeSystem Specify 1 to include system files and folders and 0 to not include them.
- IncludeSubFolders Specify 1 to include sub-folders and 0 to not include them.
Select fields of the data source, for which you wish to automatically create headers, data showing objects and totals expressions. Note, that not selected fields will still available for you later, when you will edit the created report. Since the source is not a database, we have a fixed set available fields:
- FileFolderMark Holds 1 for files and 0 for folders.
- FullPath Holds full path to the file/folder.
- ItemSize Holds size of the file. For folders, it holds 0.
- ItemLastModified Holds date and time of the last file/folder modification.
- ItemCreated Holds date and time of the file/folder creation.
- ItemLastAccessed Holds date and time of the last file/folder access.
- ItemName Holds the name of file/folder. For files, it includes the file extension.
- ItemType Holds file extension without a leading period.
Click Next.
Select other options (if you wish) and click Finish.

After saving the report, the corresponding repository refreshes its report list and the last created report will be automatically selected, so, you can finish with the visual part of the report in the report builder.

See also

Creating Reports

Report Builder