Re: sql expression

Forget the sql expressions and functions. Create a stored procedure
similar to that shown below in SQL Enterprise Manager. Use this stored
procedure as the data source for your report. Crystal will create the
parameter fields (param1, param2 and param3) or whatever and how many
parameters you use. It will use the results of the select statement as
the database fields. I hope this helps.

CREATE PROCEDURE [dbo].[my_stored_procedure]
@param1
,@param2
,@param3

AS

DECLARE
@temp_table (define_your_table_here) TABLE

--put your logic below here

--put your logic above here

SELECT * FROM @temp_table

RETURN

.

Relevant Pages