Topic: Report is not updating Posted: 17 Oct 2007 at 1:17am
Dear All,
This is my first time writting in this forum and also i am new with Crystal Reports 10. I have the following problem: I created a report that connects with an SQL 2000 and displays some data. The problem is that when new data is added in the database the report does not display it. Any idea how i can "say" to the report to update the data every time that is running?
Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Posted: 17 Oct 2007 at 9:27am
I dont know if this the problem, but have you made sure that the 'Save Data With Report" is not checked. It is under the file menu. If it is checked the report will not automatically update/refresh the data.
I did that but when is not checked the users cannot access the report because in order to run the report you have to enter username and password of sa in Crystal reports and from another application im getting an error. Is there a way to have permanently the username and password of sa in the report?
Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Posted: 18 Oct 2007 at 7:17am
Your problem seems to be one of database permissions. You should be able to set up your connection for a user other than sa. Each database is different so it is hard to give you direction.
How can i find the problem? I created the report from scratch 10 times and still i have this problem. Why it does not refresh it self? And when i disable the "Save data with Report" it does not open....!!!!
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 18 Oct 2007 at 11:57pm
Unfortunately, there is no way to save database permissions within the report. This creates a big security risk, and they do not have that functionality built into CR. You will have to create a User Id and Password that only has read access to the tables you want to report on. Then you can give that Id/Pw out to your users for them to open reports. Another option is to use Integrated Security so that their Windows Login Id has permission to read from the database without having to login.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
