Subreport Linking Range/Multiple Value Parameters 1

[groasa]

I'm afraid to see what the answer is, but I wanted to check with everyone here to see if there might be a way around this!!

The subreport is based on the container report so it is using the exact same parameters. I don't want the customer to have to input the same information twice (plus, there are 9 parameters as the container report stands alone) My problem comes because 3 of the parameters are not only ranges but multiple value ranges.

As I was searching through the FAQs, I found Ken Hamady's formulas for printing the ranges. So, I thought that maybe I could create formulas somehow and use those to link on, but I'm not quite sure how this is all going to work.

Any ideas?

I'm using CR v.7 w/ direct connect to BTRIEVE db for this customer. (If I create in 8.5 w/ Join function, would it be backwards compatible w/7?)

 

[sandrar]

Hi,

This might help! I created a formula that I use to link to subreport based on a multiple value parameter.Where I have operator put in your parameter name. use this to link your subreport. then when you go into your subreport change the record selection to field name in {pm-operatorname} .
The pm-operatorname is the parameter thats automatically creates when you link a subreport and will probably be pm and the name of your formula. Hope this helps!!!


if count({?operator}) = 1 then
totext({?operator}[1])
else if count ({?operator}) = 2 then
totext({?operator}[1]) + "," + totext({?operator}[2])
else if count ({?operator}) = 3 then
totext({?operator}[1]) + "," + totext({?operator}[2]) + "," + totext({?operator}[3])
else if count({?operator}) = 4 then
totext({?operator}[1]) + "," + totext({?operator}[2]) + "," + totext({?operator}[3])+ "," + totext({?operator}[4])
else if count ({?operator}) = 5 then
totext({?operator}[1]) + "," + totext({?operator}[2]) + "," + totext({?operator}[3])+ "," + totext({?operator}[4])+ "," + totext({?operator}[5])
else if count ({?operator}) = 6 then
totext({?operator}[1]) + "," + totext({?operator}[2]) + "," + totext({?operator}[3])+ "," + totext({?operator}[4])+ "," + totext({?operator}[5])+ "," + totext({?operator}[6])

 

[groasa]

Thank you! For the multiple discrete values, this looks like it will work. I also found the solution as Crystal Decisions knowledge base article:

http://support.crystaldecisions.com/library/kbase/articles/c2006803.asp

Do you know how to get this to work for the multiple range values?