Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Report is not updating Post Reply Post New Topic
Author Message
avgoustinosc
Newbie
Newbie
Avatar

Joined: 17 Oct 2007
Location: Cyprus
Online Status: Offline
Posts: 3
Quote avgoustinosc Replybullet 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?
Avgoustinos
IP IP Logged
jkwrpc
Senior Member
Senior Member


Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Quote jkwrpc Replybullet 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.
 
Regards,
 
John W.
IP IP Logged
avgoustinosc
Newbie
Newbie
Avatar

Joined: 17 Oct 2007
Location: Cyprus
Online Status: Offline
Posts: 3
Quote avgoustinosc Replybullet Posted: 17 Oct 2007 at 10:56pm
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?
Avgoustinos
IP IP Logged
jkwrpc
Senior Member
Senior Member


Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Quote jkwrpc Replybullet 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.
 
Regards,
John W.
IP IP Logged
avgoustinosc
Newbie
Newbie
Avatar

Joined: 17 Oct 2007
Location: Cyprus
Online Status: Offline
Posts: 3
Quote avgoustinosc Replybullet Posted: 18 Oct 2007 at 10:37pm
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....!!!!
 
Please help.
Avgoustinos
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet 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>
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		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



This page was generated in 0.016 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.