Do I need an Array? 1

[BradB]

CR8.5

Main Report and Subreport Shared Values

The Main Report needs information pulled from the subreport. I've connected both reports via links. The problem is I don't need totals. I need ALL data pulled from the subreport by the link to the Main Report.

For instance, I have a staff member on the main report, and 3 records of information on the staff member on the subreport. I want to use all three records in formula's on the main report. The Subreport has dates and values I need to associates with specific staff members on the Main Report.

If I use a shared variable, I will only get ONE of the records to pull to the main report. I need ALL the records.

BradB

 

[Ngolem]

you can create a shared array(or more) up to 1000 elements in each array to bring back data to the main report.

I have done this many times where the values can be gathered once and then used throughout the report...much better that hitting the database repeatedly for information.

Usually though using arrays requires more complex formulas in the main report to process the information but that is no problem if you are comfortable with that.

Jim

 

[BradB]

Can you point me to a help file or example of an shared array using database fields? The shared arrays in the help file don't have database fields used at all. The example's I've found have the following:

//days is a Local variable of String Array type
Shared StringVar Array days;
days := ["Sun", "Mon", "Tue", "Wed", "Th",
"Fri", "Sat"];

Any information would be helpful.

BradB

 

[Ngolem]

go to the Crystal Decisions Support site at

http://support.seagatesoftware.com/homepage/

and download the Technical Brief file : cr_arrays.pdf

This has the most current info on Arrays and how to use them

Jim