Writing Code
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Writing Code
Message Icon Topic: Different results Post Reply Post New Topic
Author Message
Leeb65
Newbie
Newbie
Avatar

Joined: 11 Feb 2010
Location: Ukraine
Online Status: Offline
Posts: 1
Quote Leeb65 Replybullet Topic: Different results
    Posted: 11 Feb 2010 at 7:32am
Hi all,
 
I have a problem with my reports in that, if I select all the distinct values of a column in my table as values in my record selection formula I get different results to if I select no values and also different to using the between function.
 
i.e.
1. {view.Codes} in ['1','2','3','4','5']
2. ToNumber({view.Codes}) in ToNumber('1') to ToNumber('5')
3. no selection formula for {view.Codes}.
 
1 to 5 is just an example, but all these methods produce different results.
 
Can anyone tell me why and maybe help me to resolve this error.
 
Thanks,
 
Lee
http://www.sawdesigns.kiev.ua
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 11 Feb 2010 at 1:15pm
Without looking at the data, I cannot be sure.
1. This one should, select all {view.codes} that match (exactly) the string values of 1 or 2 or 3 or 4, or 5.
2. Never tried this method, but I am speculating that it will any {view.Codes} are in range 1 to 5, thus if the {view.Codes} contains decimals (i.e., 1.2, 3.4, etc.) they should be included.
3. This should return everything.
 
Hope this helps.
IP IP Logged
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.016 seconds.