Error "The remaining text does not appear to be part of the formula.."

[celine7822]

I have a crystal report, with 2 subreports in the main report.

The 2 subreports are linked to the main report through the formula field, eg. {@clientcode}

To access this report, user need to use an VFP application to view the report. On the VFP app, I will allow user to input the clientcode and pass this var to the CR. But the CR will return me this error "The remaining text does not appear to be part of the formula..." both at the subreport and main report level.

If i remove the subreports, there will be no error. Can someone help me?

 

[SurfingGecko]

Open up your formula and move the cursor as far to the bottom and to the right as possible. Do you have any extra spaces after your last bit of code?

If you do, backspace the cursor to the last character and resave the formula.

I have seen the extra padding cause issues like this

Cheers,

SurfingGecko

http://www.surfinggeckosoftware.com

Home of Crystal Ease

 

[celine7822]

I have checked. There are no blank spaces..

But the funny thing is that on the same rpt itself, no error when there are no subreport. Error is prompt when i add a subreport to the main.

 

[synapsevampire]

I'm guessing that one of your subreports has a bad formula, try opening them directly.

-k

 

[SurfingGecko]

yup, check 'em all to make sure. You can start be removing one and see if the report still runs. This may help you isolate the culprit.



Cheers,

SurfingGecko

http://www.surfinggeckosoftware.com

Home of Crystal Ease

 

[chelseatech]

The other reason you may get this error is if the formula uses a function based on a UFL.

So on the development machine, the UFL is present, so the function is fine, but on the second machine, the UFL isn't present, so the formula is invalid. Install the UFL on the second machine. All the functions listed under "Additional Functions" are based on UFL's.


Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[SurfingGecko]

Good point cheals...

Forgot about the UFL's all together...




Cheers,

SurfingGecko

http://www.surfinggeckosoftware.com

Home of Crystal Ease

 

[Reebo99]

When this error comes up, crystal normally opens the offending formula and highlights the text which it doesn't like.

Post the formula CR is complaining about, you'll probably find you haven't ended a line correctly with either ) or ;

Reebo
Scotland (Sunny with a Smile)

 

[celine7822]

Hi all,

I have managed to solve my problem. Not sure what was the exact cause as I have did all the subreports as individual report and called these reports from the VFP program. It works fine. I have merged these reports as one. I have not encounter any problem yet.

I will be testing the reports on another machine & hopes nothing happen and I will keep a lookout for the UFL..

Thanks Guys! :-D