But My dear Craig,

Don't you think creating a new file on the disk will be a problem as such always I have to recreate it by zapping and appending the new record and which is not allowed when the exclusive is off, so it is my LAN version, I can't efford to do that as such I tried this method before, Thanks for your suggestion, Is there any other better way to do it.. !!

Also Craig I tried by recreating the views programmatically, but if the view is created programmatically it dosen't works in Crystal reports.. I don't know why..?

Thanks for your reply..

But I would be glad if you can suggest me some better way...