Search results for query: *

That fixed it... Thanks so much for your help I would have never have figured it out.

Yes it is the innermost group (group 2) and i do not have a suppression formula within the details

The formula is a subgroup. No suppressed groups. Not just on first records. Formula: numbervar x; numbervar y := x; numbervar x := {tblAPInvDistributions.InvDistID}; numbervar z; if x=y+1 then z := y else z := x; z Attached image is only showing one page of the issue... 70237 should have been...

okay I saw where I went wrong in the formula. I still have some that didn't group. Here is a sample 70226 separate group 70227 separate group 70237 separate group 70238 separate group 70249 separate 70250 separate Any ideas

So that worked for the first items but then fell apart. I have a group already set up based on the invoice ID. Within those groups is the individual invdistid numbers which is what I was needing the second grouping on. When it got to the second group I had the following numbers grouped under...

Thanks for replying. The only other detail item that I have that shows any type of connection is the transaction ID. The items that need to be grouped together are sequential in number but there is a gap between those and the starting of the next group. For example the items to be grouped...

Is there a way to group crystal report items that falls within a certain span of each other? I have several lines within each invoice on my crystal report. I currently have grouped by invoice number but I want to group lines within that group. The taxable amount of each invoice is calculation...

thanks again for all of your help

I had some transactions that were over 1,000 when I changed all of the formulas to the ^ I am not receiving the message anymore. Thanks so much for your help. Do I still need to check the number of members?

Will do... It's my county that is failing not the state with the current formulas (the array formula). The state only failed when I try to do the state formula within the details with the conditional formula

I put the isnull formula in name still got the error message regarding the array. I tried the state formula originally before the split. It would not work always pulls in a zero amount for the state.

Below is a sample of the output without the split function: Vendor Paid Date Invoice# Invoice Amt SalesTax Amount County BB&T 11/18/18 101118 106.45 2.13 Union BB&T 11/18/18 101118 106.45 5.06 NC State I grouped the report by vendor...

So I am pulling from a field that can have up to two values. I had to use a stringvar formula to show both amounts. I then used the split to break these two values into separate fields one is state tax one is county tax. I had to pull the items I needed from the details group into the group...

Array's dimension must be an interger between 1 and 1000

Hey guys I have the following formula: //{@one} if ubound(Split({@Tax County Footer}, ","))>0 then(split({@Tax County Footer}, ",")[1]) else "0" I believe I am having an issue because in the split I have some records that are null if this is the case it needs to skip @one and go to the @two...