Crystal Reports Report Will Not Refresh

Data Connectivity

Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity

Topic: Report Will Not Refresh

Post Reply

Post New Topic

Author	Message
rowcpa Newbie Joined: 19 Jun 2007 Online Status: Offline Posts: 10	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 Logged


BrianBischof Admin Group Joined: 09 Nov 2006 Online Status: Offline Posts: 2458	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 Logged

BrianBischof Admin Group Joined: 09 Nov 2006 Online Status: Offline Posts: 2458	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 Logged

rowcpa Newbie Joined: 19 Jun 2007 Online Status: Offline Posts: 10	Posted: 01 Aug 2007 at 8:14am
	Save data with report was on.
	IP Logged

xCapx Newbie Joined: 04 Sep 2007 Location: Switzerland Online Status: Offline Posts: 1	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 Logged

Anandh Newbie Joined: 03 Dec 2007 Location: India Online Status: Offline Posts: 4	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..
	Anandh
	IP Logged

Lugh Senior Member Joined: 14 Nov 2007 Online Status: Offline Posts: 377	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 Logged

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