I don't know why I am getting these results. The database is MS SQL and is not case sensitive.
It appears to be sensitive to 'PROSTAR' vs 'PROStar' in one case and not another.

-* Row returned
TABLE FILE DW_TRANSPORTATION/EQUIPMENT/NFI_TRACTOR_SNAPSHOT_DAILY
SUM
NFI_TRACTOR_SNAPSHOT_DAILY.VWFACTTRACTORSNAPSHOTDAILY.TRACTOR_DAILYDISPATCHCOUNT
BY NFI_TRACTOR_SNAPSHOT_DAILY.VWDIMTRACTOR.TRACTOR_MODEL
WHERE NFI_TRACTOR_SNAPSHOT_DAILY.VWDIMTRACTOR.TRACTOR_MODEL EQ 'PROSTAR';
END

-* No Row returned
TABLE FILE DW_TRANSPORTATION/EQUIPMENT/NFI_TRACTOR_SNAPSHOT_DAILY
SUM
NFI_TRACTOR_SNAPSHOT_DAILY.VWFACTTRACTORSNAPSHOTDAILY.TRACTOR_DAILYDISPATCHCOUNT
BY NFI_TRACTOR_SNAPSHOT_DAILY.VWDIMTRACTOR.TRACTOR_MODEL
WHERE NFI_TRACTOR_SNAPSHOT_DAILY.VWDIMTRACTOR.TRACTOR_MODEL EQ 'PROStar';
END

-* Row returned
TABLE FILE NFI_TRACTOR_SNAPSHOT_DAILY
BY NFI_TRACTOR_SNAPSHOT_DAILY.VWDIMTRACTOR.TRACTOR_MODEL
WHERE NFI_TRACTOR_SNAPSHOT_DAILY.VWDIMTRACTOR.TRACTOR_MODEL EQ 'PROStar';
END


