record selection

[unknownly]

FUNid CONDITION OBJECT TYPE OBJECT ID
--------------------------------------------------
FUNC1 TCP1 type1 objid1
FUNC1 TCP1 type1 objid2
FUNC1 TCP1 type2 corp

FUNC2 TCP2 type1 objid1
FUNC2 TCP2 type1 objid2
FUNC2 TCP2 type2 corp

FUNC3 TCP3 type1 objid1
FUNC3 TCP3 type1 objid2
FUNC3 TCP3 type2 corp

FUNF1 TCP1 type1 objid1
FUNF1 TCP1 type1 objid2
FUNF1 TCP1 type2 FIELD

FUNF2 TCP2 type1 objid1
FUNF2 TCP2 type1 objid2
FUNC2 TCP2 type2 FIELD

FUNF3 TCP3 type1 objid1
FUNF3 TCP3 type1 objid2
FUNF3 TCP3 type2 FIELD


This how ther eport displays now. But My user came up with a new adition to the report by prompt.

{?object id} will be picked from a pick list which would be either Field or Corp

Then I should be able to display the report base on the parameter.

say {?object id} = 'field' then I should be able to display only bottom 3 FUNid and details.

FUNid CONDITION OBJECT TYPE OBJECT ID
--------------------------------------------------
FUNF1 TCP1 type1 objid1
FUNF1 TCP1 type1 objid2
FUNF1 TCP1 type2 FIELD

FUNF2 TCP2 type1 objid1
FUNF2 TCP2 type1 objid2
FUNC2 TCP2 type2 FIELD

FUNF3 TCP3 type1 objid1
FUNF3 TCP3 type1 objid2
FUNF3 TCP3 type2 FIELD

Can anyone help on how to do this or is it possible to do this??

Any help is Appreciated

Thanks in Advance,

Sweetie

 

[unknownly]

Using CR 8

 

[vidru]

Try a record selection formula like this:
[tt]
{Table.FUNid} in
(if {?object id} = "Field" then
["FUNF1","FUNF2","FUNF3"]
else
["FUNC1","FUNC2","FUNC3"]
)
[/tt]
-dave

 

[synapsevampire]

I think that the following will work, though I don't see any example "CORP" values in the object ID:

{table.funid} = {?Object ID}

This assumes that the ObjectID field = FIELD or CORP

If it's FIELD or anything else equals corp, use:

if {?Object ID} = "FIELD" then
{table.funid} = "FIELD"
else
{table.funid} <> "FIELD"

-k

 

[lbass]

Assuming that you have a group on {table.FunID}, then create a formula {@objID}:

if {table.objectID} = {?objID} then 1 else 0

Then go to report->edit selection formula->GROUP and enter:

sum({@objID},{table.FunID}) > 0

This should return the FunID groups containing the parameter value.

-LB

 

[unknownly]

Hi All,

Thank you all for the responds and I have tried all of your logic but LB's works exactly how and want I need.

Thanks again for all your help.