Active TopicsMemberlistSearchHelpRegisterLogin

Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Report Will Not Refresh Post Reply Post New Topic
Author Message
rowcpa
Newbie
Newbie


Joined: 19 Jun 2007
Online Status: Offline
Posts: 10
Quote rowcpa Replybullet Topic: Report Will Not Refresh
    Posted: 31 Jul 2007 at 10:14am

I have a report built on an Access query.  I can not get the report to refresh.  I think the problem might have started when a coworker and I were both varyfing the data in the report and simultaniously changing tables that the query and report are built on.

Is it possible to "break" a report in this way and if so how to fix?
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 31 Jul 2007 at 10:16am
Have you checked that you don't have Save Data With Report turned on? This is found under File > Report Options.
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
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 31 Jul 2007 at 10:17am
Oh yeah - also try doing a Verify Database to make sure that CR is synched with the new table structures.
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
rowcpa
Newbie
Newbie


Joined: 19 Jun 2007
Online Status: Offline
Posts: 10
Quote rowcpa Replybullet Posted: 01 Aug 2007 at 8:14am

Save data with report was on.
IP IP Logged
xCapx
Newbie
Newbie
Avatar

Joined: 04 Sep 2007
Location: Switzerland
Online Status: Offline
Posts: 1
Quote xCapx Replybullet Posted: 04 Sep 2007 at 12:25am
Hi, i am having the same  kind of  trouble here.
But instead of Acces i am using XML sheets.
The save data with report is unchecked.
As i refresh the report after i've made change on the xml sheet it wont take the new data and keeps the one used as i made the report.
Is there a way to refresh the data used in a report made from xml ?
any help would be appreciated.
Be realistic, demand the impossible.
IP IP Logged
Anandh
Newbie
Newbie
Avatar

Joined: 03 Dec 2007
Location: India
Online Status: Offline
Posts: 4
Quote Anandh Replybullet Posted: 03 Dec 2007 at 11:08pm
Hi All,
 
I had the same problem when i generted reports using XML.
I passed selection formula at run time 
I got the reports refreshed
Try this it wuld work for u..Smile
Anandh
IP IP Logged
Lugh
Senior Member
Senior Member
Avatar

Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Quote Lugh Replybullet Posted: 04 Dec 2007 at 10:05am
You will almost definitely need to use the Verify Database option after changing the data source structure.  You may also need to use the Set Data Location option to refresh the actual source.
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.047 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.