adding new field to stored procedure
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=2706
Printed Date: 16 May 2024 at 3:38pm
Topic: adding new field to stored procedure
Posted By: mejiaks
Subject: adding new field to stored procedure
Date Posted: 25 Mar 2008 at 3:17pm
|
Hello: I have a stored procedure for generating our PO in Crystal Reports. I have added a new field to the SP, but when I try to add the field to my Crystal Report PO, the field isn't available in the list. The obvious answer would be to simply drop the sp from my existing report and then re-add it. However, if you do this, all your fields on the report are dropped. any help will be gladly appreciated ps. i am using mssql 2000 and crystal 8, and visual foxpro 6 |
Replies:
Posted By: BrianBischof
Date Posted: 25 Mar 2008 at 9:12pm
|
Have you tried doing the menu options Database | Verify Database? This synchs your report with the SP and you don't have to rebuild the report. I cover working with databases and how to optimize performance in Chapters 10 and 11 of my Encyclopedia book. You can find out more about my books at http://www.amazon.com/exec/obidos/ASIN/0974953601/bischofsystem-20 - Amazon.com or reading the http://members.crystalreportsbook.com - Crystal Reports eBooks online. ------------- 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> |
Posted By: mejiaks
Date Posted: 26 Mar 2008 at 7:46am
thks, that did the trick! 
|