parameter field and selection formula?

[cristianivanoff]

Hello all,
I have a mainreport that links with a subreport with a number (Prodgroup). This number is then used in a formula like this in the subreport:

if {?Pm-@Reportprodgroup}= 221 then {TMS_SE_PRGRP.pg-code} in "500" to "599"
else if {?Pm-@Reportprodgroup}=222 then {TMS_SE_PRGRP.pg-code} in "600" to "699" or {TMS_SE_PRGRP.pg-code} in "720" to "721"

How can use this in my selection formula?


I use CR9.

Any help or suggestion is appreciated...

BR
Cristian

 

[synapsevampire]

Looks close as is, try:

(
if {?Pm-@Reportprodgroup}= 221 then
{TMS_SE_PRGRP.pg-code} in "500" to "599"
else if {?Pm-@Reportprodgroup}=222 then
(
{TMS_SE_PRGRP.pg-code} in "600" to "699"
or
{TMS_SE_PRGRP.pg-code} in "720" to "721"
)
else if not({?Pm-@Reportprodgroup} in [221,222] then
true
)

-k

 

[lbass]

You should be able to use a formula like:

(
if {?Pm-@Reportprodgroup} = 221 then
{TMS_SE_PRGRP.pg-code} in "500" to "599" else
if {?Pm-@Reportprodgroup} = 222 then
{TMS_SE_PRGRP.pg-code} in ["600" to "699","720" to "721"]
)

-LB

 

[synapsevampire]

Ooops, typo there:

(
if {?Pm-@Reportprodgroup}= 221 then
{TMS_SE_PRGRP.pg-code} in "500" to "599"
else if {?Pm-@Reportprodgroup}=222 then
(
{TMS_SE_PRGRP.pg-code} in "600" to "699"
or
{TMS_SE_PRGRP.pg-code} in "720" to "721"
)
else if not({?Pm-@Reportprodgroup} in [221,222]) then
true
)

 

[cristianivanoff]

thank you, so I can copy this formula to the selection formula with no problems. I thought that I had to rewrite the formula completely to work there.

Thanks again.

BR
Cristian