Trace...
TABLE FILE DW_TRANSPORTATION/EQUIPMENT/NFI_TRACTOR_SNAPSHOT_DAILY
SUM
NFI_TRACTOR_SNAPSHOT_DAILY.VWFACTTRACTORSNAPSHOTDAILY.TRACTOR_DAILYDISPATCHCOUNT
BY NFI_TRACTOR_SNAPSHOT_DAILY.VWDIMTRACTOR.TRACTOR_MODEL
WHERE NFI_TRACTOR_SNAPSHOT_DAILY.VWDIMTRACTOR.TRACTOR_MODEL EQ 'PROSTAR';
END
TABLE FILE DW_TRANSPORTATION/EQUIPMENT/NFI_TRACTOR_SNAPSHOT_DAILY
SUM
NFI_TRACTOR_SNAPSHOT_DAILY.VWFACTTRACTORSNAPSHOTDAILY.TRACTOR_DAILYDISPATCHCOUNT
BY NFI_TRACTOR_SNAPSHOT_DAILY.VWDIMTRACTOR.TRACTOR_MODEL
WHERE NFI_TRACTOR_SNAPSHOT_DAILY.VWDIMTRACTOR.TRACTOR_MODEL EQ 'PROStar';
END
TABLE FILE NFI_TRACTOR_SNAPSHOT_DAILY
BY NFI_TRACTOR_SNAPSHOT_DAILY.VWDIMTRACTOR.TRACTOR_MODEL
WHERE NFI_TRACTOR_SNAPSHOT_DAILY.VWDIMTRACTOR.TRACTOR_MODEL EQ 'PROStar';
END
11.05.33 BT (FOC2590) AGGREGATION NOT DONE FOR THE FOLLOWING REASON:
11.05.33 BT (FOC2565) THE OBJECT TRACTOR_DAILYDISPATCHCOUNT OF SUM CANNOT BE CONVERTED TO SQL
11.05.33 BT (FOC2605) ACTUAL MUST BE COMPATIBLE WITH USAGE FORMAT FOR P-TYPE FIELDS
11.05.33 AE SELECT
11.05.33 AE T1."Tractor_Key",
11.05.33 AE T1."Tractor_DailyDispatchCount",
11.05.33 AE T4."Tractor_Key",
11.05.33 AE T4."Tractor_Model"
11.05.33 AE FROM
11.05.33 AE dbo.vwFactTractorSnapshotDaily T1,
11.05.33 AE dbo.vwDimTractor T4
11.05.33 AE WHERE
11.05.33 AE (T4."Tractor_Key" = T1."Tractor_Key" ) AND
11.05.33 AE (T4."Tractor_Key" > 0) AND
11.05.33 AE (T4."Tractor_Model" = 'PROSTAR')
11.05.33 AE ORDER BY
11.05.33 AE T4."Tractor_Model";
0 NUMBER OF RECORDS IN TABLE= 32320 LINES= 1
0 HOLDING HTML FILE ON PC DISK ...
11.05.33 BT (FOC2590) AGGREGATION NOT DONE FOR THE FOLLOWING REASON:
11.05.33 BT (FOC2565) THE OBJECT TRACTOR_DAILYDISPATCHCOUNT OF SUM CANNOT BE CONVERTED TO SQL
11.05.33 BT (FOC2605) ACTUAL MUST BE COMPATIBLE WITH USAGE FORMAT FOR P-TYPE FIELDS
11.05.33 AE SELECT
11.05.33 AE T1."Tractor_Key",
11.05.33 AE T1."Tractor_DailyDispatchCount",
11.05.33 AE T4."Tractor_Key",
11.05.33 AE T4."Tractor_Model"
11.05.33 AE FROM
11.05.33 AE dbo.vwFactTractorSnapshotDaily T1,
11.05.33 AE dbo.vwDimTractor T4
11.05.33 AE WHERE
11.05.33 AE (T4."Tractor_Key" = T1."Tractor_Key" ) AND
11.05.33 AE (T4."Tractor_Key" > 0) AND
11.05.33 AE (T4."Tractor_Model" = 'PROStar')
11.05.33 AE ORDER BY
11.05.33 AE T4."Tractor_Model";
0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0
0 HOLDING HTML FILE ON PC DISK ...
AGGREGATION DONE ...
11.05.34 AE SELECT
11.05.34 AE T4."Tractor_Model",
11.05.34 AE MAX(T4."Tractor_Model" )
11.05.34 AE FROM
11.05.34 AE dbo.vwDimTractor T4
11.05.34 AE WHERE
11.05.34 AE (T4."Tractor_Model" = 'PROStar')
11.05.34 AE GROUP BY
11.05.34 AE T4."Tractor_Model"
11.05.34 AE ORDER BY
11.05.34 AE T4."Tractor_Model";
0 NUMBER OF RECORDS IN TABLE= 1 LINES= 1
0 HOLDING HTML FILE ON PC DISK ...

This message has been edited. Last edited by: David M,

I found the answer posted by Frances Mariani back in 2014. I am using the following SET command
SET COLLATION=SRV_CI

He references the document Creating Reports With WebFOCUS Language Release 8.0 Version 08 > Sorting Tabular Reports > Controlling Collation Sequence

Thanks Frances

David, it's francIs

Meanwhile, I'm glad the referenced documentation helped. I would look into why you get this error:


11.05.33 BT (FOC2565) THE OBJECT TRACTOR_DAILYDISPATCHCOUNT OF SUM CANNOT BE CONVERTED TO SQL
11.05.33 BT (FOC2605) ACTUAL MUST BE COMPATIBLE WITH USAGE FORMAT FOR P-TYPE FIELDS

Francis, first sorry for the typo on your name. Secondly thanks for the heads up on the warning message. My synonym shows that column to be a Decimal Packed (actual). To not show the decimals I had changed the usage to Integer. To get rid of the warning I changed the usage back to Decimal with a length of 8 and no decimals. So lesson learned, thanks.

David