Only 1000 Records in Crystal Selection Expert

[Ohioste]

Alright...so I am constantly running or looking for a set amount of data in Crystal reports.

Before now, I've just been running the report each time or creating multiple formulas for each list.

For example...I have 20,000 SKNs that I want looked up from a list of 50,000.

I cannot input all 20,000 or I get the error "Too many items have been given to this array"

Is this an error in the registry? I know that the LOV for Crystals is set at 1000 and I thought the two may be tied. I have CR2008 and I've updated LOV up to 30,000 but when I input my 20,000 SKNs...CR just magically shuts down!

Any help?

Thanks,
Ryan

 

[Turkbear]

Hi,
Any multi-value parameter creates an array and is limited by CR';s array limit which, I believe is 1000 and not alterable.

Try breaking your param into 20 sets of 1000 each.
OR
Create a command object with the SKNs you want and link it to the table's SKN field.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Ohioste]

Ok...thanks...not the answer I was hoping for .

But I do appreciate the information.

Thanks,
Ryan

 

[lbass]

Not sure what an SKN is, but why would you want to select 20,000 specific ones? There must be some other field that you could use to select these rows. What do these 20,000 records have in common? Same region? Same salesperson?

-LB

 

[Ohioste]

A SKN is a group of SKUs.

So, for instance, let's say we were talking about toys.

A group of cabbage patch kids would be considered a SKN.

Those would be broken down into SKUs by ethnicity.

So in our database, we have a bunch of SKNs and SKUs.

For a forecast that we have, we have specific SKNs that need to be pulled. So we need to take that information and break it down to the SKU level.

Hope that makes sense.

So unfortunately, there is no other information we can link it or sort it by.

 

[kenhamady]

Here are some options:

1) Create a table that has these 20K values in it, and link that to your field using an inner join. That way you don't have to enter anything.

2) Take the master SKN table in your database and mark a spare field to be the same value for all 20K. That way you can select the new field instead of the 20K individual values. LBass was suggesting that you may already have a field you could use that maybe has one or a handfull of values. If you don't you might be able to create one.

4) If there are groups of SKNs that all start with the same value you could use a StartsWith comparison and maybe you could enter 100 startswith values instead of the 20K individual values.

4) Look for ranges of consecutive SKNs in your list and don't enter those individually. You can mix between and equal to as described in this article:

http://kenhamady.com/cru/archives/1257

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/