HIDP_PROP_ID

Data Source

This property enables you to specify the following:

$image\bullet.gif$ the field data source to be used to feed the current data field in the report.

$image\bullet.gif$ the main query source to be used to feed the current Report.

$image\bullet.gif$ the query source to be used to feed a Graph control in a report (if that graph is not fed directly by the report data) or to feed a Text/Query control in a report or a Cross-table in a report.

$image\bullet.gif$ the <Report Data> label if the graph is fed by data from the current report (this is a new features which is available from version 4.10 onwards). Warning: In an existing graph is already fed by a query, you must remove the query name and press Enter> to get the <Report Data > label.

$image\bullet.gif$ the cube source to be used to feed a cube object in a report (new since version 4.20).

$image\bullet.gif$ the <Report Data> label if the cube object is fed by data from the current report. Warning: In an existing cube object is already fed by a cube, you must remove the cube name and press Enter> to get the <Report Data > label.

(See Graph example)

$image\bullet.gif$ the report source to be used to feed the sub-report control in the report.

$image\bullet.gif$ the cross table source to be used to feed a cross table control in the report or a graph in the report.

Note: the Data Source box can also be used to enter a formula such as:

$image\bullet.gif$ the one used for the page number: =FormatPage('0')+'/'+FormatPages('0'),

$image\bullet.gif$ the one used for the date time information: =FormatDateTime('mmmm, dddd d, yyyy'),

$image\bullet.gif$ a text mixed with a data field content such as: ='Result for Customer ' + CUSTNAME

$image\arrowbas.gif$ This button displays the available field name used in the Query which the Report is based on, or the available query names to feed a graph or the available report names to feed a sub-report or the current report fields to feed a graph without running an extra query

$image\bouton3.gif$ Use that button to display the Formula Edit dialog box.