Mario - You view definition may need to be changed - if your view is SELECT * FROM tablename or if it includes a GROUP BY with an aggregate function then Crystal Reports would not be able to see the column names.
For example, using the Concomp database, if you UNLOAD STRUCTURE FOR ProdView, this is the result: CREATE VIEW `ProdView` AS + SELECT T1.TransDate,T2.*,T3.*,T4.EmpID,T4.EmpFName,T4.EmpLName,T5.ProdName + FROM TransMaster T1,TransDetail T2,Customer T3,Employee T4,Product T5 + WHERE (((T1.TransID = T2.TransID) AND (T1.CustID = T3.CustID ) + AND (T1.EmpId = T4.EmpID) AND (T2.Model = T5.Model))) and Crystal Reports would not be able to see the name of the columns indicated with the *. To correct this, save the UNLOAD STRUCTURE results to a file then modify the file like this: DROP VIEW ProdView CREATE VIEW `ProdView` + ( TransDate,TransID,DetailNum,Model,Units,Price,ExtPrice,CustID,Company,CustAd dress,+ CustCity,CustState,CustZip,CustPhone,ModLevel,LastUpdateDate,LastUpdateTime, + LastOrderDate,CustURL,CustEMail,CustStatus,EmpID,EmpFName,EmpLName,ProdName) + AS + SELECT T1.TransDate,T2.TransID,T2.DetailNum,T2.Model,T2.Units,T2.Price,T2.ExtPrice T3.CustID,T3.Company,T3.CustAddress,T3.CustCity,T3.CustState,T3.CustZip,T3.C ustPhone,+ T3.ModLevel,T3.LastUpdateDate,T3.LastUpdateTime,T3.LastOrderDate,T3.CustURL, + T3.CustEMail,T3.CustStatus ,T4.EmpID,T4.EmpFName,T4.EmpLName,T5.ProdName + FROM TransMaster T1,TransDetail T2,Customer T3,Employee T4,Product T5 + WHERE (((T1.TransID = T2.TransID) AND (T1.CustID = T3.CustID ) + AND (T1.EmpId = T4.EmpID) AND (T2.Model = T5.Model))) Sami ----------------------------------------------------------------- Sami Aaron Software Management Specialists 19312 W 63rd Terr Shawnee KS 66218 mailto:[EMAIL PROTECTED] 913-915-1971 ----- Original Message ----- From: "Mario B�dard" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, November 27, 2003 9:04 AM Subject: [RBASE-L] - Rbase and crystal report > Good morning all of you. > > This morning I have a question about Crystal Report and the View on Rbase. > > I vould like to create a report from � View that in Rbase. > The View is call Test2. > > When I select the view on Crystal report i have a message it tell me that > there no fields in the file Test2. > > What I must doing for crate a report with this view ???? > > Thanks a lots > > Mario B�dard > Socca organisation > > > >
