Lin, Save yourself the grief. Base your report on a view and within the view create the two expressions you need. Be sure to use the syntax "CREATE VIEW viewname (colnames) AS SELECT ..
An additional advantage is the report will process faster. Jim Bentley --- Lin MacDonald <[EMAIL PROTECTED]> wrote: > This time, closing down and restarting doesn't help. It > won't > let me change or define new expressions in my report! This is > frustrating! > On Sun, 17 Feb 2008 20:00:01 -0500, "Walker, Buddy" > <[EMAIL PROTECTED] > .edu> said: > > Lin > > Set the variables > > > vFullName = (FirstNameColumn & LastNameColumn) > > vCityProv = (City + , & Province) > > > Make sure to put the parens around them. > > > Buddy > > _________________________________________________________________ > > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of > Lin MacDonald > Sent: Sunday, February 17, 2008 7:49 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: odd behavior in Reports?? or not > > > Ok, closed down and restarted and all worked correctly again. > Hmmm... > > > How do I do this? > > I'm trying to concatenate 2 text fields into one (FirstName & > LastName) and also to add a comma between another (City, > Province) > > Thanks, > Lin > On Sun, 17 Feb 2008 16:38:49 -0800, "Lin MacDonald" > <[EMAIL PROTECTED]> s > aid: > > > I am having what I think is odd behavior in the Report > Builder > but maybe, I am just not going about it right: > Add/Edit Variables brings up the Expression Builder screen. > I > can delete Variables but I can't change them or add new > ones. > When I hit Change or Add, nothing happens. If I try to add a > Variable to my Report, the Variable I just tried to create > shows up in that list, but still not in the Add/Edit list, > so > I can't change it when it doesn't work. > I'm trying to concatenate 2 text fields into one (FirstName > & > LastName) and also to add a comma between another (City, > Province) > So, is this odd behavior or should I be doing something > else? > Lin > Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 ____________________________________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping
