HERS-ST Example - Ad-hoc Tables and Reports
Word Version (650 kb)
Objective: Become familiar with the ad-hoc table and report features in HERS-ST.
Tasks:
- creating a new table;
- modify existing table;
- bring additional data items into table;
- create report using table query;
- modify existing report;
- using BASIC script to modify reports; and
- saving reports.
Task 1: Creating a new table
Task 2: Modify Existing Table
| SQL Query |
| SELECT |
| |
tdSysCondDets.fsFundingPeriod,
tdSysCondDets.Total |
| FROM |
| |
(((tdIterationItems
INNER JOIN tdSysCondDets ON tdSysCondDets.fwSysCondID = tdIterationItems.fwRefID)
INNER JOIN tdIterations ON tdIterations.fnIterationID = tdIterationItems.fwIterationID)
INNER JOIN tdConfigurations ON tdConfigurations.fnConfigID = tdIterations.fwConfigID)
INNER JOIN tdProjects ON tdProjects.fnProjectID = tdConfigurations.fwProjectID |
| WHERE |
| |
((tdIterations.fwConfigID = 41) AND (tdIterations.fnIterationID = 52) AND
(tdIterationItems.fsRefClass = 'bcoss1') AND (tdProjects.fnProjectID = 13) AND
(tdSysCondDets.fsLabel = 'apsr')) |
| ORDER BY |
| |
tdSysCondDets.fsFundingPeriod |
Task 3: Bring Additional Data Items into Table
Task 4: Create Report Using Table Query
Task 5: Modify Existing Report
Task 6: Using BASIC Script to Modify Reports
Task 7: Saving Reports
|
