Trying to print preview Trial Balance Report I recieved the following error :
Crystal Report Window Forms Viewer
This field is not known
Details : errorKind
Error in file 01610a {}.rpt, error in formula record selection
This field name is not known
Any help is greatly appreciated!
Hi Rocky,
Thanks for the information. So it's just the GL Trial Balance that isn't working. This error could be a result of not having the correct 'Period Field Name' specified in the Report Control Maintenance - Control Options screen. So click on the Administration menu, open the Report Control Maintenance screen, enter 01610. Click on Control Options. The 'Period Field Name' should show vr_01610a.Period_Post.
See if this could be the issue.
Carolyn
Technical Support Engineer
**This posting is provided "AS IS" with no warranties and confers no rights.
Hi Kim,
Is the Trial Balance customized? Do you see a copy of the 01610 report in the Usr_Rpts folder? If so, what is the name of the file that you are trying to print?
If you rename that file and let the standard version of the report print, does it print without error?
There could be several reasons for the error if the report is customized. Let me know what you find when answering the above questions and I'll give some things to look for if the report is customized.
Carolyn,
I am getting the exact same error. Report is the installed copy 01610a.
If I run as a user I get ROI.exe has stopped working. As Admin user I get the same error reported.
Also getting similar errors in a few other reports (both custom and standard).
We are testing upgrade to SL2011 on clean install.
Are you using SL 2011 plain or with SP1?
SP1 is loaded. ROI.exe ver= 8.1.21108.1
Hi Rock,
Check the Printer Setup in the Applications menu. Do you have a valid printer specified?
Do you get the error when you print preview? Or when you print to a file?
Printer is good. Tried to print and/or preview. Both raise same error.
Here's what I've done so far.
Set to SL to Windows default (working printer).
Verified Rpt is standard not custom
Most reports run (printed and preview) successfully.
Ok, adding the vr_01610a. to Period_Post fixes the Combined Totals report. The Dr_Cr Totals (01610B) and the Unposted Curr Pd (01610BUN) versions still fail.
I can't seem to paste in a screen shot of my Control Options for the 01610 report. Can you paste in a screen shot and I would be able to see if anything else needs to be changed.
Hi,
The Control Options look fine. Looks like you have 3 formats of the report. One works (01610a), one is standard (01610b) and doesn’t and one is custom and doesn’t. The pb_01610 preprocess is what should be allowing the 01610b format to run. Specifically the following lines in that stored procedure:
IF @Rep = '01610B' or @Rep = '01611B'
BEGIN
-- If its a different format, change the table name.
SELECT @RI_WHERE = REPLACE(@RI_WHERE,'vr_01610A.','vr_01610B.')
SELECT @StdSelect = REPLACE(@StdSelect,'vr_01610A.','vr_01610B.')
END
Do you have access to SQL Server Management studio? If so, I would do an SP_Helptext on the pb_01610 proc and verify it matches a working install… specifically that the above lines of code are in there.
SP_helptext pb_01610
For the custom report, you would need to do something similar to the above lines of code to swap out the vr_01610A part of the WHERE clause and replace it with the actual name of the table/view in your custom report.
Let me know what you find.
Thanks for the quick responses. Our stored proc is exactly as you have it. Any other ideas?
Rocky,
Could there be a copy of the 01610B in the Usr_Rpts folder? If so, can you rename and test again?
Our Term server was using different Usr_Rpts folder. Found and fixed custom reports. Your fix to rptcontrol and custom reports now working. Thanks for the help.
Hi Carolyn,
Your suggestion to update the report options worked. We are also having the same issue/error with the Detail General Ledger report, how would i update the report options for this item?
Thanks again,
Kim