How to get Current System Process id in crystal report?

313 Views Asked by At

I want to add some sql query conditions into crystal report.

I add the a formula field SPID, and make the sql query as {ONE_TABLE.ONE_COLUMN_SPID} = {@SPID}

However, how to make the field SPID show the current system process id? or is there a function in crystal report to get current system process id? OR is there a way to put the argument @@SPID into the crystal report? (Ps, @@SPID is the way in Sql Server to get SPID)

SELECT * FROM ONE_TABLE WHERE ONE_COLUMN_SPID = @@SPID

Thanks. I really need your help.

0

There are 0 best solutions below