Add Formula to Field
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
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=21444
Printed Date: 08 May 2024 at 2:39pm
Topic: Add Formula to Field
Posted By: MikeColeman407
Subject: Add Formula to Field
Date Posted: 21 Apr 2015 at 7:15am
Hello, I am brand new to Crystal and SQL. I have a simple report with two tables using Crystal 2008 v12.1.0. I am using 6 fields from these tables with join. The report is going to tell me who has a net zero check. I have a field called TRANSAMT that is going to be the pre-check amount. I would like the report to only pull in checks that have an amount of 0 or less. Please advise. Thank you for your expertise.
Mike
|
Replies:
Posted By: hilfy
Date Posted: 22 Apr 2015 at 6:53am
Go to the Select Expert, select the TRANSAMT field "is less than", type the number 0, and save.
This will filter out records that have a TRANSAMT that is greater than 0.
-Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
|