Yes! I'm not crazy...
Well, at least several brain cells are still firing.
I've sent the bug report on to Microsoft. Guess I'll take a look at the reportbuilder and make a few mods come Monday.
Thanks for the quick check Sergey.
Steve
>Now I got the error. Looks like a bug to me. Here're exact steps:
>OPEN DATABASE (HOME(2) + "\Northwind\northwind.dbc")
>USE northwind!Customers
>* Make sure that it's brand new report
>ERASE test.fr?
>Modify Report test
>Drop field control in the detail band of the report and past expression
IIF(Customers.customerid="ABC","A","B") into it.
>Press OK and get the error.
>
>>Do it with a real table open. Add a field and you get the new multi tabbed 'Field Properties' screen. On the General tab press the expression builder button to and enter the expression with an alias for that table. I do the following for the CUSTOMERS table in the NorthWind sample folder:
>>
>>IIF(Customers.customerid="ABC","A","B")
>>
>>The verify button confirms it is a good expression and I press OK which returns me to the Field Properties screen. When I press OK here I get an error window:
>>
>>*****************************
>>Report Builder Error
>>
>>Alias is not found
>>Line 0 in saveexprwidth():
>>...
>>fieldexprthandler.Error()
>> OK
>>*****************************
>>
>>It does not occur if the table is not open in the first place. And it occurs without going to the expression builder but if you just enter the expression in the expression box on the Field Properties screen.
>>
>>It doesn't make sense that the verification works fine but the OK on the Field Properties screen trying to set the width doesn't.