Query location

<< Click to Display Table of Contents >>

Navigation:  FastReports > Report datasets >

Query location

Dispatch will load and execute SQL queries from a folder named DMFastReport which must located in the folder specified by the Common SQL property.

 

C:\Users\Public\Documents\CanScale\Dispatch 3.2\SQL\DMFastReport

 

This applies to SQLite, PostgreSQL and SQL Anywhere database servers.

Driver specific queries

For all other servers, SQL queries used by FastReports must be located in a folder named DMFastReport which be located in the folder specified by the Driver SQL property.

 

clip0478

Example

When using a Microsoft SQL Server database, the default location of FastReport queries is as follows:

 

C:\Users\Public\Documents\CanScale\Dispatch 3.2\MSSQL\DMFastReport