HERS-ST Example - Ad-hoc Tables and Reports
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
|
|
Word files can be viewed with the Word Viewer
Updated: 02/14/2013