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

Crystal Report Viewer Error This Field Name Is Not Known

Contents

On Crystal 2008 (released with SL 2011) field names have to be fully qualified (tablename.fieldname or view.fieldname). Sets the datatable as the datasource to the report View the report. I wanted to enter the solution here so it may help someone else with this error message! You will need to do the same thing with any view based report that you have copied to a different name. http://cdhca.org/crystal-report/crystal-report-viewer-for-64-bit-windows-7.php

Great for personal to-do lists, project milestones, team priorities and launch plans. - Combine task lists, docs, spreadsheets, and chat in one - View and edit from mobile/offline - Cut down Is this causing the issue? DB Reporting Tools Oracle Database Polish Reports in Access Video by: crystal Polish reports in Access so they look terrific. share|improve this answer answered Feb 3 '11 at 13:01 Josaph 41937 The Formula is in the Where condition of the selection query. –user601501 Feb 3 '11 at 13:11

Error In Formula Record Selection This Field Name Is Not Known

Dave Tags: Crystal Microsoft Dynamics SL field name is not known Reply All Responses (7) Only Answers Dave Simon My Badges Verified Answer Dave Simon responded on 21 Nov 2012 5:57 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 Thanks in advance. 0 Comment Question by:tesla764 Facebook Twitter LinkedIn https://www.experts-exchange.com/questions/28414009/Crystal-Reports-error-The-Field-Name-is-not-Known.htmlcopy LVL 22 Best Solution byplusone3055 Usually when this is happening the locatio nof hte database has changed or possibly the

In the Replace With box, expand Create New Connection , and then expand ODBC (RDO) . 4. Print Preview results in error message: Crystal Report Windows Forms Viewer - This field name is not known. more hot questions question feed about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Science This Field Name Is Not Known. Details Errorkind Error In File Temp Solutions for holding oscilloscope probes (and freeing up hands) Bach prelude BWV 924 Output the sign Big numbers: Ultrafactorials Is it possible to replace a file with a hard link to

My record select formula is as follows, I have dumbed it down for purposes of this error: reportDocument.RecordSelectionFormula = " {@ClientName} = 'Smith' " If I copy this exact selection statement This Field Name Is Not Known. Details Errorkind Error In File Rpt more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Extensible code to support different HR rules You earn money. So when running the report from the BO environment, it was pointing to the old database that did NOT have the new field/attribute.

Reply Carolyn Kolpien My Badges Carolyn Kolpien responded on 21 Nov 2012 6:00 AM Hi Dave, Did you try setting the datasource location? Crystal Report Show Sql Query This Field Name Is Not Known If the field is missing from the export, add the field to the export output. Also, the error says something about a temporary report file as well. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.

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

Covered by US Patent. what is the difference between `>> /dev/stderr` (with the white space) and `>&2`? Error In Formula Record Selection This Field Name Is Not Known What is the meaning behind the "all shapes and sizes" dialogue in Pulp Fiction? Crystal Report Forms Viewer The Field Name Is Not Known However, in my case, I tried doing as you told but it doesn't seem to work.

When I view the properties for the original stored procedure, the listed database is one that no longer exists. http://cdhca.org/crystal-report/crystal-report-viewer-runtime-download.php On earlier versions of crystal, you could pass something to the report like “period_post >= ‘201205’”, or “ri_id = 5”. To do that, open the report in Crystal, click Database > Database Expert. 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 Error In Formula In Crystal Report

mlmcc 0 Message Author Comment by:tesla764 ID: 400045722014-04-16 We are using Crystal 10. 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 For example, they are named as ENT MNT GEC, etc.... Check This Out Crack the lock code Are there guidelines for party stats by CR?

So if the view name in your 08610EX report is something like vr_08610DP, you need to rename it to vr_08610EX. Errorkind Crystal Reports Formula Details: errorKind Help!? :-) Thanks!! For now, I have fixed it by putting the SQL in the view within a Command in Crystal Report and its working.

IP Logged CircleD Senior Member Joined: 11 Mar 2011 Location: United States Online Status: Offline Posts: 251 Posted: 03 Feb 2012 at 1:48am Have you tried remapping the Tables?

When converting dynamic SQL (pivot query) to xml output, why is the first digit of the date converted to unicode? Then, click the database in the Current Data Source box. 8. Feedback Please tell us how we can make this article more useful. Error In Formula Section Visibility Crystal Reports but all of my parameters are String.

Urgent requests are best solved by using paid support channels, thereby I pointed to SAP as Crystal Reports current owner and (paid) support source. Linux questions C# questions ASP.NET questions fabric questions C++ questions discussionsforums All Message Boards... But it works fine in my computer. this contact form This is a topic that greatly interests me and so I decided to produce a video about it.

That should clear it up :) 0 Message Author Comment by:tesla764 ID: 400043972014-04-16 I will try that. I saw in a couple of places to look in app_niku.log, but I cannot find that log in the CSA.2) What is the correct sequence in copying a Command based report And which report(s) are you seeing it on? Usually the pre-processes are required, but sometimes all they are doing is filtering on RI_ID.

We have verified through SQL that the data exists.