<div>
To add to what the others posted:<br />
<br />
&nbsp;You <u>can</u> use arrays in CR formulas, but the result of a formula can't be an array, so you can't, for example, pass an array to a subreport parameter by linking a formula to the parameter. &nbsp;If you want to give a list of values to a subreport, then you have to use one of the methods that the others described.<br />
<br />
&nbsp;Putting the list in a string doesn't necessarily have to hurt the subreport's performance. &nbsp;If the store number field is a number, then, as Raghavendra said, converting that field to a string in the subreport record selection formula could slow things down, because the subreport may have to read the records for every store and then convert the store number to a string to see if it's in the list (rather than ask the db to only send the records for the desired stores). &nbsp;However, rather than convert the store number to a string, you can convert the values in the string from the main report back into numbers. &nbsp;The difference is that CR should do that just once (for each subreport), and then it can send the list of numbers to the db so that the subreport only reads those stores.<br />
<br />
&nbsp;I can provide more details if you like.<br />
<br />
&nbsp;James
</div>


<div>
I have converted the array to characters successfully. &nbsp;And used shared array to get it to subreport. &nbsp;I wonder how I would do what James0628 suggested to convert it to numbers and send that to subreport? Details?
</div>


<div>
FWIW, Raghavendra probably should have gotten some points as well, since he was the first to suggest saving the numbers in a string. &nbsp;I handled it a bit differently, but it was the same basic idea. &nbsp;If you like, you can ask to have the question reopened, and then you can split the points between the three of us.<br />
<br />
&nbsp;James
</div>


<div>
<div class="content wysiwyg-content">
I have a report that shows sales by department. Within each department, it lists by group the top 5 stores. &nbsp;I need to pass the store numbers to a subreport after they have all printed to do some other calculations using another table that won't link to this one. &nbsp;How do I capture those top 5 store numbers? Or is it even possible to send them as a list to the subreport?
</div>
</div>


I have a report that shows sales by department. Within each department, it lists by group the top 5 stores.  I need to pass the store numbers to a subreport after they have all printed to do some other calculations using another table that won't link to this one.  How do I capture those top 5 store numbers? Or is it even possible to send them as a list to the subreport?

Capture list of Top N group sort

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.