Thanks Bill I was afraid of that. I was hoping there was some trick to save time.
Thanks Marc ----- Original Message ----- From: "Bill Downall" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Wednesday, November 02, 2005 3:54 PM Subject: [RBG7-L] - Re: Order by > 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. > >
