convert string to number array, pass to subreport

[ColinGregory]

Hello everyone

Is this possible?

I have a string in my report header (eg "452,563,1256") that I want to pass to a subreport as a set of numeric values that I can use to select the details of my subreport. The number of values in the string may change.

I've been working on this for two days. I'm sure I've tried every possible combination of parameters, shared variables. A straight forward link from the details of the main report to the sub report causes a not support error in Crystal. The ultimate aim is for the details in the subreport to be the same as the main report. My head hurts. Idiot proof replies please if possible to prevent melt down.

Many thanks
Colin

CR8 SQL server 2000

 

[SBendBuckeye]

Look at the Split function to create your array. Try something like this:

Global Shared NumberVar Array YourArray :=
Split(YourString, ",")

I believe a shared global variable is visible to your sub report as well. Good Luck!

Have a great day!

j2consulting@yahoo.com