Using variable arrays for subreport record selection.

[amcgreal]

Hi all.

I have a situation that I can't come up with a solution for. I have a report that calls a subreport. In the main report, I have an array that holds all the subdivision numbers that were printed out in a crosstab. I need the subreport (which holds another cross tab) to use that list of array values for record selection. Both cross tabs must hold the same subdivisions so that they line up on the report.

I don't know if there is a way to load a linked subreport parameter to this shared array variable somehow. How can I tell the subreoprt to use the array as a parameter?

Any help is greatly appreciated!

Thanks,
AJM

 

[synapsevampire]

I don't think that you can, but can't you just use the same record selection in the subreport?

Also, why would an array have values from a crosstab, I think that you mean that it has all of the values from the main report as I don't know of a way to populate an array from a crosstab.

You'll probably be better served to drop the subreport anyway, they're generally bad news.

If you post technical information people will have a shot at helping you:

Crystal version/edition
Database/connectivity used
Example data
Expected output

-k

 

[amcgreal]

I load the array with the break values of the group I'm using for the columns in the main report crosstab. I've been playing with using similar record selection but the tables that the sub uses is different than the main report and isn't easily brought together.

We are using version 11. SQL Server database via ODBC connection. I didn't include the table/file information because there are several and it's kind of confusing. I was just wondering if anyone knew of a way to pass a bucket of values into a subreport for it to use as data selection. Sounds unlikely which is what I thought.

Thanks for the help.
Amy