Marc,
There is no way to sort a report by something that is not data in your
table/view. You may want to create a "one time" view:
CREATE VIEW MarcsView AS SELECT *, (IDay(b_date)) AS DayOfMonth +
FROM marcstable
PRINT MarcsReport WHERE ... ORDER BY DayOfMonth
Marc wrote:
> a user. The report is based off a table.
>
> I want to be able to send them a small command file
> that will do this
>
> Print Report where..... order by (iday('b_date'))
>
> But this does not work. Is there some other way of
> doing this without having to build a view......
> This is just a one time deal.
