This field name is not known

I have created a report for a client, the client is running a clustered sql server. We have a report application which runs crystal reports 11. All reports are running fine except for the one I've just created.

I got the clients database backup and put it onto my laptop. I created this report on my laptop and ran a print preview and it shows all the results. I also ran the report through the report application and it ran fine.

I put the report onto any computer in the clients network and run the report and get the error: "This field name is not known".

I checked for field names in the report against the clients database and they're all there (as they should be as it works on my laptop with the same database).
dandoohanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
How are you changing the report to reflect the change in database?

mlmcc
0
James0628Commented:
And did you try "verify database" on the client's computer to see if that tells you anything?

 James
0
dandoohanAuthor Commented:
There's no change in the databases, I was talking to a crystal report guy today and he mentioned that I check out the numerical field differences between the clients sql server and my laptops sql server. I could make a change in the reports properties, field options...
I will let you know the results once I can make this change and check it against the clients live database.
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

dandoohanAuthor Commented:
This has been resolved (sort of), I ended up having to build the report from my clients database directly rather then from a backup of their database on my local server.

I tried changing field option types but it didn't work... This was taking too long for me to look into further so as I have stated I built the report against their database.

Thanks for help
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dandoohanAuthor Commented:
How do I close this call?
0
mlmccCommented:
I suspect that Crystal looks at the 2 databases as different since they probably are not in the same directory on the drive.

mlmcc
0
dandoohanAuthor Commented:
mlmcc, This could well be the case. I wasn't sure if there was a datatype difference in the databases (maybe development didn't push a datatype change out in one of the upgrades) or if Crystal reports looks at differences in the sql server setups... Not sure never had enough time to find out...

Could you close this please...
0
mlmccCommented:
Crystal will note the differences but won't attempt to change/fix it unless you verify the database.

James0628 - Any problem with closing?

mlmcc
0
James0628Commented:
That's fine with me.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.