Updating stored proc result set in Crystal Reports
Posted on 2010-08-27
I added a stored procedure to a crystal report.
After adding to the CR it appeared the same as a view/table with the fields (result set) on the left hand side under Database Fields.
But, unlike a view or table, I don't seem to be able to update changes.
i.e. I have added a number of columns to the result set that is being returned. I then went into Set Datasourse Location, found the SP and clicked update. New table fields were not added to the CR.
I can remove the SP and add it again, but this will not be an option in the future when the report is more developed. I will need to be able to update it on the fly.