Dan
You have got to set the column names for your view. Create your view
as
CREATE VIEW SalaryRetView +
(SSNTEXT,DEPTNo,LastName,FrstName,Middle, +
ActContract,ActIncentive,ActTotComp) +
AS SELECT +
(CTXT(FORMAT(T1.SSN,'000000000'))),T1.DEPTNo,T2.LastName, +
T2.FrstName,T2.Middle,T2.ActContract,T2.ActIncentive,T2.ActTotComp +
FROM FACULTY T1, SalaryReturns T2 WHE T1.SSN = T2.SSN
Buddy
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
On Behalf Of Dan
Sent: Monday, June 24, 2002 6:34 PM
To: [EMAIL PROTECTED]
Subject: Report View Question
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/
