PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • HFSQL view associated with a report
  • Memory zone associated with a report
  • Embedded query/Independent query
  • Limits
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
..SourceName is used to:
  • Find out the name of the data source for the report.
  • Change the data source of the report.
Reminder: the name of the data source for the report can correspond to:
  • the name of a data file (for the reports based on a data file, a view or a memory zone).
  • the name of a text file (for the reports based on a text file with automatic reading of records).
  • the name of a query.
  • a Table control found in a window.
The data source of a report can be a query of a data file.
Versions 18 and later
iPhone/iPad This property is now available for the reports in the iPhone/iPad applications.
New in version 18
iPhone/iPad This property is now available for the reports in the iPhone/iPad applications.
iPhone/iPad This property is now available for the reports in the iPhone/iPad applications.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 21 and later
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
Example
// Change the data file associated with the report
// Switch from Customer data file to Prospect data file
RPT_CustomerReport..SourceName = Prospect
// Change the view associated with the report.
// This view is based on the Prospect data file.
RPT_CustomerReport..ViewName = MyCustomerView84
// Change the data source of "RPT_CustomerTableReport"
// (Report based on table)
RPT_CustomerTableReport..SourceName= "WIN_MyWindow.TABLE_ProspectTable"
// Change the data source of "RPT_CustomerReport"
RPT_CustomerReport..SourceName = QRY_CustomersInParisQuery
Syntax

Finding out the name of the data source for a report Hide the details

<Result> = <Report name>..SourceName
<Result>: Character string
Name of the data source for the specified report:
  • Name of the data file associated with the report. If the report is associated with a HFSQL view or with a memory zone, name of the base file for the view or memory zone.
  • Name of a query.
  • Name of the text file (for the reports based on a text file with automatic reading of records).
  • Name of the Table control used as report source (in the following format: WindowName.TableName).
<Report name>: Character string (with or without quotes)
Name of report to use.

Changing the data source of a report Hide the details

<Report name>..SourceName = <New data source>
<Report name>: Character string (with or without quotes)
Name of report to use.
<New data source>: Character string (with quotes)
New data source for the specified report:
  • Name of the data file associated with the report. If the report is associated with a HFSQL view or with a memory zone, name of the base file for the view or memory zone.
  • Name of a query.
  • Name of the text file (for the reports based on a text file with automatic reading of records).
  • Name of the Table control used as report source (in the following format: WindowName.TableName).
Remarks

HFSQL view associated with a report

When the report is based on a HFSQL view, only the name of the data file corresponding to the view is specified during the report description. The name of the view is specified when printing the report.
  • ..SourceName is used to find out the name of the data file associated with the report.
  • ..ViewName is used to find out the name of the HFSQL view associated with the report.
See Report on HFSQL view for more details.

Memory zone associated with a report

When the report is based on a memory zone, during the report description, only the name of the data file corresponding to the memory zone is specified. The name of the memory zone is specified when printing the report.
  • ..SourceName is used to find out the name of the data file associated with the report.
  • ..MemZoneName is used to find out the name of the memory zone associated with the report.
See Report on memory zone for more details.

Embedded query/Independent query

When creating a report, two types of queries can be used:
  • an embedded query directly created in the report editor. This internal query is not visible in the project. The name of this query has the following format: "<Report name>$Query". For example: "CustomerReport$Query".
  • an independent query already created in the project, in the query editor.

Limits

  • You cannot:
    • change the type of the data source. For example, if the data source is a query, the new data source cannot be a view.
    • change the data source of a report based on a file.
  • The modification of the data source can only be performed in the report "Opening" event.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment