actually, it is verify database, but that did the trick
Hi Selim,
>
>I am not exactly sure how this would work, as I have not used Crystal for awhile and no longer have a copy of it, but, I believe if you go to the Database menu item and choose "Update Data Source" (or something like this where Crystal will connect to the database for updates), it will refresh your result set accordingly so that the new fields will be available.
>
>HTH
>
>
>>Hello:
>>
>>I have a stored procedure for generating our PO in Crystal
>>Reports. I have added a new field to the SP, but when I try to add the
>>field to my Crystal Report PO, the field isn't available in the
>>list.
>>The obvious answer would be to simply drop the sp from my existing
>>report and then re-add it. However, if you do this, all your fields on
>>the report are dropped.
>>
>>any help will be gladly appreciated
.......
DO WHILE .T.
ME.Work()
ENDDO