Print Page | Close Window

@LineItemTotal

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=2065
Printed Date: 03 May 2025 at 8:02am


Topic: @LineItemTotal
Posted By: grant21
Subject: @LineItemTotal
Date Posted: 17 Jan 2008 at 12:26pm
Hi guys, complete newbie question here,
 
I'm working with the default invoice report in Crystal Reports 9 (Integrated version with ServiceCEO 6.1). Is there any way to have @LineItemTotal not show a number for items included in a kit?  (Under "Amount".) @RateAsCur  so far is doing exactly what I want.  ("Price")
 
Here's a link to an example pic of where I'm at so far. 
 
http://img120.imageshack.us/my.php?image=test2mb3.jpg - http://img120.imageshack.us/my.php?image=test2mb3.jpg  


Replies:
Posted By: Lugh
Date Posted: 18 Jan 2008 at 5:37am
Sure, that's just a conditional suppression.  Easy as pie.

Right-click on the field.
Go to Format Field.
Go to the Common tab.
Click on the "x-2" button next to where it says "Suppress".
Enter the criteria to suppress the field.  This might look like:

@LineItemTotal = 0

or
Instr({MyReport.PartID},"kit") > 0
//This would indicate that the part ID had the word "kit" in it, if that's the indicator you want to use.


That should pretty much do it.  The last step is to go buy Brian's book.  Because it will help with all the newbie questions, and even answer ones you haven't thought to ask yet.  Wink


Print Page | Close Window