Home > Crystal Report > Crystal Report Viewer Error This Field Name Is Not Known

Crystal Report Viewer Error This Field Name Is Not Known

Contents

Permalink Posted 27-Jun-11 5:05am prem shanker verma1.3K Comments Neetin_1809 23-Dec-14 6:25am Hello , I Am Facing the Same issue in the Reports In VS2008. After running for about 3- seconds to a minute, the system responds with error "The field name is not known". My local Crystal reports (ODBC) connection had been changed to the new database (where I had added the new field/attribute), but the connection from the BO report server had not been I'm just wondering if anyone has ever experienced something like this before and can offer a possible general explanation as to where an error like this might come from? navigate here

Application Lifecycle> Running a Business Sales / Marketing Collaboration / Beta Testing Work Issues Design and Architecture ASP.NET JavaScript C / C++ / MFC> ATL / WTL / STL Managed C++/CLI Will putting a clock display on a website boost SEO? We had changed to a new database in our testing environment. Often times this error is not a result of a dataset issue as much as a custom field, or formula withing a group or a section.

Error In Formula Record Selection This Field Name Is Not Known

Whatever the report format is (the crystal report name minus the rpt extension), you need to rename the view to the same thing. I am developing/running a custom Crystal report (Command based) with several multi-select parameters. Ask a Question, Get an Answer (June 3 - June 10) Follow us on Facebook Follow us on LinkedIn Follow us on Google+ Follow us on Twitter Contact Us Privacy Policy Country code lookup for each line in a CSV file In the code "{ exec >/dev/null; } >/dev/null" what is happening under the hood?

However. Feedback Please tell us how we can make this article more useful. crystal-reports share|improve this question edited Jun 1 '15 at 5:53 shA.t 8,81141746 asked Jan 25 '10 at 19:34 user258710 You say it's working elsewhere – would you post a This Field Name Is Not Known. Details Errorkind Error In File Temp but all of my parameters are String.

So if the view name in your 08610EX report is something like vr_08610DP, you need to rename it to vr_08610EX. On Crystal 2008 (released with SL 2011) field names have to be fully qualified (tablename.fieldname or view.fieldname). If you won't ever have multiple users running the report at the same time, sometimes you can get away without the preprocess. Add a Solution Add your solution here B I U S small BIG code Plain TextC++CSSC#Delphi / PascalF#HTML / XML / ASPJavaJavascriptObjective-CSQLSwiftPerlPHPPythonVBXMLvar < > & link [^] encode untab case indent

share|improve this answer answered Feb 9 '12 at 2:55 paulmelnikow 12.1k32986 add a comment| up vote 0 down vote Can you save the report with the selection criteria you'd like then Crystal Report Show Sql Query This Field Name Is Not Known Name: *And who are you? Left by Lovjith on Mar 15, 2010 7:32 AM # re: Error:'This field name is not known' in Crystal Report when using a SQL View Thanks for ur info Left by Click your Microsoft Dynamics SL database, and then click Next . 5.

This Field Name Is Not Known. Details Errorkind Error In File Rpt

If the report format is 08610EX, we are going to assume the view name is vr_08610EX. If the report format (in report control maintenance) is 08610SP, we assume the view name is vr_08610SP. Error In Formula Record Selection This Field Name Is Not Known This tool uses JavaScript and much of it will not work correctly without it enabled. Crystal Report Forms Viewer The Field Name Is Not Known Connect The Blackbaud team is online and ready to connect with you!

Click Finish . 7. check over here All rights reserved. I've complained about overuse of abbrevs in questions before... –Cody Gray Feb 3 '11 at 13:29 What happens if you select Database | Verify Database? –craig Feb 3 '11 The custom reports do run if we remove the preprocessors from the reports in Report Control Maintenance. Error In Formula In Crystal Report

Are there any known incidents of ejections by capsule? Tighten space to use less pages. Your Email This email is in use. http://evollux.net/crystal-report/crystal-report-viewer-for-64-bit-windows-7.html I saw on this site where this problem was fixed for a date parameter .....

Please turn JavaScript back on and reload this page.All Places > CA PPM > DiscussionsLog in to create and rate content, and to follow, bookmark, and share content with other members.AnsweredAssumed Errorkind Crystal Reports Formula Sign in using Search within: Articles Quick Answers Messages Use my saved content filters home articles Chapters and Sections> Search Latest Articles Latest Tips/Tricks Top Articles Beginner Articles Technical Blogs Posting/Update The VB application is using the Crystal reports version 8.

Visit Chat Related 2crystal reports 11 : blank field bombs the report1Crystal Reports: Error on Sum in Formula Field0Parse strange field in Crystal Reports0Error: “This field name is not known” while

Enter your log on information. So when running the report from the BO environment, it was pointing to the old database that did NOT have the new field/attribute. To do this, follow these steps: 1. Error In Formula Section Visibility Crystal Reports Your Email Password Forgot your password?

The report actually runs from VB6. 0 Message Author Closing Comment by:tesla764 ID: 400046792014-04-16 Thanks everybody. 0 Featured Post Easy Project Management (No User Manual Required) Promoted by Quip, Inc Chat with Support Chat with our experienced staff to receive help right away. Details: errorKind Error in file 03810 {62E1DE95-319E-42E3-B58B-AC055D0D04BB}.rpt: Error in formula Record_Selection: '({vr_03810.cRI_ID}=4) AND (({jmt_vr_0310.batnbr} like '*31956*'))' This field name is not known. weblink Not the answer you're looking for?

Anita Reply Mark Asmus Works For Plumbline Solutions in Ohio YouTube Website My Badges Mark Asmus responded on 6 Feb 2015 9:27 AM Anita, What is the exact error you are Let's work to help developers, not make them feel stupid. On the Database menu, click Set Datasource Location . 3.