• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 673
  • Last Modified:

Crystal Reports does not display new field in Field Explorer After I add field to stored procedure.

I created a new report and hooked that report to a stored procedure, I added the fields to the report and all fo the fields were displayed correctly.  Then I added another field to the stored procedure and tested the stored proc in query analyzer and the new field displayed ok.
Now when I Set Location and Verify database the new field does not display in the Field Explorer.  
Any Ideas why this happens and how is this fixed.
Thanks in advance.
0
donnie91910
Asked:
donnie91910
  • 3
  • 2
2 Solutions
 
SpykairCommented:
Have you tried to "verify the database" ?

Spykair
0
 
donnie91910Author Commented:
Yes, I tried Verify the database several times as well as Set Location.
Any help is greatly appreciated.
0
 
mlmccCommented:
The VERIFY DATABASE should provide the new fields as that is the reason it is available.  You shouldn't have to set the location since the report already points to the stored procedure.

mlmcc
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
donnie91910Author Commented:
So if the VERIFY DATABASE did not display the new field is there another solution just short of recreating the report?
0
 
mlmccCommented:
Are you sure you are pointing at the correct stored procedure?

mlmcc
0
 
donnie91910Author Commented:
Aparaently in order for the fields to appear you need to have a valid result set, which i thought I had.  Anyway I altered the stored proc and added a field then I generated the result set, then I ran verify database and got the message that the report is being fixed, which I wasn't getting before, and the field magically appeared.  really weird.
Anyway it works now.  
Thanks for the help and suggestions.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now