Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2016 : Report Design
Message Icon Topic: Returning results based on parameters Post Reply Post New Topic
<< Prev Page  of 2
Author Message
shabbaranks
Groupie
Groupie


Joined: 06 Oct 2013
Location: United Kingdom
Online Status: Offline
Posts: 64
Quote shabbaranks Replybullet Posted: 26 Jul 2018 at 10:00am
Annoyingly its still retuning all date values even if with the parenthesis :(
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 8937
Quote DBlank Replybullet 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}

Edited by DBlank - 26 Jul 2018 at 12:05pm
IP IP Logged
shabbaranks
Groupie
Groupie


Joined: 06 Oct 2013
Location: United Kingdom
Online Status: Offline
Posts: 64
Quote shabbaranks Replybullet 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}
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 8937
Quote DBlank Replybullet 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"

Just a heads up on it.
IP IP Logged
<< Prev Page  of 2
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.031 seconds.