[General]
Title=Calibration results without comments
Hdr1=|Calibration results|@d
Hdr2=|@c|
Type=Layout

'This is a special type of report that is never 'seen' by GAGEpack
'because it does not have the .JAR extension.  However, it is a
'standard report called from code with the prompts already filled

[Prompts]
1=EventID|MATCH
2=GageNumber|MATCH

[Layout]
1=Gap
2=Table1
3=Gap
4=Comments
5=Gap
6=Table2
SQL1=SELECT EventID, GageNumber FROM Events, Gages WHERE EventID=%1 AND GageNumber='%2'

[Group]
1=GageNumber|No number

[Table1]
Cols=<15|<35|<15|<35
Hdrs=
PerPage=
Row1=Entered by:|%1|Date:|%2			
Row2=Done by:|%3|Status:|%4
Row3=Location:|%5|Cost:|%6
Row4=Time (hours):|%7|Temperature:|%8
Row5=Humidity:|%9|Condition:|%10
Row6=Passed:|%11|Adjustment made:|%12
SQL1=SELECT DoneBy, EventDate, CalibDoneBy, Events.Status, 
SQL2=Events.Location, Cost, TimeSpent, Temperature,
SQL3=Humidity, GageCondition, CalibPassFail,
SQL4=Format(CalibAction, "\N\o;\Y\e\s"), GageNumber
SQL5=FROM Events, EventCalib, Gages
SQL6=WHERE (Events.EventId=%1) AND (EventCalib.EventID=%1)
SQL7=AND (Gages.GageID=Events.GageID)

[Comments]
Text=Comments: %1
SQL1=SELECT Comment FROM Events WHERE EventID=%1

[Table2]
Col1=Step name|20
Col2=Target|20
Col3=As found|20
Col4=After adj.|20
Col5=Deviation|20|#####.#####
SQL1=SELECT ResultFieldName,
SQL2=IIF(IsAtrStep, AtrResultTarget, Format(ResultTarget, FMT)),
SQL3=IIF(IsAtrStep, AtrResultBeforeAdj, Format(ResultBeforeAdj, FMT)),
SQL4=IIF(IsAtrStep, AtrResultAfterAdj, Format(ResultAfterAdj, FMT)),
SQL5=IIF(IsAtrStep, " ", Format(ResultAfterAdj- ResultTarget, FMT)),
SQL6=OrderNumber, GageNumber, Display AS FMT
SQL7=FROM EventCalibResults, Events, Gages
SQL8=WHERE (Events.EventId=%1)
SQL9=AND (EventCalibResults.EventId=%1)
SQL10=AND (Gages.GageID=Events.GageID)
SQL11=ORDER BY OrderNumber