November 23, 2008 01:17am pst

1. mlmcc 2,053,179
2. peter57r 342,070
3. bdreed35 183,039
4. frodoman 148,615
5. James0... 144,264
6. CRXIuser... 109,094
7. wykabryan 102,124
8. crgary_tx 100,826
9. dougvarga 75,537
10. emoreau 69,045
11. analliah 55,968
12. IdoMillet 50,442
13. UnifiedIS 38,695
14. TheLearn... 25,057
15. ast2550 20,075
16. RickJ 19,280
17. zephyr_hex 17,850
18. JeffSturg... 14,600
19. mark_wills 12,625
20. rhinok 12,420
21. habibb 11,830
22. raterus 11,650
23. mnye 11,275
24. Rajendra... 10,460
25. Cootser 10,200

1. mlmcc 7,747,598
2. frodoman 3,171,554
3. bdreed35 1,560,490
4. peter57r 1,161,226
5. rhinok 707,479
6. CRXIuser... 460,467
7. GJParker 449,021
8. IdoMillet 434,298
9. EwaldL 329,724
10. crgary_tx 328,248
11. vidru 310,397
12. wykabryan 290,568
13. James0... 275,951
14. DRRYAN3 253,255
15. ebolek 210,829
16. Spykair 176,797
17. Outin 160,632
18. emoreau 150,783
19. dylanyee 130,141
20. ast2550 115,647
21. mnye 113,620
22. PATKIRSCH 103,954
23. ladylinet 101,616
24. janmarini 90,283
25. BriCrowe 82,994

09.06.2006 at 04:40PM PDT, ID: 21980527

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.2

Crystal Reports: Arrays and Filter

Asked by zephyr_hex in Crystal Reports Software

Tags: crystal, reports, array

CR 8.5

i am reading an example of using filter on an array:
filter(["abc abc abc abc abc","hjjh","hj abc hj"],"abc")[1]

what does the [1] mean at the end?

this is what i'm trying to do:
shared stringVar array qm3Array1;
shared stringVar array qm9Array1;
local stringVar qm3t1;
local stringVar qm9t1;
local numberVar qm3sizeArray1:=ubound(qm3Array1);
local numberVar qm9sizeArray1:=ubound(qm9Array1);
local numberVar cnt;
if cnt=0 then cnt:=1;
local stringVar result;

if qm3sizeArray1>1 then
(
qm9t1:=split(qm9Array1[cnt],",")[1];
//qm3t1:=split(qm3Array1[cnt],",")[1];
cnt:=cnt+1;
result:=filter(qm3Array1,qm9t1)[1];
);
result;

if i remove the [1] from the end of the filter statement, i get an error about needing a subscription on the array. if i replace [1] with [2] i get the same result as i have for [1].
i am trying to use filter to find/match the string in qm9t1 with an element in the array qm3Array1

so, for example, qm3Array1:
qm3Array1[1]=hammer,4
qm3Array1[2]=nail,5

and qm9t1=nail

i want to return 5.Start Free Trial

Keywords: Crystal Reports: Arrays and Filter

	Title
1	NumberVar -> StringVar
2	sorting stringvar's
3	Array issue
4	Crystal Reports: How to parse a stri…
5	Crystal Arrays???
6	CR XI- Trying to count using stringvar …

Loading Advertisement...

20080716-EE-VQP-32

Crystal Reports: Arrays and Filter

Asked by zephyr_hex in Crystal Reports Software

Tags: crystal, reports, array

About this solution