Search results for query: *

lbass... You are a star! Thank you!

The Qty & Description etc, are in a grouping field. The detail is hidden as they don't want to see the individual records. As a test, I exposed the detail line, and there are no hidden detail lines. I then took lbass's suggestion and created a new formula with the code. No luck. That field came...

...total value of the number of barcodes. That formula is named @Test and is this: If Isnull({hetype.Replacement}) then 0 else {hetype.Replacement}*{#TotalBarcodeType} From that, I then have a running total calculation to give me subtotal of @test for the category of equipment. This formula...

Strange one here... Using Crystal 8.5 with a paradox database, I am exporting invoice information to an Excel file in order to be imported into QuickBooks. However, when I create the export, the Sheet tab uses the file name of the Report (salesinv.rpt), and the importing into QB program doesn't...

Unfortunately, it's not set to repeater the header.. I wish it was that easy :)

I am using Crystal 8.5 with a Paradox database. I have a subreport that uses a shared currency variable (e2) that subtotals a prediscounted price field, so if 10 records are $10 each, the shared variable(e2) subtotal is $100.00. This subreport is an equipment list, of which there can be more...

I am using Crystal 8.5 on a Paradox DB. Customer has requested the terms of their contract be inserted into the rental agreement, however, they would like to be able to edit the terms without needing to do it in Crystal. They would like to be able to edit a text file in Notepad (or even a Word...

Mike! Thank you so much. Works a treat!

Helps Immensely Pete! (sorry, out of the country for a couple days!) Thanks so much! Greg

Ok. I was nearly there... Turns out they have some 1 name people in the field. I accounted for the 1 or 2 instances, but in addition to Fred Bloggs Greg Smith Doreen So... I figured out how you did the 2 names, and I think I can figure it if 3, but what about 1 name?

Awesome! Thanks Pete! .. Now saved in my personal FAQ!

I know I am being daft here, but I cannot locate this anywhere. I am using Crystal 8.5 on a Paradox database. I have field that contains either a first name and last name, as well as an "Unknown" (that's the actual text). So examples would be Greg Smith Fred Bloggs Unknown !Default I would...

I am using Crystal 8.5 with a paradox database. We have a field that stores the date a record is created. So, I have created a report that select all records where the job was created yesterday. {@BookDate} = (Today)-1 However the user came back and said they cannot run that report on Monday...

Your result gave me the same result (although formatted much nicer!). But the figure still appears off.. A check of the start & end times results in the correct number of seconds, so I don't think the problem is related to the conversion from seconds to hours/minutes, but I am guessing in how it...

I am using Crystal 8.5 on Paradox database. I have an out and back field (both datetime) which I am calculating the duration between the two correctly. So, 9:00 am to 5:00 pm is 8 hours and so forth. So it looks like: 5/1/2012 9:00 AM 5/1/2012 5:00 pm 8:00 5/28/2012 8:00 AM 5/29/2012 6:00...

Thanks so much..

I am using Crystal 8.5 with a Paradox database and customer has requested an average discount across 2 or more records. The discount field is a string field, so I tried ToNumber({eqlists.discount), which worked great until I had a discount that was 23.457E261, which of course is a 261 digit...

Ta da! Thanks Brian.. Tell Stewie I said hey! :-) (I knew Peter could never handle that!)

I am using Crystal 8.5 with a Paradox database. I have a field with a full name (Fred Bloggs) and I need to create a salutation in a cover letter. "Dear Fred," Currently, I use this formula: "Dear " +Left({Jobs.Contact},InStr({Jobs.Contact}," "))+"," However, when it runs it shows Dear Fred...

Brilliant! I imagine you will have forgotten more than I will ever know. Thank you so much.