At 10:40 AM 10/28/2002 -0500, Bernie Lis wrote:
... If it shows up in select from the view, shouldn't it show up when you base your report on the view. Is it because it is not an actual column in any of the tables in the view?
Bernie,
If the View is defined properly, it should be treated as table when designing a Report/Label in R:BASE 2000 (ver 6.5++). It is very difficult to understand your situation without knowing/seeing the actual definition of view. Make sure that IDQUOTES setting for your database is SET to `. i.e., single reversed quote underneath the tilde ~ key. To understand the concept of creating reports based on a View, take a look at the report named "Invoice" in Concomp sample database shipped with R:BASE 2000 (ver 6.5++). The report "Invoice" is based on a view "ProdAlias". The View "ProdAlias" is the result of five (5) tables, namely: . TransMaster . TransDetail . Customer . Employee . Product Good luck and make sure to have fun! Very Best Regards, Razzak. ================================================ 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/
