Heres the sample data:
Salesperson Multi
Customer PD002
Item Code / Item Description
This is in Detail a > EXPFREGHT00010 FREIGHT EXPENSE
This is in Detail a > EXPFREGHT00010 FREIGHT EXPENSE
This is in Detail a > EXPFREGHT00010 FREIGHT EXPENSE
This is in Detail a >...
Hi lbass,
Thanks for the reply, I dont think I have a group. I'm basing the detail line by the ItemDesc field.
I tried:
not onlastrecord and
{UXDETAIL.ItemDesc} = next({UXDETAIL.ItemDesc})
It doesnt work, thanks though.
Hi I have a Crystal Report v10 where in my detail line I am displaying many records based on the Itemcode and Itemdesc fields.
Inside my Detail a/section expert/suppress/x-2/ I have this code: ({UXDETAIL.ItemDesc} = next({UXDETAIL.ItemDesc}))
Everything works fine unless I have this senerio -...
No the running totals having null values is not the issue.
The issue is when i need to create a grand total on this formula and when i try that it starts with the error.
Without trying to total this formula i get no errors.
But i need a grand total.
*Thinks*
The content of that formula is:
if tonumber({UXDETAIL.FiscalYear}) = ({?Year}-1) and {UXDETAIL.FiscalPeriod} = {?month} then
{UXDETAIL.Quantity}
Thanks.
Hi Ian,
Thank you for replying.
In the detail line i have the #Total1 and #Total2 running totals displaying for each speficic field.
These running totals total up the formulas which are suppressed on the detail line.
i.e.
@VarianceCurrentMonthQuantity formula:
{@Quantity}-{@PriorQuantity}...
Hi,
I have a Crystal Report v10 report where i have two running totals (i.e. #Total1, #Total2)
I need to divided these totals by each other within my @Sales formula located on the detail line:
#Total1/#Total2
When i try diving them i get an error saying:
A running total cannot refer to a...
Incase anyone wants to know how to suppress duplicated record values in the detail line here is the formula you can put in the Detail Section Expert -> Suppress -> x-2 ->
Formula = ({TABLE.FieldName} = Next({TABLE.FieldName}))
I need a Crystal Reports 10 formula on my Detail section suppress similar to this:
(This formula is for ASP.NET)
Formula = ({UXDETAIL.ItemDesc} = PreviousValue({UXDETAIL.ItemDesc}))
I need the same concept just different sytax i guess cause this doesnt work in Crystal Reports 10.
Thanks.
Visual Basic 6 and Accpac Applications which are developed in VB6 environment with Accpacs additional add-ons, its pretty neat.
Eventually I'm sure they're going to upgrade to VB.NET though.
I live in Mississauga, and i can travel (public transportation so it cant be too too far).
Classroom...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.