How do I add a field in to a report (Crystal Reports in Visual Studio)

BIBD picture BIBD · Sep 9, 2009 · Viewed 49.1k times · Source

I have an existing report (Crystal Report) in my Visual Studio project that is based off of an SQL Server View. using an OLE DB (ADO) connection.

I've updated the View since the report was created. I've changed some field names and added a field.

How can I update the fields on the report to point at the new field names in the view?

OR

How can I add a new field to the report that points at the new field in the view?

(I know, that's two questions. But the answer is probably going to be very similar for both)

Answer

BIBD picture BIBD · Sep 9, 2009

I finally figured it out. For the sake of the next guy...

  1. shahkalpesh and serge_ bg are right about the "Verify Data"
    If you right click on a blank spot on your report, you will get a popup menu. Select Database -> Verify__Database. Crystal Reports should update the fields that have changed.

  2. You can drag-n-drop the new field onto your report.
    There should be a "Field Explorer" tree view (probably on the left). Select Database Fields -> View/Table Name -> Field Name and drag that onto your report.

A worst case scenario of Crystal Reports updating report field to match up with the wrong field on the view, can be resolved by deleting the old field and re-adding the field using the drag and drop method.