Search results for query: *

Now that i look at it the solution doesnt differ at all, thank you too! *sorries* :)

Thank you lbass it worked when adding the third line of code. :)

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*

never mind it doesnt work.... the formula is created in the detail line

I figured it out, i used Ian's advise on just assigning it to another variable and it worked. Thanks.

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.

Hi dgillz, It's suppressing everything in the detail line. It's an interesting concept though, 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...

Hi, I have a detail section which prints many duplicate records. I have a running total on the detail section to show how many duplicate records are printing. ie: linecount#: 1 IC Item Code 00112X25000023 2 IC Item Code 00112X25000023 3 IC Item...

Yea I really should. Getting hired full time here after graduation in december (if all goes good) and theres lots of Crystal Reporting with these applications. What kind of training would it be though for just half a day?

Yes its picking up the values. I fixed it, i displayed the fiscal year and fiscal period on the report which where way off due to incorrect conversion that i had. So it wasnt reading the data properly. Thanks.

I dont understand whats going on with my detail line everything if condition that includes year and month criteria needs a true; before the field... which isnt right i should be using it like you've said before... WEIRD

Sorry the year is 2007.