I have a very weird problem bogging me.
When I use a particular field in a report formula does it crash at runtime, but not during design.
The report shows/uses the field without problem during preview in the designer, but as soon the report is deployed to be used by my organisation will it crash when used.
To fault find the issue have i removed all the code where this ifield is used, and just tried to place the field on the report and put edges on the field, to check if the field is empty, but it completelly dissapears from the report when used outside the designer and I know that it has data in it.
The particular field is a "tic box" , it is a string(1) type.
The problem started since we added a field in our SQL server, this table is already used by the report and I have updated the table in Crystal so the field is visible to crystal.
Is there any way of "rebuild" a report to completelly verify all links and fields are working?
Or any other ideas?
I really don't want to rebuild the whole report as it's a quite complex one.
The report is called from the client side with 3 parameters but none of those is in the updated table.