Solved

Crystal Reports not updating when .NET Datasets changed

Posted on 2009-07-16
13
798 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
  • 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 100

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
 
LVL 100

Accepted Solution

by:
mlmcc earned 250 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
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 
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 250 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

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

It seems a simple enough task, yet I see repeated questions asking how to do it: how to pass data between two forms. In this article, I will show you the different mechanisms available for you to do just that. This article is directed towards the .N…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

919 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

18 Experts available now in Live!

Get 1:1 Help Now