Component Solution Services REC02F Bedienungsanleitung PDF herunterladen (Seite 17)

Tips Recipes Brio 2002

Section Type: Query section

Tip Name: Date-Stamping a Query

Purpose / Use: To provide information in reports that allow users to know when the

data was fetched from the database, rather than when the report is

viewed or printed.

Sample File: Date stamping.bqy

Steps to Produce: Add a server-based Computed Item to the query that adds the system

date and time to the columns added to the Results set.

1) Build a data model and query as you normally would.

2) Right-click on the Request Line of the query, and select “Add Computed Item” from the

speed menu.

3) Name the Computed Item “As Of” in the Name field in the dialog box that appears.

4) Click on the Functions… button in the dialog box. Select “Date Functions” from the

Function Categories column, and then select the appropriate date/time function for your

database connection.

5) To use the “As Of” field, simply drag it into the desired Chart, Pivot or Report area.

1 2 ... 12 13 14 15 16 17 18 19 20 21 22 ... 77 78

Keine Kommentare

Component Solution Services REC02F Bedienungsanleitung Seite 17