Try creating your view like this: create vie myview (FirstDate, LastDAte, TotalOrders, TotalRevinue, clientnum) as + select (min(orddate)) ,(max(OrdDate)),(count(OrdDate)),(sum(Total)),clientnum + from orders group by + clientnum where cancelled <> 1
Troy ===== Original Message from [EMAIL PROTECTED] at 6/24/02 4:34 pm >Hi all. I have the following view: > >select (min(orddate)) as FirstDate,(max(OrdDate)) as >LastDate,(count(OrdDate)) >AS TotalOrders,(sum(Total)) as TotalRevenue,clientnum from orders group by >clientnum where cancelled <> 1 > >on which I'm trying to design a report. However, when I use the report >designer, only the column <clientnum> appears available. What happened to >the other columns? > >Thanks, >Dan > > > > > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
