We help IT Professionals succeed at work.
Get Started

VB.NET 2008 and Crystal Reports

1,937 Views
Last Modified: 2012-05-07
I'm writing a small app in vb.net 2008 Pro that executes a crystal report that was created in Crystal XI. This report has several subreports all of which use the same stored procedure that is used in the main report. I can run this report without issue through crystal but when trying to execute it through vb.net code, I receive the following error:

This field name is not known.
Error in File C:\..........
Error in formula <Record Selection>.
'({group_plan_renewals;1.PROD_CD} like '*' & 'Dental' & '*' or
'
This field name is not known


I can tell which subreport this is referring to, so I tried removing that subreport to see if it would then run, but it just goes on to the next report and lists the same error for the first line in the record selection formula. I'm stumped. Any insight is greatly appreciated.

I do not have any code to post because this error isn't triggered until after the the function to load the report is done... if there is code that you need to see that would help, please let me know. This really seems more like an issue with the report/subreport though.
Comment
Watch Question
Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
This problem has been solved!
Unlock 1 Answer and 17 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE