<Crystal Reports 8.5 with Oracle.>
I have a report that has a subreport. The main report has a formula like this:
//@InitIDsPassed (this formula is in the group header)
Shared Stringvar x;
x:="";
//@IdsPassed (this formula is in the details)
Shared Stringvar x;
if {Employee.ID} in Split(x)
Then
x := x
Else
x := x +{Employee.ID}+ ",";
Subreport is in group footer section.
I have linked subreport via a @IdsPassed formula and unchecked the "Select data in subreport based on field". The record selection in subreport is:
(
{Employee.ID} in Split({?Pm-@IdsPassed},",")
)
This is where I get error "invalid range operator has been encountered" when I try to run this report from our web app. The report runs fine in Crystal.
I think the query engine is not recognizing the "Split" function. I am wondering if there is any other function that can be used instead of Split function? Any ideas?
I have a report that has a subreport. The main report has a formula like this:
//@InitIDsPassed (this formula is in the group header)
Shared Stringvar x;
x:="";
//@IdsPassed (this formula is in the details)
Shared Stringvar x;
if {Employee.ID} in Split(x)
Then
x := x
Else
x := x +{Employee.ID}+ ",";
Subreport is in group footer section.
I have linked subreport via a @IdsPassed formula and unchecked the "Select data in subreport based on field". The record selection in subreport is:
(
{Employee.ID} in Split({?Pm-@IdsPassed},",")
)
This is where I get error "invalid range operator has been encountered" when I try to run this report from our web app. The report runs fine in Crystal.
I think the query engine is not recognizing the "Split" function. I am wondering if there is any other function that can be used instead of Split function? Any ideas?