Solved

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

Posted on 2009-04-14
6
640 Views
Last Modified: 2012-06-21
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
Comment
Question by:donnie91910
  • 3
  • 2
6 Comments
 
LVL 10

Accepted Solution

by:
Spykair earned 250 total points
ID: 24145241
Have you tried to "verify the database" ?

Spykair
0
 

Author Comment

by:donnie91910
ID: 24148792
Yes, I tried Verify the database several times as well as Set Location.
Any help is greatly appreciated.
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 250 total points
ID: 24149335
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:donnie91910
ID: 24149869
So if the VERIFY DATABASE did not display the new field is there another solution just short of recreating the report?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 24151658
Are you sure you are pointing at the correct stored procedure?

mlmcc
0
 

Author Comment

by:donnie91910
ID: 24153655
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now