Solved

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

Posted on 2009-04-14
6
642 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
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to Bold a formula within another formula 4 36
display n/a in column 2 31
Crystal Reports get subgroup count 1 57
Crystal reports vb.net 2 54
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…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

837 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