Hello, It was brought to my attention today when someone adds a new field to a report uses the Expression Builder to select two fields separated by a + symbol click OK and OK the ReportBuilder throws an error
This is from the VFP 9 SP 1 ReportBuilder.app --------------------------- Report Builder Error --------------------------- Alias is not found. Line 0 in saveexprwidth(): DO (_REPORTBUILDER) WITH __ReportReturn, 2, __ReportCCObject, 1 fieldexprhandler.Error() Do you want to suspend execution? --------------------------- Yes No Cancel --------------------------- I attempted to see if it was on http://vfpx.codeplex.com and the server is not responding. So I found the xSource for VFP 9 SP 2 on the Microsoft site. Tracked the saveexprwidth method in the class panelfieldexpr, in the class library frxpanels. Adding the following to the end of line 71 corrects the problem: and used( m.cAlias ) Say the expression is "alias.firstfield + alias.secondfield" m.cField contains "secondfield" m.cAlias contains "alias.firstfield + alias" HTH, Tracy _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/000401d0a9f3$5b3966e0$11ac34a0$@powerchurch.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.