Fetch and Crystal XI

[TimmieLynn]

I am trying to update Crystal 8.5 reports to XI. Is fetch no longer valid in version XI?

 

[synapsevampire]

I've never heard of a fetch command in any version of Crystal, perhaps you should state requirements instead?

Could it be that you're confusing PL/SQL's fetch from a cursor command?

There may have been a UFL by that name, but you should post what you're trying to do.

-k

 

[TimmieLynn]

What is happening is when I try to run the report that was created in 8.5 in XI I get an error saying the variable is not found. The formula it stops on is:

FetchNumberVar("variablename")

This report runs fine in Crystal 8.5.

 

[synapsevampire]

Why would you post about something called fetch when it's a function called FetchNumberVar?

This was a means in lieu of shared variables from CR 7 and up.

Here's the whitepaper:

http://support.businessobjects.com/library/kbase/articles/c2002618.asp

-k

 

[TimmieLynn]

THanks for your help but that is not the error I am getting (I am getting the error "variable not found")and I have already tried that solution.

 

[synapsevampire]

As the whitepaper points out, this is a very old way of doing what is commonplace in Crystal now using shared variables.

If you had already tried that, you would have resolved this.

Convert the formulas to use shared variables, it's simple to do and you eliminate the overhead of a UFL.

I would also suggest that in future posts you state specifics in the beginning, this approach is better suited to blog building than resolving problems.

-k