I'm modifying a Crystal Report by adding ONE field. I updated the SPROC to return this new field i.e. added 'Select oldfield1, oldfield2,...,oldFieldN, NEWFIELD from MYTABLE'. Now I need to add the new field to the report. In the ReportViewer, I'm then creating an instance of a crystal report document 'Private report As New CrystalDecisions.CrystalReports.Engine.ReportDocument'. I also build a dataset ds, get some data from the SPROC that I've added the new field to and then set the dataset ds as the datasource of the report with 'report.SetDataSource(ds)'.
1) Shouldn't CrystalReports XI Release 2 automatically show the new field after I use: DataBase/Verify Database menu items? Then when I refresh, I should see new field so that I can Drag and Drop it to the report?
2) Or Do I have to unlink the dataset somehow and then relink it to the report?
3) Basically, how do i get CR XI R2 to show the new field so I can drag and drop it on report?