|
I think I created it as CREATE VIEW
(max(column)) AS ColumnName, (min(column)) AS OtherColumnName, etc. Hmmm, maybe
I should have done it the other way.
----- Original Message -----
Sent: Monday, June 24, 2002 5:58 PM
Subject: RE: Report View Question
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/
|
