Print Page | Close Window

Boolean in select expert

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5360
Printed Date: 29 Apr 2024 at 2:57pm


Topic: Boolean in select expert
Posted By: bec9196
Subject: Boolean in select expert
Date Posted: 29 Jan 2009 at 8:33am
I am trying to create a formula to only include distinct numbers in a report instead of listing the same numbers up to 5 times.  I have created a running total field but that did not work so I though to create a new item in Select Expert.  I opened the formula editor and added "DistinctCount ({requests.req_id})".  It gave me an error that said "A boolean character is needed here. 
Any ideas/help would be greatly appreciated.
Thank you.


-------------
Becca



Replies:
Posted By: lockwelle
Date Posted: 03 Feb 2009 at 6:27am
try shared variables.  allows for coding / your logic instead of having to use built in functionality that doesn't always work.



Print Page | Close Window