Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: adding column to stored procedure Post Reply Post New Topic
Author Message
steve richter
Newbie
Newbie
Avatar

Joined: 31 Jul 2007
Location: United States
Online Status: Offline
Posts: 5
Quote steve richter Replybullet Topic: adding column to stored procedure
    Posted: 31 Jul 2007 at 1:40pm
when I add a new column to a stored procedure that is already used as the input to a crystal reports report, the new column does not show up in the field explorer panel.
 
to see the new column of the stored procedure I am removing the stored procedure from the report and then adding it back. Problem is, when I remove the stored procedure, all the usage of the columns of the stored procedure are also removed from the report.
 
How can I refresh the report definition to include the new columns of the stored procedure?
 
thanks,
 
-Steve
 
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 31 Jul 2007 at 2:05pm
Have you tried "Verify Database" on the Database menu?
 
-Dell


Edited by hilfy - 31 Jul 2007 at 2:07pm
IP IP Logged
steve richter
Newbie
Newbie
Avatar

Joined: 31 Jul 2007
Location: United States
Online Status: Offline
Posts: 5
Quote steve richter Replybullet Posted: 31 Jul 2007 at 2:15pm
that did it! 
 
thanks,
 
 
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.016 seconds.