crystal reports 10 drops all database fields when verifying database
Posted on 2016-08-18
i made a change in a stored procedure that added a field.
the field does not show up in the database fields list of the report.
i do a verify database.
enter the parameters
message comes up.. table RPT_MyReportSP;1 does not exist. Remove this table from report?
if i say yes... all the database fields are removed from the report... as you might expect.
after i redo the Set DataSource Location and point at --THE SAME-- stored procedure i was trying before... it connects and pulls in the new field.
if i say no... i keep the database fields in my report, but the new field from the stored procedure is not in the list.
how do i refresh the database field names and not lose all the already placed database field names in my report.