Search results for query: *

lbass, Thanks for the help. That worked perfectly. I had tried using the maximum command in group, but I wasn't using the ,{table.customer} portion of it, and it was giving me a really high number. Thank you very much for the help though!!!

Madawc, Thanks for the response. I'll try to clear up what I'm looking for. I have a report which shows our customers (1 customer per page) along with a line item list of everything that's outstanding for them. Underneath that, I have totals based on how outstanding each line item is. For...

I created a statement report for work where it shows a range of our customers based on typing in a starting and stopping customer number and displays a statment for each customer (showing what they owe us or any deposits they may have). However, our accounting dept. has asked me to add the...

Thanks again. I was trying to make it way more complicated than it needed to be. Thanks for all your help synapsevampire. -Synbios1978

SynapseVampire, Thanks for the answer and the information. I've played around with it, and it's working, however when I try to transfer the number to a parent report, the last value is not included with the total. (i.e. if it should be 64,000 and the last record is 3,000, I'm getting 61,000...

Crystal Reports V. 9 I am trying to create a running total for a field ARInvoiceLine.Line-Amount. I only want the total to add when {ARInvoiceLine.Line-Distribution} <> "Sales" and on the change of the field {ARInvoiceLine.Trans-Number-Invoice} I can get one or the other to work using the...

I feel like a nitwit. The light wasn't on, but yes after hitting it again, it fixed it. Dang, do I feel like an idiot. Thank you very much. -Synbios1978

Quick question. I was just working in Excel 2000, and something wierd happened. I copied data from one sheet to another, but after pasting, when I would use my arrowkeys to scroll around, it would only change the screen position, not the selected cell. I'm guessing when I pasted I clicked...

synapsevampire, Thanks for all your help. I just figured it out. I put a criteria of null or 0 for the wizard-option, and that allowed me to remove the minimum function from the formula. Then I was able to take the maximum value. Thanks again for all your help!! -Synbios1978

Okay, I'll get detailed into the issue. This is a subreport, which references 7 different tables, however, this formula is only impacted by two of the tables. (There is one primary table with 6 different tables connecting off of it). Lets call the Primary table "Segment". The subtable I'm...

Actually, I spoke too soon. After testing it a little further, I am still stuck. The last response won't work because the fields do not come from the same table, and there can be many segment-ID's per report, plus a segment is the forth level of grouping inside the report. When I browse the...

Thanks for the reply. Let me try to explain what I'm trying to do better. Crystal version = 9 Database/connectivity = ODBC Example Data in database = 2 fields: Segment-ID and Wizard-Option. i.e. Record 1: Segment-ID = " 1" Wizard-ID = 1 Record 2: Segment-ID = " 1" Wizard-ID = 2 Record 3...

I have the following code: If IsNull({EstEntFolding.Wizard-Option}) Then "" Else Select {LOQSegment.Segment-ID}[1 To 20] Case " 1": IF Minimum({EstEntFolding.Wizard-Option}) = 0 Then "Fold" Else "" Case " 2": IF Minimum({EstEntFolding.Wizard-Option}) = 0 Then "Fold" Else "" Case...