using a SQL expression when reporting from a stored procedure

[mdj3366]

I want to add the sql expression created here thread767-1462006 into a report. However, in the field explorer, i don't have the option to add a sql expression field. Is this occuring because I am using a stored procedure to report from? If so, is there another way to accomplish this? I am using CRXI. Thanks for any help.

 

[bdreed35]

I don't believe you can mix stored procedures and SQL Expressions. Why not just include the logic you need in the stored procedure?

~Brian

 

[mdj3366]

I would have to ask our outsourced administrator to add and that would incur additional expenses. Thanks for the response.

 

[Madawc]

You can select on records from a stored procedure. This is less efficient than changing the code, but if you can't change the code it should work.

Or you can group and suppress.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10