selections using a derived field in Report Smith version3.1 2

Macro derived fields happen after the data has been returned. Youe need to use a SQL derived field to return the month of there birthday. Then in Selections you can use it with the Report Variable to drive the report.

Here is the SQL Derived Field Syntax:

To_Char(birthdate data field,'MM')

'MM' will return Month (01-12; JAN = 01)
OR
'MON' will return Abbreviated name of month
OR
'MONTH' will return Name of month, padded with blanks to length of 9 characters

CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining

If you are using ADP with ReportSmith, one of the included sample reports, i.e. birthday.rpt produces a list of employees by birth month and day. You might want to take alook at that if possible.

David Black, CQA
Teepak, LLC

I don't know if this works in Oracle (I'm SQL) but I set up a monthly date based report with report variable "MONTH," (string type, with "choose from list" entry, and then I entered all months like this in the report variable piclist:

%JAN%
%FEB%
%MAR% etc...)

then do a selection criteria of "data field Birthdate is patterned like report variable MONTH.