Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Record selection formula in sql command in Crystal report

Dear all,

I have some filter query  to pass as record selection formula in crystal report. I am having some problems with below sql command .

in some of filter im getting errors.

Kindly help me ..

1. ({AddDedTypeRights.AdddedType} Like 'SYS[_]%%' Or  {AddDedTypeRights.AdddedType} Like 'SYSL[_]%%' )

this is a part of record selection formula filter..  Is this ok? (correct in syntax?)

2. {AdddedTran.EmpID} Not In [Select {FinMast.EmpID} From FinMast With (NOLOCK) Where {FinMast.Status} = 35]

Its wrong..  tell me the proper way..

3. ({LeaveTran.SalaryStatus} & 8) = 8)

how to make this correct.....?

kindly reply me please

Former Member

Hi Denson,

1) This should be:

({AddDedTypeRights.AdddedType} Like ['SYS[_]*', 'SYSL[_]*' )

2) You cannot pass a 'select' clause inside a record selection formula

3) Not sure what you're trying to do here


1 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question