Click here to Skip to main content
15,849,615 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
"This field name is not known" error showing in a formula field while viewing the report through the crystal report viewer. It works while running in the crystal designer window. Only difference while running from application it uses a temperory table that links with other tables in the report. The formula causing error is not a field from the temperory table. Anybody has any ideas?.
I use sql server 2008 as the database
Updated 21-Aug-12 4:51am
ShaikhM 21-Aug-12 23:12pm    
There's not sufficient information for us to comment.

1 solution

Without seeing your code, it will be difficulr to help. Did you try google[^] first? It sounds like you've maybe misspelled a field name or are missing something in your code temporary table.
Share this answer
Reji Ab 22-Aug-12 1:59am    
Thanks for your reply. I already googled it but no help.

It happens in the formula code
ToText({rooms.RM_DIRYPOS}) + ToText({rooms.RM_ABBR});
were rm_dirypos and rm_abbr are defined as varchar(10) in sql server.

When I use 2010 it uses crystal report XI to run the reports.
when I open in crystal report designer it uses 8.5 to run it and it runs fine.

This report works well when running it from DELPHI application, it uses crystal report 8.5 to run it. So I am wondering is that an issue with new version of crystal report. Any ideas please help
Kschuler 22-Aug-12 9:04am    
Do you have any other special things about your report. For instance, are you using sub reports or parameters? Are you 100% sure it's that formula that is broken? If you remove that formula and run it again, does the report work? If you are worried about it being an issue with crystal report versions, you could saving it as a crystal XI report using visual studio and running it again to test.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900