What tables/fields are you linking on the report?

What tables/fields are you linking on the report?

AR_Customer / CustomerNo / UDF_LREPG (Sales Rep Group 4letters field)

AR_InvoiceHistoryDetail / InvoiceNo / ItemCode / QuantityShipped / QuantityOrdered / UnitPrice / VendorNo

AR_InvoiceHistoryHeader / InvoiceType / InvoiceDate

AR_InvoiceHistoryHeader (InvoiceNo Inner Join Not Enforced = to AR_InvoiceHistoryDetail InvoiceNo)

AR_InvoiceHistoryHeader (CustomerNo Inner Join Not Enforced = to AR_Customer CustomerNo)

I even tried to copy the SQL out and put it in a new report with Add Command and it wouldn't even work.

Add Division to the customer table link, and HeaderSeqNo to the invoice header / detail link.

Groups load all the report data into memory and then sort it, and CR is not a great database engine for that kind of thing. 

Add report selection criteria so the result set is smaller (i.e. less data processing for the CR engine).

Thanks Kevin, when you way Add Division do you mean adding another link?

AR_InvoiceHistoryHeader/HeaderSeqNo Inner Join Not Enforced = to AR_InvoiceHistoryDetail

I've criteria everything that I could

{AR_InvoiceHistoryDetail.VendorNo} = "0000833" and
{@Total Sale} >= 0.01 and
{AR_InvoiceHistoryHeader.InvoiceDate} = {?Date Range}

Thanks for all your help

Add another field to that table link.

Make sure you handle NULL values in your UDF.  CR notoriously doesn't deal with NULL field values well.  Perhaps add a report selection clause to exclude NULLs / blanks.

I have it starting on AR_InvoiceHistoryHeader