Parameters and Select Expert 1

[Rachel30]

Hi,

I have this code in the select the expert.

(not ({spPolicyDetailsRachelNew;1.Schedule Number} startswith ["Q", "R"]) or
{spPolicyDetailsRachelNew;1.Schedule Number} Like {?Schedule Number}) and
{spPolicyDetailsRachelNew;1.bLive} and
Not({spPolicyDetailsRachelNew;1.Surname} = "Test") and
If {?Type of Schedule} = 1 Then {spScheduleCoverSection;1.CREATED} in {?Start Date} to {?End Date} Else
If {?Type of Schedule} = 4 Then {spScheduleCoverSection;1.dVersionDate} in {?Start Date} to {?End Date} and
{spScheduleCoverSection;1.iPolicyType} = {?Type of Schedule} and
{spScheduleCoverSection;1.ProductFamilyID} <> 5 and
{spScheduleCoverSection;1.sProductType} like {?Product Family} AND
({spScheduleCoverSection;1.iProductTypeID} <> 39 or
{spScheduleCoverSection;1.iProductTypeID} <> 57 or
{spScheduleCoverSection;1.iProductTypeID} <> 79)


The last part :-

({spScheduleCoverSection;1.iProductTypeID} <> 39 or
{spScheduleCoverSection;1.iProductTypeID} <> 57 or
{spScheduleCoverSection;1.iProductTypeID} <> 79)

does not seem to work the report still brings in data for the iProductTypeid of the 3 I have requested it to not equal any idea's what I am doing wrong. Thanks Rachel

 

[Memento]

Rachel30,

I don't know if this helps at all, but you might try this:

not ({spScheduleCoverSection;1.iProductTypeID} in [39, 57, 79])

The flat file database I use does NOT like "OR" statments for some reason. Instead, I use the "IN" or in this case Not "IN".

 

[Rachel30]

Hi,

Thanks that worked. There was another problem aswell which was:-

If {?Type of Schedule} = 1 Then {spScheduleCoverSection;1.CREATED} in {?Start Date} to {?End Date} Else
If {?Type of Schedule} = 4 Then {spScheduleCoverSection;1.dVersionDate} in {?Start Date} to {?End Date}

I updated my stored procedure to deal with this thanks.