Why is this an error with Crystal Reports 9

[tawild71]

I created a Crystal Report that has a record selection statement that was tested with no errors in Crystal Reports. However, when I move the report to a viewer and run it, the viewer gives an error message:

The following report engine error has occurred - Error in file \\<server name>\LateVoilationDetailUserDay.rpt: Error in formula <Record Selection>
{IO_RTAException.SchedulingUnit} in {?UnitName} and
This field name is not known. There is a formula error in the replacement formula text. Reveiw the formula syntax and retry. Error Code (515)

The entire record selection formula:

{IO_RTAException.SchedulingUnit} in {?UnitName} and
{IO_RTAException.StartDateTime} in {?ReportDateTime} and
{IO_Agent.UserName} in {?UserName} and
{IO_RTAException.StatusKey} in ["AT LUNCH","ON BREAK","GONE HOME"] and
if {IO_RTAException.Excused} =0 OR IsNull ({IO_RTAException.ExcusedLength}) then
{IO_RTAException.SecsOutOfAdherence} >= 60
else
({IO_RTAException.SecsOutOfAdherence}-{IO_RTAException.ExcusedLength}) >= 60

The viewer is Interaction Supervisor from Interactive Intelligence. I have rechecked the field and parameter names. It is a part of a telephony phone system for call centers. I'm wondering if anyone could see anything wrong with this or what could be generating the error?

Thanks

 

[Turkbear]

What is beong passed as {?Unitname}?

Does the viewer have full rights to the datasource(s)?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[AndrewBaines]

Delete the whole selection formula, then add it back bit by bit. Then you'll know exactly which bit isn't working.

Also, is the version of crystal used in the viewer the same as that you're designing with? It may be throwing the error here when, in fact, the problem is elsewhere. If you've used something in a newer version of Crystal, it may not be supported else where - optional parameters perhaps?

Andrew Baines

http://www.pursuittechnology.co.uk