Array limitations - max subscript 1000

[UHsoccer]

Report: Show the top ten users and the top fiftenn websites they visited AND add the total browse time for those sites

I calculate the time difference between two succesive browse records and store that for future use.

Here I am in trouble already: Not knowing which sites I need to save, I need to store all of them in an array.

Crazy limitztion from Crystal says "but we will store no more than 1000 in an array!!!

There are thousands of records......

Any workaround (other than crating X number of arrays?

 

[IdoMillet]

Store the data in a table by exporting to ODBC. Then use the table created by the ODBC export as a data source.

hth,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[synapsevampire]

Possibly, can you find out what version of Crystal and what database you're using?

Very basic information like that is important in the design phase, you may get suggestions with lazy posts like this, but you should try to be thorough the first time through.

You mioght be able to use a View or SP on the database to reyrun the browse time rather than having Crystal do it, and if all you're going to do is show the sum of those values, don't use an array, use a formula or running total to keep the totals.

An example might be:

Group by User
Group by Website

Use the 3 formula method to keep a total of the time for each Website:

Website Group Header:
whileprintingrecords;
Numbervar SiteTot:=0;

Details:
whileprintingrecords;
Numbervar SiteTot:=SiteTot+<your calculation>;

Website Group Footer (display totals here):
whileprintingrecords;
Numbervar SiteTot

This will reset at each group level.

-k

 

[UHsoccer]

Crystal version 10 and a SQL data base

I am using the ODBC export and as long as the table gets refreshed, it is exactly what I needed

The 3 formul;a method would fail because at the time I need to save the web time there are too many to store (well over a 1000)

 

[IdoMillet]

ODBC exports from Crystal are limited to cases where the target table doesn't exist. Make sure you drop the table each time before you do the export.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[synapsevampire]

The 3 formula method doesn't store them, it simply displays at the group level...

Rather than explaining how things work to us, try reading and testing.

-k