| Author |
Message |
aeromonte
Newbie
Joined: 25 Feb 2008
Location: United States
Online Status: Offline
Posts: 18
|
   Topic: Select Expert - or - Formula help
Posted: 07 Mar 2008 at 11:57am |
I would appreciate anyones help with an easy problem I am having - well I dont think it's so easy 
I need to filter my report results by two criteria fields.
a "trantype" code and from a specific date.
I need to EXCLUDE all records that have a "trantype" = "adj-cst" ONLY on "sysdate" "11/20/2007" (both fields are from the same table)
The problem with the Select Expert is that you can only choose one field for your criteria - you can create a formula.... But that is where I guess I need the help.
Thanks!!!!
John
|
 IP Logged |
|
|
BrianBischof
Admin Group
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
|
Posted: 07 Mar 2008 at 12:35pm |
|
In the Select Expert you can click the Add button to filter by more than field. Have you tried that yet?
|
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
|
|
IP Logged |
|
aeromonte
Newbie
Joined: 25 Feb 2008
Location: United States
Online Status: Offline
Posts: 18
|
Posted: 07 Mar 2008 at 12:48pm |
But I don't want to restrict all those codes (adj-cst), just the records with those codes ONLY on 11/20/2007.
If I filter adj-cst, then other records will not pull because those codes are also in other records with different dates
Edited by aeromonte - 07 Mar 2008 at 12:49pm
|
|
IP Logged |
|
fawndog
Newbie
Joined: 10 Mar 2008
Location: United States
Online Status: Offline
Posts: 6
|
Posted: 10 Mar 2008 at 1:32pm |
|
I have this feeling that you are working in Vantage? Am I right?
|
|
IP Logged |
|
aeromonte
Newbie
Joined: 25 Feb 2008
Location: United States
Online Status: Offline
Posts: 18
|
Posted: 11 Mar 2008 at 5:07am |
Yes 
That is correct - Epicor Vantage
 = what Vantage tables/system are doing to me!! |
|
IP Logged |
|
fawndog
Newbie
Joined: 10 Mar 2008
Location: United States
Online Status: Offline
Posts: 6
|
Posted: 11 Mar 2008 at 11:51am |
|
Yep... it just sounded too close to home there... the table that you are working in ... PartTran... very difficult. I am struggling also with creating an obosolete finished goods report. You are not alone with this baby.
|
|
IP Logged |
|
Bill D.
Newbie
Joined: 16 May 2008
Location: United States
Online Status: Offline
Posts: 1
|
Posted: 16 May 2008 at 8:58am |
My manufacturing company is thinking of buying Epicor Vantage.
Does Epicor use Crystal for its report writer? Or are you using Crystal because
Epicor has a poor report writer. Right now we are on Microsoft Dynamics and use
Crystal for all manufacturing and purchasing reports as the dynamics report
writer is so complicated.
Also any comments about Epicor Vantage, pro or con
would be appreciated.
|
|
IP Logged |
|
Tim Wise
Newbie
Joined: 29 Apr 2008
Location: United States
Online Status: Offline
Posts: 31
|
Posted: 16 May 2008 at 11:47am |
Originally posted by aeromonteBut I don't want to restrict all those codes (adj-cst), just the records with those codes ONLY on 11/20/2007.
Sounds like you need an If-then-else:
if (date is 11/20/2007 and trantype is adj-cst) then
suppress
else
select
I don't know if this can be expressed in a Crystal formula.
|
|
--
Tim
|
|
IP Logged |
|
aeromonte
Newbie
Joined: 25 Feb 2008
Location: United States
Online Status: Offline
Posts: 18
|
Posted: 16 May 2008 at 12:04pm |
Vantage uses Crystal as main report writer (Crystal CD says Epicor on it). All end users need a Crystal Runtime to run the reports.
All forms/reports are in .rpt format in Vantage and some reports/forms use XLM datasets that work with Crystal (Vantage system generates data and places in XML temp tables - then Crystal connects to them via XML connection and reports off of the temp fields/tables).
Crystal is nice - vantage VB.Net for software is not so nice....
|
|
IP Logged |
|
Tim Wise
Newbie
Joined: 29 Apr 2008
Location: United States
Online Status: Offline
Posts: 31
|
Posted: 17 May 2008 at 8:13am |
Originally posted by Tim Wise
Sounds like you need an If-then-else:
if (date is 11/20/2007 and trantype is adj-cst) then
suppress
else
select
I don't know if this can be expressed in a Crystal formula.
Here's an example of an if-then-else I used as a selection:
if ({dataroot/Metrics.IntervalNum} = 0 and
trim ({dataroot/Metrics.DetailType1}) = "")
then
false
else
true
|
|
--
Tim
|
|
IP Logged |
|
|
|
