?
Solved

Crystal Reports not updating when .NET Datasets changed

Posted on 2009-07-16
13
Medium Priority
?
869 Views
Last Modified: 2013-11-07
I have some crystal reports that uses a viewer and Report.xsd as a schema for the data/field names that will be returned by my Stored procedures.

I have updated the SPROCs to add 3 new fields.  Next I updated the .xsd with the name and type of new fields so that they are in sync.  No errors when I compile.

Next I check out my CR Report, and when I try Verify Database, it says its already up to date and doesn't add new fields.  

So since i know this is not true, under Field Explorer, I right click and choose Set DataSource Location.  Choose Properties from under Report/report name, go under filepath, erase it, then am given a prompt for a dataset and select the same dataset.  Now the fields are updated, but no data will show.

I know there is data because I test the SPROC in Mssql Manager and it returns a row with data in these fields...Is this a glitch or am I doing wrong?   anything anyone suspects which can be causing this behavior?   Basically, though, I just want a solution so I can done with these reports...

Thanks in advance.
0
Comment
Question by:silemone
[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
  • 6
  • 5
  • 2
13 Comments
 
LVL 96

Expert Comment

by:Bob Learned
ID: 24878111
I work with 2005 Team Suite edition, and I have had that same problem.  I have noticed that the order of things is important to be able to change the schema file, and then verify the database.  I used to close the IDE, and restart, but I believe that I have found a way to do that without exiting, but the steps are not perfectly clear to me right now.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 24879125
Crystal sometimes if you don't logoff the datasource will not find the updated file but rather use the one it has loaded into cache.

mlmcc
0
 
LVL 96

Expert Comment

by:Bob Learned
ID: 24879845
@mlmcc
Since this is an .xsd schema file, and not a pull data source, there isn't any "logoff" to be done that I know of.
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
LVL 101

Accepted Solution

by:
mlmcc earned 1000 total points
ID: 24891923
I haven't used xsd files but have used xml which have the definitionn and the data so they do require a logoff.

mlmcc
0
 
LVL 96

Expert Comment

by:Bob Learned
ID: 24894825
Mike,

With the VS.NET 2005 IDE, logging off the server disconnects the .xsd file from the report, so you would need to reconnect again.  That is not a necessary, or desireable step, since it is not needed to verify the report.  I believe that this is about a specific sequence of steps to modify the XSD Schema file with the report closed, and then re-open the report and verify the database after the .xsd is changed.

I guess this is just going to be a conversation between the two of us!!

Bob
Crystal---Database---Log-On-Or-O.png
0
 
LVL 21

Author Comment

by:silemone
ID: 24895026
Thanks all...I was out, but will look over your suggestions today and add questions as needed.
0
 
LVL 21

Author Comment

by:silemone
ID: 24895128
TheLearnedOne, could you please provide me the steps?  

Here are my steps.  I am using 3 technologies here....

1) Vs2005
2) SourceSafe
3) CR XI release 2

my Steps:

1)  I updated the stored procedure...
2)  Check out the .xsd file...view code, update fields, save, check back in...
3)  Check out .rpt file...Open (which defaults to open in CR XI release 2 environment)...
4)  Verify Database....if already says 'DB already updated', then I go to Set DataSource Location...
5) Under properties of the report, under Filepath, I erase so I am prompted for a path, and through file dialog, find .xsd file.
6)  When i do this, usually, the Field explore shows new fields...but when I run report, no data shows.
0
 
LVL 21

Author Comment

by:silemone
ID: 24895139
7) check everything back in Sourcesafe
0
 
LVL 96

Expert Comment

by:Bob Learned
ID: 24895146
For 1) and 2) how are you updating the schema file?  Are you dragging/dropping from Server Explorer to the Schema Designer?
0
 
LVL 21

Author Comment

by:silemone
ID: 24895503
1)  SPROC -- I add 3 new fields...I test integrity of data.  Then i refresh db...

2)  Afterwards, i open my .xsd file in 'view code' mode...I type in new fields with the same name as SPROC output and their type.
0
 
LVL 96

Assisted Solution

by:Bob Learned
Bob Learned earned 1000 total points
ID: 24895711
I can modify the stored procedure, drag and drop the SP to the schema designer, save the changes, modify the report, and have the Verify Database option say that the database was updated without all those extra steps.
0
 
LVL 21

Author Comment

by:silemone
ID: 24896049
ok...i will see if that makes a difference...
0
 
LVL 21

Author Closing Comment

by:silemone
ID: 31604378
suggestions helped me discover some other functionality of CR that I needed to also understand.  thanks...
0

Featured Post

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

A basic question.. “What is the Garbage Collector?” The usual answer given back: “Garbage collector is a background thread run by the CLR for freeing up the memory space used by the objects which are no longer used by the program.” I wondered …
Welcome my friends to the second instalment and follow-up to our Minify and Concatenate Your Scripts and Stylesheets (http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/A_4334-Minify-and-Concatenate-Your-Scripts-and-Stylesheets.html)…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

752 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