Print Page | Close Window

Different results

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Writing Code
Forum Discription: .NET programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=9095
Printed Date: 05 May 2025 at 3:41am


Topic: Different results
Posted By: Leeb65
Subject: Different results
Date 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


Replies:
Posted By: kevlray
Date 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.


Print Page | Close Window