?
Solved

Crystal Reports not updating when .NET Datasets changed

Posted on 2009-07-16
13
Medium Priority
?
897 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
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

IP addresses can be stored in a database in any of several ways.  These ways may vary based on the volume of the data.  I was dealing with quite a large amount of data for user authentication purpose, and needed a way to minimize the storage.   …
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
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 …
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

650 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