Hello,
I’ve got a Business Element that I created a long time ago that is behaving strangely in regards to field length. My issue is that when I look at the underlying SQL table (SQL Server 2008 R2) the length of the column in question is varchar(8). When I look in the business element detail section the length is listed as String 18. When I Browse the field in the detail section of the business element I see String 8, which matches the database. Finally if I create a report off of the business element Crystal sees the length as varchar(7). I believe the varchar(7) is because when the business element was originally built, the column was only a varchar(7), but it has since been expanded.
Can anyone point me in the right direction for figuring out how to refresh the Business Element’s length, without recreating everything? The business element feeds a prompt that is used in multiple Crystal Reports and I don’t want to have to manually update those reports if I can avoid it.
I’ve tried Setting the Table Location at the data foundation level, but that only makes it so when I browse the field I see the correct length. Any time I deal directly with the business element I still see an incorrect value. Thanks so much.
-NifflerX
NifflerX (BOB member since 2009-08-09)