Print Page | Close Window

Report Will Not Refresh

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1096
Printed Date: 06 Apr 2025 at 7:20pm


Topic: Report Will Not Refresh
Posted By: rowcpa
Subject: Report Will Not Refresh
Date 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?



Replies:
Posted By: BrianBischof
Date 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>


Posted By: BrianBischof
Date 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>


Posted By: rowcpa
Date Posted: 01 Aug 2007 at 8:14am

Save data with report was on.



Posted By: xCapx
Date 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.


Posted By: Anandh
Date 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


Posted By: Lugh
Date 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.





Print Page | Close Window