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: [email protected]
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/[email protected]
** 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.