Solved

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

Posted on 2009-04-14
6
645 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

 

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Formatting number to Text Format DDDDDDDDCC 1 56
Crystal Reports total formula with groups? 4 71
Legend Colours Not Matching Riser Colours 9 31
Crystal Report - Charts 4 50
Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

737 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