-
Feb 20th, 2017, 12:53 AM
#1
Thread Starter
Lively Member
-
Feb 20th, 2017, 06:22 AM
#2
Re: The database file <file name> has changed. Proceeding to fix up the report!
I'm not an expert by I see the alter statement in that query. That is probably telling Crystal it was altered and hence the "fix up the report". Try pointing at an actual stored procedure versus, what looks to me, like an internal one.
Please remember next time...elections matter!
-
Feb 20th, 2017, 09:00 PM
#3
Thread Starter
Lively Member
Re: The database file <file name> has changed. Proceeding to fix up the report!
it's alter because I click the modify option to view the codes for stored proc
by the way i tried to recreate the report however the error still there
-
Feb 21st, 2017, 02:23 AM
#4
Thread Starter
Lively Member
Re: The database file <file name> has changed. Proceeding to fix up the report!
if I'm going to recreate my reports same thing happened. the error still occurs.
Last edited by Carmell; Feb 23rd, 2017 at 08:03 PM.
-
Mar 27th, 2018, 01:05 AM
#5
Thread Starter
Lively Member
Re: The database file <file name> has changed. Proceeding to fix up the report!
This is my problem for a year now hehe
-
Mar 27th, 2018, 04:40 AM
#6
Re: The database file <file name> has changed. Proceeding to fix up the report!
-
Mar 27th, 2018, 02:05 PM
#7
Re: The database file <file name> has changed. Proceeding to fix up the report!
Don't use select * ... list out the fields you use in the report. No more, no less. That's part of the problem. CR uses the field listing as part of determining if there is a db change or not. When there's a select *, it doesn't know immediately if there was a change to the underlying tables, so it's going to assume there was a change. But if you list out the fields, it can much more easily see if there was a change and will stop prompting you to fix up the report.
-tg
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|