[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 727
  • Last Modified:

VB6 SQL Crystal reports error "This field is not known.

I run a vb6 system that uses SQL and Crystal Reports. The program stops with an error "This field is not known". Could someone tell me how I would find out what field the error is referring to? I have attached a jpg screen shot of the message.
Thanks in advance.
Crystal-Reports-error.JPG
0
tesla764
Asked:
tesla764
  • 2
  • 2
3 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
without seeing the relevant code and the report's underlying query, we can only tell you want the error message is telling you: the code/report tries to access some field name which is not there. it might be a typo or a case sensitivity issue ...
0
 
mlmccCommented:
WHat code is running when you get the message?

What version of Crystal?

Can you open the report in the Crystal designer?
DO you get an error if you preview it?

mlmcc
0
 
tesla764Author Commented:
We are running Crystal Reports 10. That's what I am trying to find, how do I find the field name that is causing the problem. I believe the vb6 code is running. If I can find the report name I will try opening that in crystal reports designer.
0
 
mlmccCommented:
How does the application run reports?
Is it on user selection or does it run a set of reports automatically.

To find the field name you need to know which report it is and the code that is running it.  Generally the issue is the code is changing a formula in the report or the database has changed.

mlmcc
0
 
tesla764Author Commented:
User Selection.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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