SAP BusinessObjects XI 3.1 Error

Ray Turner
Ray Turner used Ask the Experts™
on
I have several fields i wish to concatenate and display as a single string within a detail section.  

a. Is there a limit on the number of fields that can be concatenated?
b. Is there a limit on the length of the resulting string?

When I run the report in SAP BusinessObjects XI 3.1 I get the following cryptic error when I try to go to the next page.
message: Syntax error
description: Syntax error
number: -2146827286
name: SyntaxError

However; when the report is ran in Crystal Reports 2008 it works fine.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
How are you concatenating?
Is this a Crystal Report you are running in BO?

How did you upload the report to BO?

mlmcc
Ray TurnerSenior Consultant

Author

Commented:
How are you concatenating?
Using a + sign

Is this a Crystal Report you are running in BO?
Yes

How did you upload the report to BO?
Using Crystal Reports
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
>>a. Is there a limit on the number of fields that can be concatenated?
     AS far as I know there is no limit. The fact that it works in CR 2008 is a good indication of that.

>> b. Is there a limit on the length of the resulting string?
    I think there is a limit but it is quite lengthy like 4096 or even higher.

So the report shows page 1 correctly but when you try to move to the next page you get the error?

I don't know if this will help or not.
https://launchpad.support.sap.com/#/notes/1785203

mlmcc
Ray TurnerSenior Consultant

Author

Commented:
Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial