Joined: 31 Jan 2007
Location: United States
Online Status: Offline
Posts: 2
Topic: CR not showing new fields from stored procedure Posted: 31 Jan 2007 at 3:06pm
I have a Crystal Report which loads data from a stored procedure. I added new fields to the procedure, but these are not showing up in Crystal Reports field explorer.
I have tried hitting Refresh repeatedly, disconnecting and reconnecting to the database, and have verified that I updated the right SP, but crystal reports still doesn't list the new fields. I am afraid to remove and re-add the stored procedure because I don't want to have to recreate the report.
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 31 Jan 2007 at 3:35pm
Try closing CR completely and then opening it again.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 31 Jan 2007 at 3:45pm
Hmmm. First off, make a backup copy of the report to protect yourself.
Try doing a Set Datasource Location command and point to the Stored Procedure again. Another idea: make a copy of the SP with a slightly different name and use that instead.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
