Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Arrays causing grouping problems

Status
Not open for further replies.

DLauryn

MIS
Dec 30, 2003
1
US
I have an array which calls multiple values in a group header. When this occurs, other calculations within the header section are summing with the number of returns on the array. Is their a solution on the group by or do I need to do additional calculations on the sum function in the existing header? If a calculation is necessary, how do I caputre a variable for the number of returns on my array. This is what is causing the calculations to increase by 1, by 2 etc. Any help or suggestions?



 
Consider posting your version of Crystal, database, example data and expected output, the actual formula being used would be useful too.

Arrays are fairly simple, but they don't lend themselves to summing without iterating through them, and in most cases, an array isn't required for this.

-k
 
This may make sense to you but we have no clue as to what you are talking about.

Post formulas and report layout as well as example of what you expect to get and what you actually see....then we may be able to help you.....READ MY TAG LINE.

"how do I caputre a variable for the number of returns on my array

?? makes no sense to me...unless you are breaking up a database variable using "split" into an array and want to know the number of elements of the array .... then Ubound() would give that to you.

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top