• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 500
  • Last Modified:

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).
0
dandoohan
Asked:
dandoohan
  • 4
  • 3
  • 2
1 Solution
 
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
Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

 
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
 
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now