Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 26 Jul 2018 at 12:05pm
maybe
({?Select Supplier} = "Select All"
OR
{SS_Supplier_View.Company Name} like "*" & {?Select Supplier} & "*")
AND
{@RecordDate} in {?Date From} to {?Date To}
Joined: 06 Oct 2013
Location: United Kingdom
Online Status: Offline
Posts: 66
Posted: 26 Jul 2018 at 9:20pm
Seems to have done the trick I think :) Thanks!!
I always get paranoid creating reports as you never can be 100% sure the correct data is there. This was what I went with in the end to catch the uppercase:
(uppercase({?Select Supplier}) = "All"
OR
{SS_Supplier_View.Company Name} like "*" & uppercase({?Select Supplier}) & "*")
AND
{@RecordDate} in {?Date From} to {?Date To}
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 27 Jul 2018 at 5:14am
the case should not be an issue but if you are worried about it you should match it entirely. You are applying the UPPER() function to the parameter but not to your data and the way you have set all you are definitively making the case not match on the 'all' option.
uppercase({?Select Supplier}) = "All" should be
uppercase({?Select Supplier}) = "ALL"
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
