Re: Report(query)

2005-05-12 Thread Eamon Daly
lt;[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; Sent: Thursday, May 12, 2005 12:54 PM Subject: Re: Report(query) ROLLUP is not working with current version.IS any way i can do? I have 1 column names time with data type datetime.I want to get report like -mm-dd format. Can I get by using

Re: Report(query)

2005-05-12 Thread Seena Blace
ROLLUP is not working with current version.IS any way i can do? I have 1 column names time with data type datetime.I want to get report like -mm-dd format. Can I get by using date_format(nameofcolumn,'%Y-%m-%d')? Harald Fuchs <[EMAIL PROTECTED]> wrote: In article <[EMAIL PROTECTED]>, Seena

Re: Report(query)

2005-05-12 Thread Harald Fuchs
In article <[EMAIL PROTECTED]>, Seena Blace <[EMAIL PROTECTED]> writes: > Hi, > I want report like this > date process pending wip > 5/10/051030 40 > 5/11/05 09 28 60 > ---

Report(query)

2005-05-11 Thread Seena Blace
Hi, I want report like this Table description is like as follows Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | id | int(

Report query problem

2004-07-04 Thread wally . randall
Coming from an Oracle background I am struggling with the following report generation. This is a report which needs to be created using mySQL: Week of mm/dd/yy mm/dd/yy mm/dd/yy mm/dd/yy mm/dd/yy Total All Groups nn nn nn nn